SQL Server Performance

Search Results

Search Again
  1. pl800

    SSIS - Error during build when two packages use the same configuration file

    Thread by: pl800, Apr 3, 2012, 0 replies, in forum: SQL Server 2005 Integration Services
    During the build of an SSIS project I'm getting an error: "the file MyConfig.dtsconfig ... already exists". This happens when...
  2. pl800

    advanced query - help needed

    Thread by: pl800, Dec 7, 2011, 1 replies, in forum: SQL Server 2008 T-SQL Performance Tuning
    I need a rather advanced query that transforms data from a table to a specified format. I am providing a screenshot of the initial and desired...
  3. pl800

    improve performance of an update query

    Post by: pl800, Sep 8, 2011 in forum: SQL Server 2005 Performance Tuning for DBAs
    Preethiviraj, Number 1 from your answer pointed me in the right direction. The solution is to have a clustered index in which My_Time and My_ID are...
  4. pl800

    improve performance of an update query

    Post by: pl800, Sep 5, 2011 in forum: SQL Server 2005 Performance Tuning for DBAs
    [ATTACH]
  5. pl800

    improve performance of an update query

    Post by: pl800, Sep 5, 2011 in forum: SQL Server 2005 Performance Tuning for DBAs
    1.What is the clustered key of the table? None, but adding one on an additional int identity column did not speed up the query. 2.What is the...
  6. pl800

    improve performance of an update query

    Thread by: pl800, Sep 1, 2011, 6 replies, in forum: SQL Server 2005 Performance Tuning for DBAs
    How can I improve performance of an Update Query? The query is as follows (with table and column names changed): UPDATE MyTable SET MyTime = 'Aug...
Showing results 1 to 6 of 6
Search Again