How to merge (combine) date intervals in T-SQL
On my current project, I am dealing with date intervals in T-SQL very heavily. I’ve hit interesting issue recently – how...
2011-07-08
2,161 reads
Blog Posts
Learning From the Mistakes of Other DBAs
I have been a judge for the Exceptional DBA of the Year Awards ever since its inception, and one of...
2011-07-08
1,179 reads
Protected: Count to 41
This post is password protected. To view it please enter your password below:
Password:
2011-07-08
593 reads
Re-blog – July 1-July 7
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-07-08
461 reads
Showing slowest parts of SQL query
I’ve received interesting question/requirement few days ago:
“… When viewing a query plan graphically, we usually have to hunt for the...
2011-07-08
1,667 reads
Maciej Pilecki Speaking at Space Coast UG on July 14, 2011
Just got an email from the Space Coast User Group that Maciej Pilecki (@DrHouseOfSQL) will be doing a presentation to...
2011-07-07
614 reads
PASS Update #59 (Run for the Board)
If it hasn’t happened already we should be close to beginning the election cycle for the 2012 election. Last year...
2011-07-07
601 reads
SQLDIY: Index Fragmentation Levels
Indexes, indexes, indexes my kingdom for an index! Well, something like that. Indexes are the single most important structure in...
2011-07-07
1,271 reads
SQLSaturday #85-Call for Pre-Con Speakers
We’re going to be hosting two pre-conference seminars this year in Orlando on Friday, September 23rd, and we’re looking for...
2011-07-07
420 reads
The IF Statement in a T-SQL Query
I’ve seen quite a few posts from people asking how to do something like this:
SELECT
a.ID
, IF a.MyChar = 'A' THEN...
2011-07-07
158,460 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