A SQL Server Hardware Nugget A Day – Day 14
Since 2006, Intel has adopted a Tick-Tock strategy for developing and releasing new processor models. Every two years, they introduce...
2011-04-14
603 reads
Glenn Berry
A SQL Server Hardware Nugget A Day – Day 13
For Day 13 of this series, we will cover Intel Turbo Boost Technology. This is not like the the old...
2011-04-13
505 reads
A SQL Server Hardware Nugget A Day – Day 12
In Day 12 of this series, we will be talking about AMD Opteron Processor Numbering. Advanced Micro Devices (AMD) has...
2011-04-12
751 reads
April Version of SQL Server 2008 Diagnostic Queries
I have added two new queries to this month’s version, to try to collect some more hardware information about the...
2011-04-11
497 reads
A SQL Server Hardware Nugget A Day – Day 11
For Day 11, I want to talk about the new processor numbering system for Xeon processors that Intel introduced on...
2011-04-11
382 reads
A SQL Server Hardware Nugget A Day – Day 10
Wow, we are 1/3 of the way through this series! Today’s post is “Classic Intel Xeon Processor Numbering Explained”. By...
2011-04-10
361 reads
A SQL Server Hardware Nugget A Day – Day 9
For Day 9 of my SQL Server hardware series, I want to give my current recommended AMD Processor List for...
2011-04-10
596 reads
A SQL Server Hardware Nugget A Day – Day 8
For Day 8 of my SQL Server hardware series, I want to give my current recommended Intel Processor List for...
2011-04-08
422 reads
Presenting Dr. DMV by Live Meeting on April 19 at 12PM CDT
I will be presenting my Dr. DMV presentation for the St. Louis SQL Server User’s Group on April 19. Here...
2011-04-07
1,133 reads
A SQL Server Hardware Nugget A Day – Day 7
For Day 7 of this series, I will talk about the incredibly useful CPU-Z utility, which is available for free...
2011-04-07
1,309 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