SQL Server 2008 SP2 cumulative update 9
AdvertisementsSQL Server 2008 latest cumulative updates 9 build 10.50.1804 available now. You may download and test itCumulative Update 9 for...
2011-08-19
1,025 reads
Blog Posts
SQLMCM Training – Day 11
Today Jonathan presented on Replication and Paul about Database Snapshots, and his
baby called "CHECKDB" – he has been married with CHECKDB...
2011-08-19
926 reads
Applied SQL: sys.sql_modules
I introduce this whole concept in Applied SQL: You Have Homework. Find all assignments on the Applied SQL page.
Prerequisites: basic...
2011-08-18
1,384 reads
Dancing with Denali - CTP3, Product Guide, and More....
Have you ever danced with Denali in the Pale Moonlight? (Ok, I changed that famous quote from the original Batman...
2011-08-18
2,169 reads
Derived Table Column Alias
By now, you have heard of subqueries. You have also heard of Common Table Expressions. I am sure you know...
2011-08-18
911 reads
Derived Table Column Alias
By now, you have heard of subqueries. You have also heard of Common Table Expressions. I am sure you know what a derived table is and that you get...
2011-08-18
33 reads
Feedback from SQL Saturday #64 in Baton Rouge
I did my session on The Top Ten SQL Server Skills You Need for the first time in Baton Rouge...
2011-08-18
989 reads
How to report a SQL Server performance problem
You’re experiencing a sudden slow down in SQL Server performance. Users are complaining .Many reasons could be causing this sudden...
2011-08-18
727 reads
SQL Server – "Denali" – Using Analytic Function CUME_DIST()
CUME_DIST() calculates relative position of a value relative to a group of values. The value returned by CUME_DIST() is > 0...
2011-08-18
665 reads
SQLMCM Training – Day 10
Today Paul was speaking about Database Mirroring and Jonathan was talking about Failover
Clustering – all in all a very intensive day...
2011-08-18
615 reads
Blogs
Agentic Architect – Future IT Roles (comparison)
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
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