SQL Server Performance

Search Results

Search Again
  1. gah

    Optimizer not using index consistently

    Post by: gah, Jul 17, 2009 in forum: SQL Server 2005 T-SQL Performance Tuning
    There are about 300 million rows with unique keys. There are about 750,000 with unique <date_, id> fields. The optimizer definitely looks at more...
  2. gah

    Optimizer not using index consistently

    Post by: gah, Jul 16, 2009 in forum: SQL Server 2005 T-SQL Performance Tuning
    "if you have 2 indexes with same columns, SQL Server tries to choose the clustered index because its less expensive..." Thanks! Well, that looks...
  3. gah

    Optimizer not using index consistently

    Post by: gah, Jul 16, 2009 in forum: SQL Server 2005 T-SQL Performance Tuning
    Thanks. A few comments. First: it's inconsistent. If I execute "update statistics", SOMETIMES it uses the correct index; sometimes it does not....
  4. gah

    Selecting multiple rows based on next row value

    Post by: gah, Jul 16, 2009 in forum: SQL Server 2005 General Developer Questions
    A straightforward approach is to use a subquery: select * from table t1 where t1.signal = 0 and (select count(t2.signal) from table t2 where t2.id =...
  5. gah

    Optimizer not using index consistently

    Thread by: gah, Jul 16, 2009, 6 replies, in forum: SQL Server 2005 T-SQL Performance Tuning
    Hi, I have a table, call it T, with primary key: id int, date_ smalldatetime, f1 decimal(5,2), f2 smallint T is clustered on: date_, id, f1, f2 T...
Showing results 1 to 5 of 5
Search Again