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

Content with tag Tuning Rss

   Items 1 to 11 of 11   
 

Report overlapping jobs

This script reports jobs which are running when another job is also running. This could be a reason for performance degradations.  Read more...
By Wilfred van Dijk 2014/07/31 | Source: SQLServerCentral.com | Category: sqlagent
Rating: |  Discuss |   Briefcase | 901 reads

Performance Tuning Through Panic

We've all been there, trying to improve performance in a panic situation and not making things better.  Read more...
By Steve Jones 2014/02/10 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 306 reads

Execution Plans

By Steve Jones 2014/01/31 | Category: tuning
Rating: (not yet rated) |  Discuss |   Briefcase | 2,043 reads

TEMPDB Configuration per vCPU

A simple script for automation of additional secondary data files of tempdb.  Read more...
By Paulo Nascimento 2014/01/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,899 reads

Unique Identifier as Clustered index

This script selects clustered indexes containing only a uniqueidentifier column  Read more...
By Wilfred van Dijk 2013/10/17 | Source: SQLServerCentral.com | Category: index
Rating: |  Discuss |   Briefcase | 1,113 reads

Optimizing a cursor based routine – Part 2

In the second part of his optimization series, Dave Ballantyne shows us how to add conditional logic to set based, more efficient T-SQL code.  Read more...
By Dave Ballantyne 2011/06/28 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,006 reads

Optimizing a cursor based routine – Part 1

Learn how you can remove a cursor and optimize a routine that loops through a series of data and performs various calculations in this short article from Dave Ballantyne.  Read more...
By Dave Ballantyne 2011/06/27 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,466 reads

Index usage overview

This view reports almost everything you want to know about your indexes  Read more...
By Wilfred van Dijk 2010/06/09 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 3,747 reads

Check status of HEAP tables

This SP reports the status of your heap tables. It gives you an overview of fragmentation, ghost record counts and forwarded record counts. Another reason to create a clustered index!  Read more...
By Wilfred van Dijk 2010/04/09 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,000 reads

Index usage overview

This view reports almost everything you want to know about your indexes  Read more...
By Wilfred van Dijk 2010/06/09 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 3,747 reads

Check status of HEAP tables

This SP reports the status of your heap tables. It gives you an overview of fragmentation, ghost record counts and forwarded record counts. Another reason to create a clustered index!  Read more...
By Wilfred van Dijk 2010/04/09 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,000 reads
   Items 1 to 11 of 11   
 
Tags
administration (3)    
performance (3)    
indexing (2)    
performance tuning (2)    
t-sql (2)    
editorial (1)    
execution plans (1)    
heap (1)    
index (1)    
jobs (1)    
maintenance (1)    
schedule (1)    
sqlagent (1)    
unique identifier (1)