In the last year I’ve published articles on indexes to include Indexes: When Column Selectivity Is Not Always A Requirement – SQLServerCentral and Query Optimizer Suggests Wrong Index and Query Plan -- Why? – SQLServerCentral. This article is a continuation of just how the optimizer interacts with the index wizard. We’ve all heard and read […]
2021-07-07
3,537 reads
Pinal Dave explains how missing index hints are like restaurant appetizers.
2018-08-03
5,219 reads
So, you want to get your SQL skills razor-sharp without dropping any cash? You're...
By Steve Jones
Here are the slides from my talk today at the Redgate NYC Devour Hour:...
By Steve Jones
If you have any doubt about being able to carry a load in one...
Pure Leaf CBD, in particular, has gained attention as a high-quality CBD product that...
Hi everyone I have a SP that just failed. Format of SP is: Select...
Comments posted to this topic are about the item Analyzing Tempdb Spills and Usage...
If I run "dab init" to create a new API over a database, what parameters are required?
See possible answers