How efficient is your covered index?
Observing an index seek utilizing a composite index within SQL execution plan might be more than meets the eye – you should look again.
2015-10-09 (first published: 2013-08-12)
14,137 reads
covering index
Blogs
New Centralized View of SQL Resources in Azure
Yesterday, some new views were made available in the Azure portal that will be...
Letter To My Father
We spread my Fathers ashes over the past weekend. It was one of the...
My Organizer's Notes and Goodbye after #SQLSatBR 2019
Some 2019 tips for other SQLSat organizers from my last year as lead organizer...
Forums
AOAG Secondary Checkdb
I'm looking into setting up a AOAG with a DR server which will have...
sp_executesql with multiple parameters
I'm trying to write a stored procedure that will select the entire table if...
SQL Server 2016 Archive Strategy advice.
Greetings. I’m after some advice. I’m helping a colleague with a SQL Server 2016...
Ask SSC