I’ve recently used this when troubleshooting some unexplained high CPU load on my server:
select top 20st.objectid, st.dbid, total_worker_time/execution_count AS AverageCPUTime,CASE statement_end_offsetWHEN -1...
2010-08-31
4,241 reads
Today let’s expand on the logical processing order of SELECT that I mentioned in last week’s N Things Worth Knowing...
2010-08-31
2,561 reads
This is a reminder for those who might be considering submitting a session but haven't yet. The call for speakers...
2010-08-31
1,403 reads
Hopefully you’ve heard by now that PASS is launching a new event format called SQLRally in May 2011 in Orlando....
2010-08-31
1,892 reads
In the last weblog
post I have talked about the difference of unique and non-unique clustered indexes.
As you have seen SQL...
2010-08-31
9,795 reads
I've had this one in my toolbox for a while now, decided to publish it on CodePlex a while back,...
2010-08-30
702 reads
We are here again after another week and ready for another episode in this series. Today we get to talk...
2010-08-30
1,766 reads
I am trying to gather some information about some of the newer Intel and AMD processors as part of my...
2010-08-30
1,891 reads
Unlike fine wine, database statistics do not improve with age. I recently helped out with a client who was having...
2010-08-30
10,965 reads
Join me for Lunch - SQL Lunch #33 (Indicators, Sparklines and Databars)
#33-SSRS 2008 R2 - Indicators, Sparklines and Databars
Speaker: Patrick LeBlanc
Add To...
2010-08-30
1,696 reads
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
Comments posted to this topic are about the item Creating a JSON Document I
Comments posted to this topic are about the item Who is Irresponsible?
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers