A command I like to use when performance tuning is DBCC INPUTBUFFER. If you have ever run sp_whoisactive or sp_who2 to find out what sessions are executing when CPU...
2021-07-19 (first published: 2021-07-07)
861 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-07-19
27 reads
Did you know, you can use Actions to Filter Extended Events? Well, you can. Filtering is one of the greatest ways in which Extended Events differentiates itself from other...
2021-07-19
5 reads
Running DBCC CHECKDB or DBCC CHECKTABLE on a database may report error 8961. Such a situation could occur while changing the data type of a table column from “ntext...
2021-07-19 (first published: 2021-07-08)
783 reads
We’ve opened up registration and the call for speakers for SQLSaturday Orlando, to be held October 30th at the Orlando Marriott Lake Mary. In-person! We weren’t able to get...
2021-07-19
9 reads
2021-07-18
20 reads
[read this post on Mr. Fox SQL blog] Every now and then you come across a use-case where you need to do something with spatial data, and you need...
2021-07-18
43 reads
[read this post on Mr. Fox SQL blog] Every now and then you come across a use-case where you need to do something with spatial data, and you need...
2021-07-18
12 reads
I want to start by saying thank you to all who submitted, and an amazing collection of people submitted some fantastic content. Also, thanks to Steve for asking me...
2021-07-17
5 reads
This is a quick non-technical discussion (i.e. not a how to in any way) of some of the benefits of ... Continue reading
2021-07-16 (first published: 2021-06-29)
679 reads
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
i have huge table with lot of data and is also wide. i took...
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers