SQL Server Performance

Search Results

Search Again
  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?

    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...
  3. 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...
  4. 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...
  5. 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...
  6. null

    gains from storing values in variables?

    Thread by: null, Oct 20, 2005, 2 replies, in forum: T-SQL Performance Tuning for Developers
    I have a proc that uses dateAdd() and getDate() throughout. I thought that by storing the derived values in variables I could pick up some...
Showing results 1 to 6 of 6
Search Again