Explore >> Select a destination
|
You are here 
|
sqlserverfast.com | ||
| | | | |
kendralittle.com
|
|
| | | | | How to see rowcounts and execution time for queries while they're running using sp_WhoIsActive and sys.dm_exec_query_statistics_xml, including when standard query profiling is needed for timing information. | |
| | | | |
matthewmcgiffen.com
|
|
| | | | | Statistics objects are important for allowing the SQL Server Optimizer to make good estimates and form efficient execution plans. Related to that it's useful for us to understand when statistics get updated - and where we might have to update them ourselves. This post details in what scenarios statistics get updated, as well as the thresholds used for automatic updating of statistics. | |
| | | | |
www.crunchydata.com
|
|
| | | | | Adding extended statistics can add information about how columns are related. Louise has some real life example queries and tips for working with extended table stats that can dramatically improve query performance. | |
| | | | |
troubleshootingsql.com
|
|
| | | 1 post published by Amit Banerjee on December 12, 2012 | ||
