Index selectivity and index scans
There was a question raised some time back ‘If an index is not selective, will the query operators that use...
2015-10-14 (first published: 2015-10-06)
4,251 reads
There was a question raised some time back ‘If an index is not selective, will the query operators that use...
2015-10-14 (first published: 2015-10-06)
4,251 reads
It’s a question which has come up a couple of times. If a subscriber of a transactional replication publication becomes...
2015-09-22
1,117 reads
I’ve come to really like Distributed Replay in the last couple of years. I’ve used it to do a scale...
2015-09-08
1,145 reads
There are many, many guides to successfully completing a post grad degree, so I am not going to add to...
2015-08-11
586 reads
Learning how to tune a system is a bit of science and a bit of an art. Gail Shaw gives some guidelines on when you might want to tune and how to go about it so as not to unnecessarily undertake the effort.
2014-09-22
5,870 reads
If you’re the type who habitually checks work email and thinks about work while on holiday, here’s Gail Shaw's challenge for next time: don’t.
2014-09-01
170 reads
Gail Shaw on the challenges of trying to extract meaningful data from a database containing customers who have the name 'Dummy **DO NOT USE**''.
2014-06-23
312 reads
How do you get help? You can post a question on SQLServerCentral, but to get the most help you can, read this article from MVP Gail Shaw.
2014-01-17 (first published: 2009-06-12)
64,214 reads
The announcement that the MCM program was being discontinued brings us a few thoughts from Gail Shaw, one of the 0.08% to achieve the certification.
2013-09-04
620 reads
Mirrored from http://www.sqlservercentral.com/articles/Editorial/101894/
By now I expect this news is no longer new: the MCM, MSA, and renamed versions of those...
2013-09-04
2,045 reads
I’m excited to be speaking at the Microsoft Fabric Community Conference this year, which...
The AI revolution isn’t coming – it’s here. Companies are racing to integrate artificial...
Introduction Do you remember the effort of tidying up your BI and reporting systems,...
Several times in the last couple of days I've had submissions time out with...
In the ss below I highlighted several rows in each block showing tables in...
In the ss below I highlighted several rows in each block showing tables in...
What is the output of this code in SQL Server 2022?
select bit_count(0xEF)See possible answers