Instant File Initialization – Is it Turned On?
I have posted a short note on instant file initialization previously, that post can be found here. The crux of...
2010-09-21
1,738 reads
Table Variables and Transactions
I actually had a question of the day submitted on SQLServerCentral about table variables and transactions, but the person didn’t...
2010-09-21
9,383 reads
On Vacation
I’ve hit that point where it feels like I need to work longer and harder to keep up, which is...
2010-09-21
591 reads
Putting Priorities into Practice
Yesterday I posted a review on the book Choosing to Cheat. I had begun putting some of the principles into...
2010-09-21
906 reads
SQL Saturday 50 (#sqlsat50) – A Tale
This past weekend I went to SQL Saturday 50 – this is a day long SQL training event that is put...
2010-09-21
835 reads
SSAS - Defining Attribute Relationships in 2005 and 2008
Attribute relationships inside of Analysis Services are a critical piece to the design of your dimensions.The benefits of creating attribute...
2010-09-20
1,609 reads
What Do You Think Just Happened To This Database Server?
This is a screenshot of Task Manager for a database instance that is part of a synchronous database mirroring partnership...
2010-09-20
1,196 reads
Most SQL Server DBAs Still Don’t Know About Instant File Initialization
In my most recent poll, I asked DBAs if they have turned on instant file initialization on their SQL Servers....
2010-09-20
912 reads
Breaking Into SQL Showbiz
You can tell by my face, I'm an expert
Matthew Velic (blog, Twitter) just asked this question on Twitter:
And really that’s...
2010-09-20
715 reads
PASS Update #43
Last Friday saw the end of the 2010 PASS election and it was very nice to find out I had...
2010-09-20
637 reads
Blogs
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Forums
SQL Server Vector Support II
Comments posted to this topic are about the item SQL Server Vector Support II
Great Things
Comments posted to this topic are about the item Great Things
Troubleshooting Slow Queries That Already Have an Index
Comments posted to this topic are about the item Troubleshooting Slow Queries That Already...
Question of the Day
SQL Server Vector Support II
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers