Gail Shaw is a database specialist from Johannesburg, South Africa, specializing in performance tuning and database optimization. Gail works for Entelect, a medium-sized custom software development house based in Johannedburg. Gail is a frequent poster on the SQLServerCentral.com forums and writes for Simple-Talk. She is an MVP for SQL Server and holds the Microsoft Certified Master certification for SQL Server
|
Another year over and much as I did last year, I’m going to briefly go over the books I read this last year. I will freely admit, very few of these could be considered ‘classic literature’, most is a mix of sci-fi, fantasy or adventure fiction. That’s just what I like to ...
|
|
Right, I know it’s Friday and everyone’s tired and looking forward to the weekend, but I do need to finish off this indexing section and I’ll try to keep this short and interesting and hopefully keep everyone awake. There’s no shortage of information available on how to ...
|
|
Welcome back to day 2 of Advanced Indexing. Today we’re going to look at a feature that was added in SQL Server 2008 – filtered indexes. In versions previous, indexes were always on the entire table. An index would always have the same number of rows as the table it was built on did ...
|
|
Good day everyone and welcome to another week of SQL University. I know we’re getting close to the end of the year and everyone’s looking forward to a nice long vacation soaking up the sun at the beach, but a little bit of attention would be nice. Thank you. This week is Advanced Indexing, and ...
|
|
I finally found the time to work through the questions from the 24 Hours of PASS session that I did. Thanks to everyone that attended the event Q1: Can you filter execution plans for sort warnings? No. The sort and hash warnings don’t appear in the execution plan. You’d have to trace for the hash ...
|