2017-09-27
211 reads
Kenneth Fisher
SQL Puzzle – Prime Numbers
My goal here is to have something fun (and hopefully educational/thinky) (and yes, I did just make up the word...
2017-09-27
460 reads
Saving and restoring session options settings
There are a fair number of options settings. ANSI_NULLS, ARITHABORT, QUOTED_IDENTIFIER, etc. Each session has its own set of configurations....
2017-09-25
479 reads
Uniquifier is a rather unique word isn’t it?
tl;dr; The uniquifier is used to make a non-unique key in a clustered index unique.
Uniquifier is a rather funny name,...
2017-09-22 (first published: 2017-09-18)
1,656 reads
Do what I say, not what I do
I told you not to use NOLOCK even though I use it sometimes.I told you not to shrink databases, even...
2017-09-20
435 reads
Help! My query is too fast!
Said no one ever. Well, maybe. I have had occasions where I needed a brief pause in the middle of...
2017-09-20 (first published: 2017-09-14)
3,241 reads
Turn on/off Azure VMs with Powershell
T-SQL Tuesday has rolled up on us yet again. This month it’s Rob Sewell’s (b/t) turn to host and picked...
2017-09-12
442 reads
Create an empty table from a SELECT statement but without the IDENTITY.
A while back I did a post about creating an empty table using a SELECT statement. Basically doing something like...
2017-09-11 (first published: 2017-08-28)
3,074 reads
There EXISTS a place where SELECT 1/0 doesn’t return an error.
Kendra Little (b/t) reminded me of this fun little trick (with fairly important ramifications) in her latest quiz on logical...
2017-09-07
661 reads
Changing the version of an SSIS package.
Of all of the annoying parts of SSIS, the major version sensitivity has to be the most annoying. Let’s say...
2017-09-06 (first published: 2017-08-23)
3,419 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
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...
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