A Tale of Two Sandy Bridge Laptops
I recently bought a new teaching and presentation laptop, which is a Toshiba Portege R835-P55X, which I found at the...
2011-06-21
946 reads
Blog Posts
Are all updates split into delete-insert?
This should be another quick one.
Earlier I saw a forum post where someone asserted that SQL always executes an update...
2011-06-21
4,804 reads
Data Compression in SQL Server
Do you know much about data compression? It seems that quite a few people I meet don’t really understand how...
2011-06-21
2,342 reads
Index Rebuild progress v2
I have actually written about this subject earlier on my Danish blog (http://www.performanceduo.com/post/Index-Rebuild-progress.aspx), but last week when working on a...
2011-06-21
18,087 reads
New York SQL Events - Upcoming Triple Play......
If you're in a New York State of Mind (song by Billy Joel), then you'll like the triple play of...
2011-06-21
1,336 reads
PASS DBA Virtual Chapter Tomorrow
Tomorrow is time for part two of my presentations this month on Extended Events for the PASS DBA Virtual Chapter. ...
2011-06-21
634 reads
PASSMN Meeting Later Today
Well folks, we’re already to the third Tuesday of June. Where’s the summer going to? That means that this afternoon...
2011-06-21
706 reads
Replaying workloads with the RML Utilities
In today's weblog posting I want to talk about replaying SQL Server workloads with
the RML Utilities. RML Utilities stands for...
2011-06-21
4,202 reads
Speaking At The 2011 PASS Summit
The official notices went out to speakers last week and I am privileged to have the opportunity to present two...
2011-06-21
475 reads
Code Snippet for an SSIS DataFlow Performance Wiretap
I was recently tweaking a few Data Flows, and settled on a very small, but very useful script to help record execution timing inside the flow.
Decomposition Is Time...
2011-06-20
10 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
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