SQL Server Performance

Search Results

Search Again
Page 1 of 2
  1. null

    "The Lookup transformation failed to retrieve any rows."

    Thread by: null, Feb 26, 2009, 0 replies, in forum: SQL Server 2005 Integration Services
    Guys and Gals, I have an SSIS package that processes a Slowly Changing Dimension. My source data is provided by an Ole Db Source operation that...
  2. null

    Is there anyway to find out when a table was dropped, and by what user?

    Post by: null, Jan 5, 2009 in forum: SQL Server 2005 General DBA Questions
    Very nice, this info definitely helped. As per the root of the problem, yes, this was indeed due to improperly manged permissions for a specific...
  3. null

    Is there anyway to find out when a table was dropped, and by what user?

    Thread by: null, Dec 30, 2008, 5 replies, in forum: SQL Server 2005 General DBA Questions
    I'm trying to find out when a table was dropped, and by what user ... though I couldn't find out any info on how to do this. DDL triggers weren't in...
  4. null

    Using loops to improve performance?

    Post by: null, Nov 19, 2008 in forum: SQL Server 2005 T-SQL Performance Tuning
    I appreciate the added feedback Michelle, thx for taking the time to add that.
  5. null

    Using loops to improve performance?

    Post by: null, Oct 30, 2008 in forum: SQL Server 2005 T-SQL Performance Tuning
    Thanks Guys. I suspected this may've had something to do w/saving resources w/locks and the transaction log. I'm familiar w/how that could work...
  6. null

    Using loops to improve performance?

    Thread by: null, Oct 29, 2008, 6 replies, in forum: SQL Server 2005 T-SQL Performance Tuning
    I've seen this a handful of times over the years... When updating "large" tables, let's say, a table with 200 - 300 million rows ... instead of...
  7. null

    Update over linked server connection ... CURSORUPDATE?

    Post by: null, Oct 29, 2008 in forum: SQL Server 2005 Performance Tuning for DBAs
    Both servers are running Sql Server 2005 SP 2. Btw, I refactored the 2 jobs such that the remote call is issued on a stored procedure, vs. embedding...
  8. null

    Update over linked server connection ... CURSORUPDATE?

    Thread by: null, Oct 24, 2008, 2 replies, in forum: SQL Server 2005 Performance Tuning for DBAs
    I'm performing a very simple update over a linked server connection. I'm setting a bit column in a table to 1, marking it as "replicated". I have a...
  9. null

    Possible to get qry statistics in a result set?

    Thread by: null, Dec 15, 2006, 1 replies, in forum: T-SQL Performance Tuning for Developers
    Stats from SET STATISTICS IO ON and SET STATISTICS TIME ON, is there a way to get those into a result set? Purpose being that I benchmark qry's...
  10. null

    View Optimization

    Post by: null, Jan 15, 2006 in forum: T-SQL Performance Tuning for Developers
    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote">will putting a where clause...
  11. null

    Deleting 230 rows takes over 3:30 **SOLVED**

    Post by: null, Dec 15, 2005 in forum: T-SQL Performance Tuning for Developers
    any delete triggers on the table?
  12. null

    Update on huge volumes takes long time

    Post by: null, Nov 22, 2005 in forum: T-SQL Performance Tuning for Developers
    You sure you're updating only the records that need to be? Ie. if you updated half the records a couple of hrs ago, or yesterday even, are you sure...
  13. null

    Using UNION Select Top 5 *

    Post by: null, Nov 19, 2005 in forum: T-SQL Performance Tuning for Developers
    Sure thing, I came back to the thread and noticed a small typo, I noted it below the reply. Btw, thx for the positive comments. I still consider...
  14. null

    Using UNION Select Top 5 *

    Post by: null, Nov 18, 2005 in forum: T-SQL Performance Tuning for Developers
    druer, You're right on, most the guys I've talked to never found a "need" to use Union All. Many of our developers are just after the dang "result...
  15. null

    Using UNION Select Top 5 *

    Post by: null, Nov 18, 2005 in forum: T-SQL Performance Tuning for Developers
    quote:Originally posted by Adriaan Don't bother with UNION here, unless you test and find that it performs better than WHERE city = 'London' OR city...
  16. null

    Using UNION Select Top 5 *

    Post by: null, Nov 18, 2005 in forum: T-SQL Performance Tuning for Developers
    quote:Originally posted by surendrakalekar Hi Madhivanan and Null.... Thanks I was unknow about it. Can you provide me some good link which will...
  17. null

    Using UNION Select Top 5 *

    Post by: null, Nov 17, 2005 in forum: T-SQL Performance Tuning for Developers
    W/the limited amount of info you've provided, I agree w/druer. The only exception is that I'd go w/union all instead of union... set rowCount 5...
  18. null

    WHERE or INNER JOIN

    Post by: null, Nov 17, 2005 in forum: T-SQL Performance Tuning for Developers
    Another side effect of specifying an option for the join type is I believe it could also change the order in which sql server tries to join the...
  19. null

    NOLOCK and Store Procedures

    Post by: null, Oct 31, 2005 in forum: T-SQL Performance Tuning for Developers
    quote:Originally posted by x002548 DON'T USE (NOLOCK) It's probably the fastest way to hose your database Brett Brett, do you mind elaborating on...
  20. null

    NOLOCK and Store Procedures

    Post by: null, Oct 23, 2005 in forum: T-SQL Performance Tuning for Developers
    quote:Originally posted by sachinsamuel So you need to strike out a balance between the volume of modification which are carried on the tables....
Showing results 1 to 20 of 23 Next >
Search Again
Page 1 of 2