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,848 reads
Blog Posts
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,103 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,602 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
865 reads
Attention Speakers–Sign Up for SQLSaturday #85 in Orlando!
Our call for speakers for #85 will be open about another 10 days, and then Bradley Ball can jump into...
2011-06-28
616 reads
Counting Licenses for VMs
This is old news, but I’ve had to explain SQL Server VM licensing to enough people recently that I thought...
2011-06-28
3,137 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
871 reads
HASHBYTES – A T-SQL Function
Someone was asking if the HASHBYTES function was a good one to use in T-SQL as far as performance goes.....
2011-06-28
15,125 reads
Instead Of Trigger and OUTPUT clause headache
It is known that you cannot get inserted identity values using OUTPUT clause when inserting to view which has instead...
2011-06-28
1,801 reads
Let’s Get Registered! Registered!
The PASS Summit is only a few short months away. But before that happens there is an important deadline fast...
2011-06-28
679 reads
Blogs
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Forums
BCA Wisma Asia II Lt 12 Tlpn:08213111133
RQ6X+98R, Jl. Brigjen Katamso No.1 4, RT.4/RW.9, Kota Bambu Sel., Kec. Palmerah, Kota Jakarta...
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers