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

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,313 reads
<< Newer    Items 21 to 21 of 21   
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)    
t-sql (1)