SQL Server Performance

Search Results

Search Again
  1. sqlwars

    All INDEX details query - gives duplicate entires

    Thread by: sqlwars, May 14, 2010, 5 replies, in forum: SQL Server 2005 T-SQL Performance Tuning
    HI, I mixed and matched many queries to give all details of index needed for analysis. However, the query returns duplicate values. how do i remove...
  2. sqlwars

    5 years experienced SQL Server DBA... what next?

    Thread by: sqlwars, May 6, 2010, 6 replies, in forum: The Lighter Side of Being a DBA
    I am a 5 years experienced SQL Server DBA. As soon as I was out of college, I was trained on SQL Server 2000 and pushed into Database...
  3. sqlwars

    To reduce CPU cost being used by SORT

    Thread by: sqlwars, Apr 26, 2010, 2 replies, in forum: SQL Server 2005 T-SQL Performance Tuning
    We are using a query and in its execution plan it utilizes 182% CPU cost while performing a sort. Please advice on how to reduce it. query structure:...
  4. sqlwars

    Will VIEW improve performance

    Thread by: sqlwars, Apr 20, 2010, 2 replies, in forum: SQL Server 2005 Performance Tuning for DBAs
    Hi, We have a report which run 15 store procedures to fetch the data. This report takes 1 hours to process during non buisness hours and about 4...
Showing results 1 to 4 of 4
Search Again