Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tag Query performance Rss

   Items 1 to 3 of 3   

Demonstrating the Effects of Using Data Compression in SQL Server

How much space would compressing a particular index will save? How will this affect query performance? Derek Colley walks you through the effects of using data compression in SQL Server.  Read more...
By Additional Articles 2014/03/25 | Source: | Category: data compression
Rating: (not yet rated)  Rate this |   Briefcase | 4,240 reads

Techniques For Improving SQL Query Performance - Indexing, Parameterization and Partitioning

You are tasked with examining poor performance for queries on a certain table, or range of tables. Perhaps a sales report is timing out or running unacceptably slow; perhaps your web application is failing to return the result set before the application timeout is reached. You need to find out what's causing the bottleneck, and optimize either the queries used, the table schemata, or both.  Read more...
By Additional Articles 2013/09/06 | Source: | Category: query performance
Rating:  Rate this |   Briefcase | 6,122 reads

SQL Server Legend – Data Files and Threads

Someone was asking about using multiple data files recently to try and increase performance. I had answered that unless you...  Read more...
By Steve Jones 2009/10/20 | Source: | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,176 reads
   Items 1 to 3 of 3   
blogs (1)    
data compression (1)    
performance tuning (1)    
sql server (1)    
sql server 2005 (1)