Post on Troubleshooting Memory Issues
Here's a post from the Windows Server Performance Team:
An Overview of Troubleshooting Memory Issues
The post discusses the following issues:
Physical...
2008-01-25
1,186 reads
Blog Posts
SQL Server 2008 RTM looks to be 3rd Quarter
On the Microsoft Data Platform Insider blog, there is a post indicating new roadmap dates:
Microsoft SQL Server 2008 Roadmap...
2008-01-25
1,642 reads
System Sessions/Spids Rather than Spid < 50
Saw System Sessions posted on the PSS blog and it shows an example of information being written to the error...
2008-01-23
607 reads
Finding missing rows
One way to find the rows from one table that don't match another table is to use a sub-query. Here is...
2008-01-22
536 reads
A Holiday Posting
It's Martin Luther King, Jr. day here in the US where we remember the famous civil rights leader. So my...
2008-01-21
676 reads
Free Subscriptions to Visual Studio Magazine
First time I've noticed this being offered, saw it posted on the Orlando .Net Users Group (ONETUG) site. Sign up...
2008-01-21
1,443 reads
We Are Microsoft Charity Challenge Weekend
This weekend, I had the unique opportunity to donate some time to a worthwhile charity organization. Through the efforts of...
2008-01-21
842 reads
Learning to Blog via Books
I was chatting with a friend recently and in the course of 'what are you up to lately' I mentioned...
2008-01-20
490 reads
Connecting to a Reporting Services Model
There's always been some confusion about models in Reporting Services, many people ignore them thinking that they are only for...
2008-01-18
1,559 reads
Free Ebook Chapter(Book) - Introducing SQL Server 2008
Saw it mentioned in the recent MSPress newsletter, Peter DeBetta is writing Introducing SQL Server 2008 and right now Chapter...
2008-01-18
861 reads
Blogs
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...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCP Jakarta Raya, Tlp/wa:082372744391.
Jl. Pegangsaan Timur No.121, RT.1/RW.1, Pegangsaan, Kec. Menteng, Jakarta, Daerah Khusus Ibukota Jakarta 10320
Alamat BCA KCU PANGKAL PINANG Telp: 0817825533
WhatsApp: 0817825533, Jl. Raya Koba, RT.019/RW.007, Dul, Kec. Pangkalan Baru, Kabupaten Bangka Tengah, Kepulauan...
BCA KCP Krekot Bunder No.Telponcs 083831618865
WHATSAPP 083831618865 Jl. Krekot Bunder Raya No.28, Ps. Baru, Kecamatan Sawah Besar, Kota Jakarta...
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