Managing Transaction Logs
A great article that should answer all your questions about the transaction log from MVP Gail Shaw. A must read for all DBAs.
2012-01-03 (first published: 2008-10-31)
73,235 reads
Gail Shaw
- Interests: Computer Graphics, Aikido, Roleplaying
Recovery Models
Learn the basics of recovery models in this short article from SQL Server guru and MVP, Gail Shaw.
2011-09-01
7,947 reads
SQLSkills Immersion training in London
A wrap up from MVP and expert Gail Shaw on her experiences of training with SQLskills.
2011-07-27
811 reads
Statistics, row estimations and the ascending date column
SQL’s auto-updating statistics go a fair way to making SQL Server a self-tuning database engine and in many cases they...
2011-03-28
1,643 reads
And now for a completely inappropriate use of SQL Server
A while back I wrote up a short introductory overview of Genetic Algorithms. Just for the shear, absolute fun of...
2011-02-28
2,838 reads
Distincting an IN subquery
This is going to be a quick one…
I keep seeing forum code (and production code) that includes the DISTINCT in...
2011-01-26
5,455 reads
Do IF statements cause recompiles?
I heard this one over at SSC a while back. “Avoid IF statements in stored procedures as they result in...
2010-12-15
3,713 reads
Help, my database is corrupt. Now what?
The stuff of nightmares, a corrupt database. However Gail Shaw gives you some advice about how to handle this situation.
2010-04-23 (first published: 2009-02-16)
64,090 reads
2010-04-01
3,279 reads
Left outer join vs NOT EXISTS
And to wrap up the miniseries on IN, EXISTS and JOIN, a look at NOT EXISTS and LEFT OUTER JOIN...
2010-03-25
5,209 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Krekot Bunder Telpon/WA:087768193341
BCA KCP Krekot Bunder Telpon/WA:087768193341.Jl. Krekot Bunder Raya No.28, Ps. Baru, Kecamatan Sawah Besar,...
BCA Finance Kelapa Gading Layanan Mobil. Tlp:(+62) 8218168235
Ruko Mall Of Indonesia Blok B 32-33, RT.18/RW.8, Klp. Gading Bar., Kec. Klp. Gading,...
BCA KCP Tanah Abang Zona 3 Telpon/WA:087768193341
BCA KCP Tanah Abang Zona 3 Telpon/WA:087768193341.Gedung Tanah Abang Zona III Lantai 3A L03A,...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers