Query Memory Spills
When you sometimes look at Execution Plans, you can see that the SELECT operator has
sometimes a so-called Memory Grant assigned....
2011-10-19
5,129 reads
Klaus Aschenbrenner
Slides & Samples for my Advanced SQL Server Troubleshooting session at SQLPASS
As I have announced in my "Advanced SQL Server Troubleshooting" session at SQLPASS
today, you can find here the
slides & samples for...
2011-10-14
772 reads
SQL Server Indexing Day, 18. Jänner 2012 in Wien
Sie wollen SQL Server
Abfragen um 100% oder gar 1000% beschleunigt haben? Gleichzeitig wollen Sie Hardware–
und Lizenzkosten Ihrer SQL Server Anwendungen...
2011-10-04
1,082 reads
Slides & Samples from my SQLbits sessions
As
I have announced in all of my sessions at the SQLbits conferences in Liverpool/UK,
you can find here the
Slides & Samples for...
2011-10-02
912 reads
Slides & Samples for my SolidQ Summit Sessions
As I have announced in all of my sessions last week in Budapest at the SolidQ summit,
you can find here...
2011-09-29
1,472 reads
Slides & Samples for my SQLdays Sessions
As I have announced in all of my sessions this week in Rosenheim/Germany at the SQLdays
conference can find here the
Slides...
2011-09-29
1,413 reads
SQLMCM Training – Day 18
Today we covered the topics Full Text Search, Change Data Capture, Change Tracking,
and Service Broker. I have taken no notes...
2011-08-26
969 reads
SQLMCM Training – Day 17
Today Bob spoke about Auditing, SQLCLR, XML, and Spatial Data. Because I already know
these concepts very well, my study notes...
2011-08-25
666 reads
SQLMCM Training – Day 16
Today Bob spoke the whole day about securing SQL Server, security itself, and encrypting
data. It was really hard content, and...
2011-08-24
633 reads
SQLMCM Training – Day 15
The whole last 3 days I've spent almost every minute with reviewing the material from
the last 2 weeks (around 38...
2011-08-23
620 reads
Blogs
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Monday Monitor Tips: SQL Auditing Preview
By Steve Jones
One of the features we advocates have been advocating for is a better way...
SQL Server 2025 CU1 Fixes the Docker Desktop AVX Issue on macOS
Microsoft fixed the AVX instruction issue in SQL Server 2025 CU1. The container now...
Forums
25 Years of SQL Server Central
Comments posted to this topic are about the item 25 Years of SQL Server...
The Decoded Value
Comments posted to this topic are about the item The Decoded Value
Deploying SQL Server Developer Edition in Kubernetes: A Cost-Effective Alternative to RDS
Comments posted to this topic are about the item Deploying SQL Server Developer Edition...
Question of the Day
The Decoded Value
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers