My Partitioning And Compression Quest!
So I have a pretty big database (around 1 TB) that’s getting a bit out of
hand. I inherited it...
2011-05-03
660 reads
Blog Posts
T-SQL Tuesday #18 Coming Next Week
Other than the week I hosted it, I’ve been caught off guard by T-SQL Tuesday most months. This time I...
2011-05-03
689 reads
2011-05-02
9 reads
2011-05-02
5 reads
Checkpoints and the Lazy writer
Hi,
Both the lazy writer process and a checkpoint both push in-memory pages out to disk, however that’s where the similarity ends.
The reason...
2011-05-02
20,333 reads
Foreign Keys Help Performance
I have always put FKs into my database for data integrity purposes. I’ve worked on enough applications that didn’t have...
2011-05-02
1,257 reads
I’m an ACE
I am happy to announce that I’ll be joining Idera’s Advisor & Community Educator for SQL Server program.
Getting More Involved
I’ve always...
2011-05-02
491 reads
I’ve got 99 Problems, but a disk ain’t one
Tom LaRock has a new meme for Meme Monday. It’s all about the problems caused in your system other than...
2011-05-02
797 reads
Meme Monday – “I got 99 problems but a disk ain’t one”
Today is Meme Monday and is a little thing that Thomas LaRock (Blog | Twitter) has started. Today he has started things off with a list of things that...
2011-05-02
12 reads
Meme Monday – “I got 99 problems but a disk ain’t one”
Earlier today, Thomas LaRock (Blog | @SQLRockstar) tagged me for his Meme Monday post. The question for today is: how many...
2011-05-02
572 reads
Blogs
Getting the SQL Server MCP Server Running
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
Rambling about Data on Wheels – origins, branding, expansion
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
DBCC CHECKDB Limits III
Comments posted to this topic are about the item DBCC CHECKDB Limits III
CROSS APPLY Fundamentals: Part 1
Comments posted to this topic are about the item CROSS APPLY Fundamentals: Part 1
Question of the Day
DBCC CHECKDB Limits III
On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?
See possible answers