The mystery of the NULL bitmap mask
In today's weblog post I want to talk about the NULL bitmap mask and some mysteries
that you can encounter with...
2011-06-29
4,855 reads
Why I’m raising my son to be a nerd
A good read, from ESPN and CNN columnist, LZ Granderson: Why I’m raising my son to be a nerd.
We need...
2011-06-29
1,604 reads
Can you query a SSAS cube while it is processing?
I have always wondered if queries against a SSAS cube while it is processing would be forced to wait the...
2011-06-29
2,596 reads
SQLDIY: Tracking Space Usage At the Index Level
I am a fan of information, the more the merrier. Anytime I’m tasked with tracking a production server over the...
2011-06-29
1,433 reads
Understanding Benchmarks
That Means What?
Vizzini: HE DIDN’T FALL? INCONCEIVABLE.
Inigo Montoya: You keep using that word. I do not think it means...
2011-06-29
2,114 reads
Energy Efficient Offices
I work with a client that recently moved into a newly renovated space in a smaller office building. The renovation...
2011-06-29
888 reads
New Connect Item – TDE
Does the certificate matter for TDE? Apparently not as I found a number of people discussing the fact that the...
2011-06-29
1,188 reads
Cleaner T-SQL with Table Value Constructors
Table Value Constructors were introduced in SQL Server 2008 and enables you to (not only) insert more records with one...
2011-06-29
969 reads
A Lost Day
I’m not sure what happened, but I had some sort of stomach bug yesterday. I was up throughout the night...
2011-06-28
868 reads
Getting Ahead and Getting Involved
I spend a little time on AskSSC (that is the question and answer section on http://www.sqlservercentral.com). Quite often the question...
2011-06-28
883 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
Forums
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
A Worse Computer; A Better Car
Comments posted to this topic are about the item A Worse Computer; A Better...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers