Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Database Weekly, Performance Tuning, Editorial Rss

   Items 1 to 6 of 6   
 

The Clonesome Database

You need a quiet couple of hours poking about with DMVs, and checking execution plans to get to the bottom of the a query issue, but you can't make a copy the production database either. It's too big, and the data is private....  Read more...
By Phil Factor 2012/03/26 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 197 reads

Can I really drop that index?

You believe that an index is unused and so could be removed, and yet, your finger hovers nervously over the metaphorical "delete" button. You can't quite bring yourself to do it. Is it really safe to drop this index? Tony wonders if "invisible indexes" might solve this dilemma.  Read more...
By Tony Davis 2010/11/01 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 331 reads

(Un)Common Speed Phreakery

Is there such a thing as too much attention to the performance of SQL? It isn’t only a question of time and inclination, but also of the resilience and flexibility of the code.  Read more...
By Chris Massey 2010/08/09 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 140 reads

Knowing What's Normal

This week Database Weekly has a lot of performance related posts and Steve Jones notes that those are not of much use unless you know you really do have a performance problem.  Read more...
By Steve Jones 2010/06/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 142 reads

The Rich Rewards of Tuning SQL

The next time you are tempted to hammer a performance problem with hardware, why not instead invest that time in hammering and refining your SQL queries? There are rich rewards to be had.  Read more...
By Tony Davis 2009/11/02 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 274 reads

The Next Frontier of Performance Troubleshooting

The number of tools for troubleshooting SQL Server performance problems has recently expanded at a dizzying rate. Is the latest one any reason to get excited?  Read more...
By Tony Davis 2009/05/04 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 528 reads
   Items 1 to 6 of 6