Tuesday, March 6, 2012

statistics cheat sheet

create statistics customers_stats on customers(name)  with fullscan
update statistics customers with fullscan
--checking statistics on tables
dbcc show_statistics ('customers','customers_stats')
sp_createstats
sp_updatestats
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)