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,301 reads
Klaus Aschenbrenner
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,499 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,822 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,427 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,563 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
897 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,414 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,346 reads
Performance improvements in SQL Server 2014
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-03-18
1,260 reads
Buffer Pool Extensions in SQL Server 2014
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-03-11
1,903 reads
Blogs
Advice I Like: Pyramid Schemes
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
Forums
Database file shrink issue.
Hi experts, I have a 3+ TB database on a 2019 sql server which...
The North Star for the Year
Comments posted to this topic are about the item The North Star for the...
Multiple Escape Characters
Comments posted to this topic are about the item Multiple Escape Characters
Question of the Day
Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers