SQL Server Tipping Games – Why Non-Clustered Indexes are just ignored!
Almost everytime when I’m doing SQL Server consulting engagements, DBAs are showing me queries and their Execution Plans, where SQL...
2013-06-12
1,609 reads
Klaus Aschenbrenner
My 2 cents on SQL Server 2014
Yesterday during the opening keynote of TechEd North America Microsoft released the first official details about the next version of...
2013-06-04
2,791 reads
Windows, RIP (1992 – 2013)
Today is a very sad day for me. My love, my dear Windows has passed away. We were together for...
2013-05-17
1,075 reads
The dangerous beauty of Bookmark Lookups
Every one of us knows Bookmark Lookups in SQL Server. They are great, because you don’t need to care about...
2013-04-15
752 reads
Become an expert in SQL Server Performance Tuning & Troubleshooting!
Since September 2012 I'm a Microsoft Certified Master SQL Server 2008,
which is the highest technical certification for SQL Server that...
2013-02-13
1,043 reads
Become an expert in SQL Server Performance Tuning & Troubleshooting!
Since September 2012 I’m a Microsoft Certified Master SQL Server 2008, which is the highest technical certification for SQL Server...
2013-02-13
813 reads
SQL Server Quickie #5 – Bookmark Lookup Deadlocks
Today I have uploaded the 5th SQL Server Quickie to YouTube. This time Santa Claus
talks about Bookmark Lookup Deadlocks in...
2012-12-16
1,511 reads
SQL Server Quickie #5 – Bookmark Lookup Deadlocks
Today I have uploaded the 5th SQL Server Quickie to YouTube. This time Santa Claus talks about Bookmark Lookup Deadlocks...
2012-12-16
837 reads
Practical SQL Server Performance Troubleshooting Day
Due to the huge demand of SQL Server Troubleshooting Know How and Techniques I'm running
on January 29 (Vienna/Austria) and January...
2012-12-10
2,447 reads
Practical SQL Server Performance Troubleshooting Day
Due to the huge demand of SQL Server Troubleshooting Know How and Techniques I’m running on January 29 (Vienna/Austria) and...
2012-12-10
1,188 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