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,596 reads
SQL In The Wild
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,941 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,701 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
763 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,805 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
778 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,262 reads
Converting OR to Union
When I looked at indexing for queries containing predicates combined with OR, it became clear that the are some restrictive...
2011-07-05
1,661 reads
Are all updates split into delete-insert?
This should be another quick one.
Earlier I saw a forum post where someone asserted that SQL always executes an update...
2011-06-21
4,821 reads
T-SQL Tuesday: Disasters don’t just come in huge
So we’re supposed to talk about disasters we’ve had or discuss disaster recovery technologies. I’m going to take a slightly...
2011-06-14
743 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers