Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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,299 reads
<< Newer    Items 21 to 21 of 21   
 
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)    
t-sql (1)