Explore >> Select a destination
|
You are here 
|
rusanu.com | ||
| | | | |
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. | |
| | | | |
dbanuggets.com
|
|
| | | | | Source: Image Query Store hints is another amazing feature added and is available in the preview mode in Azure SQL Database, managed instances, elastic pools and hyperscale databases as well. Query Store hints are just like the hints you use in your queries but the difference is you do not have to change the query... | |
| | | | |
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. | |
| | | | |
callihandata.com
|
|
| | | How many SQL Server upgrades have you been a part of? Was there much discussion about whether or not to do an in-place upgrade versus a side-by-side upgrade? I've been part of both and to me there is only one safe way to perform upgrades. Let's go over some pros and cons of each and... | ||
