Andy on Twitter
Just prior to the 2009 PASS Summit I posted about giving Twitter a try, and thought I’d report back on...
2010-01-21
2,190 reads
Just prior to the 2009 PASS Summit I posted about giving Twitter a try, and thought I’d report back on...
2010-01-21
2,190 reads
I recieved the notification from Azure Platform Team that the CTP accouct will be closed at the end of the...
2010-01-21
382 reads
Note: This is an in-depth article that exceeds 5,000 words, and provides a case-study of how a maintenance plan could...
2010-01-21
1,756 reads
Another month, another blog chain, this time started by Paul Randal. I got tagged by both Grant and Steve, on...
2010-01-21
395 reads
This is a reprint of my editorial at SQLServerCentral.com. There is a lively discussion at the SSC forum on this...
2010-01-21
414 reads
I have been reading up on instant file initialization and I have read a couple of good blog posts by...
2010-01-21
1,413 reads
Note: This is an in-depth article that exceeds 5,000 words, and provides a case-study of how a maintenance plan could...
2010-01-21
974 reads
PASS Virtual Meeting
Speaker: Adam Jorgensen
Topic: Zero to cube in 60 Minutes
Date and Time: 1/22/2010 12:00 PM EST
Meeting URL: Join Meeting
Description:...
2010-01-21
680 reads
Recently I was asked to alter a report to pull different more meaningful data. The particular report was pulling data...
2010-01-21
1,002 reads
I needed to create an identical index on a bunch of tables within one of my projects (yes, I know...
2010-01-21
1,810 reads
By Vinay Thakur
In previous posts, we looked at the SQL Server engine. for us DBAs, the...
By Arun Sirpal
You have used Claude. But which Claude? The Claude app (claude.ai, the desktop and...
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
WhatsApp:0817866887 Gedung Taman Melati Margonda Jl. Margonda No.525 A, Pondok Cina, Kecamatan Beji, Kota...
WhatsApp:0817866887 Jl. Margonda Raya No.182, Kemiri Muka, Kecamatan Beji, Kota Depok, Jawa Barat 16423
WhatsApp:0817866887 Bank Bca Kcu Purwakarta, Jl. Jendral Sudirman No.85, Nagri Tengah, Kec. Purwakarta, Kabupaten...
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 YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers