Speaking at SQLSaturday #310 in Dublin/Ireland
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-05-26
758 reads
Klaus Aschenbrenner
Statistics with Ascending Key Column Values
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-05-19
1,535 reads
Debugging a SQL Server query with WinDbg
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-05-13
2,310 reads
SQL Server Debugging with WinDbg – an Introduction
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-05-13 (first published: 2014-05-05)
5,513 reads
SQL Server Quickie #13 – Hash Join Operator
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-04-29
1,831 reads
A ever-increasing Clustered Key value doesn’t scale!
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-04-15
1,432 reads
Improving Query Performance by using correct Search Arguments
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-04-18 (first published: 2014-04-08)
6,577 reads
Goodbye SQL Server, Hello FileMaker…
The last weeks were very time consuming for me, because I had to make a very tough decision: staying independent...
2014-04-01
908 reads
SQL Server Quickie #12 – Nested Loop Operator
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-03-31
1,415 reads
The Illusion of Updateable Clustered ColumnStore Indexes
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-03-31 (first published: 2014-03-25)
2,366 reads
Blogs
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
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...
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