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,628 reads
Gail Shaw
- Interests: Computer Graphics, Aikido, Roleplaying
SQL University: Advanced Indexing – Indexing Strategies
Right, I know it’s Friday and everyone’s tired and looking forward to the weekend, but I do need to finish...
2011-11-11
1,598 reads
SQL University: Advanced Indexing – Filtered Indexes
Welcome back to day 2 of Advanced Indexing. Today we’re going to look at a feature that was added in...
2011-11-09
1,949 reads
SQL University: Advanced indexing – Sorting and Grouping
Good day everyone and welcome to another week of SQL University. I know we’re getting close to the end of...
2011-11-07
2,704 reads
24 Hours of PASS Questions
I finally found the time to work through the questions from the 24 Hours of PASS session that I did....
2011-09-27
765 reads
Recovery Models
Learn the basics of recovery models in this short article from SQL Server guru and MVP, Gail Shaw.
2011-09-01
8,017 reads
Compiles and recompiles
I want to spend some time over the next few months looking at query compilation and the plan cache, and...
2011-08-16
3,863 reads
All about Execution Plans
Coming to the PASS Summit in October this year? Excellent!
I say excellent, because Grant (blog|twitter) and I are presenting a...
2011-08-09
781 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
828 reads
SQLSkills Immersion training in London
Just short of the winter solstice, I bailed out of a freezing cold Johannesburg for warmer climates; well, actually for...
2011-07-22
1,264 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...
Hyperscale Replicas IV
Comments posted to this topic are about the item Hyperscale Replicas IV
The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek
Comments posted to this topic are about the item The SQL Server Date Magic:...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers