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

Content with tags Indexing, statistics Rss

<< Newer    Items 21 to 22 of 22   
 

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, and SQL Server 2016.  Read more...
By Ola Hallengren 2016/07/11 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 44,931 reads

Statistics and Indexes

When is it okay to let SQL Server to make a statistic for columns in your queries, and when should you take those statistics and make an index out of them? What I do is to test all of my procs, and if they generate system statistics (_WA_SYS%), then I add an index to the table for the column in the statistic. But is this a good practice?  Read more...
By Additional Articles 2008/03/11 | Source: SQL Community | Category: indexing
Rating:  Rate this |   Briefcase | 3,314 reads
<< Newer    Items 21 to 22 of 22   
 
Tags
dmv (2)    
backup (1)    
density (1)    
distribution (1)    
integrity check (1)    
optimizer (1)    
performance tuning (1)    
sql server 2005 (1)    
sql server 2008 (1)    
sql server 2008 r2 (1)    
sql server 2012 (1)    
sql server 2014 (1)    
sql server 2016 (1)    
t-sql (1)