Query Performance Tuning – A Methodical Approach
Learn how to approach performance tuning in this piece from SQL Server MCM and MVP, Gail Shaw.
2017-02-10 (first published: 2015-06-08)
16,830 reads
Gail Shaw
- Interests: Computer Graphics, Aikido, Roleplaying
Premature Optimisation
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,938 reads
But, but, but, my data is clean!
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
349 reads
How to Post Performance Problems
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)
66,091 reads
SQL Server Transaction Log Management by Tony Davis and Gail Shaw
When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works. An effective response to a crisis requires rapid decisions based on understanding its role in ensuring data integrity.
2013-08-26
7,259 reads
Why is my transaction log full?
Why does the transaction log fill up? There are a variety of reasons, and MVP Gail Shaw walks you through the various things to check.
2012-08-31 (first published: 2011-02-21)
64,021 reads
Introduction to Indexes: Part 3 – The nonclustered index
Part 3 of a great series on the basics of indexes. Learn the structure, definition, and how to examine the use of these indexes in your queries.
2012-07-23 (first published: 2009-11-18)
53,558 reads
Introduction to Indexes: Part 2 – The clustered index
In the second part of her series on indexing, MVP Gail Shaw examines clustered indexes. Learn what this index is, how it differs from a heap, and how it can help your queries.
2012-07-06 (first published: 2009-11-11)
63,565 reads
Introduction to Indexes
Indexes are critical to good performance. However many people don't understand how indexes well. MVP Gail Shaw provides us with an introductory article on the basics of indexing.
2012-06-29 (first published: 2009-10-26)
105,395 reads
An examination of bulk-logged recovery model
This article looks at the bulk-logged recovery model in depth and examines how it affects disaster recovery and logging.
2012-05-07
7,272 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Trigger isn't working
Hi, I have a trigger, that works fine elsewhere but is not working at...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers