SQL Server Performance

Search Results

Search Again
  1. stekim

    how do I make 30 sec running query (select c1 sum(x) from t1 where c1 > 1000 group by c1) run faster?

    Thread by: stekim, Aug 9, 2007, 2 replies, in forum: SQL Server 2005 T-SQL Performance Tuning
    It seems when I run the query with the set staticts IO on then statistic reports back with the 'work table', and the query takes 30+ sec. if the...
  2. stekim

    what do you do with slow select sum() queries to speed them up?

    Post by: stekim, Aug 7, 2007 in forum: SQL Server 2005 Performance Tuning for DBAs
    The hardware can help but the aggregation like sum seems to not use the cache. I created temporary table and used that as my bases for the query and...
  3. stekim

    what do you do with slow select sum() queries to speed them up?

    Thread by: stekim, Aug 6, 2007, 7 replies, in forum: SQL Server 2005 Performance Tuning for DBAs
  4. stekim

    how do you account for fast count(fact) and slow sum(fact)?

    Thread by: stekim, Aug 6, 2007, 3 replies, in forum: SQL Server 2005 Performance Tuning for Hardware
Showing results 1 to 4 of 4
Search Again