Pain of the Week: Understanding Your Indexes
Want to take a few minutes out of your day on to learn a bit more about indexes? On Thursday,...
2011-06-28
884 reads
Blog Posts
SQLDIY: Database Space Detail
Continuing to build up our data gathering library we shift our focus to tracking database file growth. This particular procedure...
2011-06-28
563 reads
Which database is using all my CPU
We all know how easy it is to see how much CPU power is consumed by the SQL Server process,...
2011-06-28
1,659 reads
CPU-Z 1.58 Released
Version 1.58 of the very useful utility CPU-Z was released on June 24, 2011. Originally (and still) popular for bragging...
2011-06-27
775 reads
Look How Far You Have Come
A reader wrote to me over the weekend, seeking advice on behalf of their friend, who had been feeling deflated...
2011-06-27
856 reads
MCITP: 3 Down 1 To Go
Despite my desire to do one exam a week in pursuit of the MCITP Certifications for DBA and Developer in SQL 2008, other things came up that have slowed...
2011-06-27
3 reads
MCITP: 3 Down 1 To Go
Despite my desire to do one exam a week in pursuit of the MCITP Certifications for DBA and Developer in...
2011-06-27
761 reads
PASS Update #58 (Elections)
Last year we had some problems with our annual election, enough problems that clearly we needed to do a deeper...
2011-06-27
672 reads
Presentations in Action
The first book I read for my 12 goal oriented books was Jerry Weissman’s Presentations in Action: 80 Memorable Presentation...
2011-06-27
638 reads
Replacing Cursors with Set-Based SQL Queries – Part 1
Part 1 of a discussion about replacing cursors with SQL statements for significant speed improvements.
In a previous post I discussed...
2011-06-27
7,982 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
Alamat kantor resmi BCA KCU WAHID HASYIM Telp:0817866887
WhatsApp:0817866887 Jl. K.H. Wahid Hasyim No.183 A-B, Kb. Kacang, Kecamatan Tanah Abang, Kota Jakarta...
BCA KCP Urip Sumoharjo No Telpon:083188951403
Whatsapp:083188951403 Jl. Jend. Urip Sumoharjo No.133, Kepatihan Wetan, Kec. Jebres, Kota Surakarta, Jawa Tengah...
BCA KCP CEMPAKA PUTIH TLP/WA 083800119009
Jl. Letjen Suprapto No.30 EF, Harapan Mulya, Kec. Kemayoran, Kota Jakarta Pusat, Daerah Khusus...
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