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 12 of 12   
 

Query the execution plan cache

This query will find the execution plans stored in the plan cache for an object that you specify in the WHERE clause.  Read more...
By Derik Hammer 2014/10/02 | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 1,188 reads

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 | 1,172 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 | 310 reads

Execution Plans

By Steve Jones 2014/01/31 | Category: tuning
Rating: (not yet rated) |  Discuss |   Briefcase | 2,060 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,947 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,121 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,016 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,472 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,756 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,001 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,756 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,001 reads
   Items 1 to 12 of 12   
 
Tags
performance (4)    
administration (3)    
indexing (2)    
performance tuning (2)    
t-sql (2)    
editorial (1)    
execution plan (1)    
execution plans (1)    
heap (1)    
index (1)    
jobs (1)    
maintenance (1)    
schedule (1)    
sqlagent (1)    
unique identifier (1)