2016-09-13
1,212 reads
2016-09-13
1,212 reads
2016-02-24
1,463 reads
2016-01-14
1,783 reads
Want to 'trick' SQL Server into performing millions of logical reads to return data, when only are few thousand were really required? In this article, Gail Shaw examines three common forms of generic SQL that can and will confuse the SQL Server Optimizer to the point that it generates and reuses very inefficient execution plans.
2015-09-21
3,875 reads
SQL Server Query Optimizer uses statistical information to estimate the cardinality in a query result. This enables the SQL Server Query Optimizer to create a high-quality query execution plan. Read on to learn how to use statistics and why it’s needed.
2015-01-07
8,382 reads
2015-01-06
2,216 reads
Statistics keep track of our data and will tell SQL Server how to make the best optimization decisions. Knowing how they work can make understanding query and performance problems much easier!
2014-06-09
5,335 reads
Understanding execution plans is a good basic skill for all DBA's and SQL developers. Darren White gives us an overview of what execution plans are in SQL Server and how they are used.
2017-03-10 (first published: 2014-02-18)
30,490 reads
2013-09-19
2,849 reads
In this article, you will learn what query optimisation statistics are and how SQL Server query optimizer uses statistics. You will also learn how to create and manage statistics, and what are the different ways to determine when statistics were last updated in SQL Server.
2013-07-10
4,410 reads
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers