SQL Server Performance

Search Results

Search Again
  1. abbi

    Why is it using the Index

    Thread by: abbi, Mar 2, 2008, 8 replies, in forum: SQL Server 2005 Performance Tuning for DBAs
    I have a table with no primary key and a non-clustered composite index of two columns. When I look at the number of distinct values (selectivity...
  2. abbi

    execution plan question

    Thread by: abbi, Mar 2, 2008, 5 replies, in forum: SQL Server 2005 T-SQL Performance Tuning
    I have a query that accesses a table with a non-clustered index. When I drop the index and run the query, it takes 1.25 minutes to run. With the...
Showing results 1 to 2 of 2
Search Again