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.
2019-05-30 (first published: 2009-10-26)
104,451 reads
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,759 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,898 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
329 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)
65,181 reads
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,195 reads
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)
63,676 reads
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,416 reads
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,359 reads
This article looks at the bulk-logged recovery model in depth and examines how it affects disaster recovery and logging.
2012-05-07
7,229 reads
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
QLola BRI Anda bermasalah? Hubungi WhatsApp 08136035412 untuk mendapatkan bantuan profesional dengan proses yang...
Untuk bantuan QLola BRI, silakan hubungi WhatsApp 08136035412. Melayani kendala akun, transaksi, dan informasi...
Kini bantuan QLola BRI bisa diakses lebih mudah lewat WhatsApp 08136035412. Tanpa antri, cukup...
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers