Spring 2010 Hardware Recommendations
Since I am very interested in various PC-based hardware, and I make an effort to stay current on new developments,...
2010-05-04
860 reads
Glenn Berry
Register For 24 Hours of PASS Event
The free 24 Hours of PASS event will be held on May 19-20, and includes 24 different one hour presentations...
2010-05-03
536 reads
Recap of April 2010 DMV a Day Series
Well, I managed to finish up my series that featured a DMV query every day during the month of April....
2010-05-03
2,906 reads
A DMV A Day – Day 30
The DMV for Day 30 is sys.dm_os_buffer_descriptors, which is described by BOL as:
Returns information about all the data pages that...
2010-04-30
3,263 reads
A DMV a Day – Day 29
The DMV for Day 29 is sys.dm_exec_connections, which is described by BOL as:
Returns information about the connections established to this...
2010-04-29
2,908 reads
A DMV a Day – Day 28
The DMV for Day 28 is sys.dm_io_pending_io_requests, which is described by BOL as:
Returns a row for each pending I/O request...
2010-04-28
1,256 reads
SQL Server 2008 and 2008R2 Diagnostic Information Queries
Since SQL Server 2008 R2 has gone RTM, and will be available on MSDN Subscribers on May 3, I thought...
2010-04-27
1,928 reads
A DMV a Day – Day 27
The DMV for Day 27 is sys.dm_tran_locks, which is described by BOL as:
Returns information about currently active lock manager resources....
2010-04-27
7,545 reads
SQL Server 2005 Diagnostic Information Queries (April 2010)
Since SQL Server 2008 R2 has gone RTM, and will soon be available for purchase, I am going to be...
2010-04-26
988 reads
A DMV a Day – Day 26
Well, we are on the final week of the DMV a Day series for the month of April. I will...
2010-04-26
1,613 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
Pahami cara menutup kartu kredit UOB melalui call center
Untuk menutup kartu kredit Bank UOB, Anda dapat menghubungi UOBCall melalui WhatsApp (6288220114008): atau...
BCA KCP Gudang Peluru Hubungi.0821•3111•185
BCA KCP Gudang Peluru Hub.0821•3111•185 Komp, Jl. Gudang Peluru Raya Jl. Kp. Melayu Besar...
BCA KCU MENARA BIDAKARA Hub.0853•5504•2311
BCA KCU MENARA BIDAKARA Hub.0853•5504•2311 Menara Bidakara, Jl. Gatot Subroto No.Kav.71-73 Lt. Lobby dan...
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