A lot of stored procedures have multiple statements and determining the most costly statement in a given proc is a very common task. After all, you want to focus...
2020-10-19 (first published: 2020-10-12)
892 reads
Honored to be a part of not just SQLSaturday #1000, but the long proud history of the free community series of SQLSaturdays celebrating their 1000th+ event. (I spoke at...
2020-10-19
19 reads
This month’s TSQL2sday is hosted by one of my favorite presenters, Rob Volk. His challenge for us is to use analogies and explain a database concept like you would...
2020-10-19 (first published: 2020-10-13)
439 reads
2020-10-16
22 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...
2020-10-16
16 reads
2020-10-16
15 reads
A small blog post for anyone who stumbles across this issue (and for my future self, should I forget the solution). I was working on some tables in SSDT...
2020-10-16 (first published: 2020-10-08)
275 reads
This month the T-SQL Tuesday invitation is from Rob Volk, the last of the crew that I pushed to host last year at a SQL Saturday. I managed to...
2020-10-16 (first published: 2020-10-13)
250 reads
Recently I set up a new process to pull data out of a MySQL database and into SQL Server. Pretty standard ETL stuff, but it’s the organization’s first time...
2020-10-16
2 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...
2020-10-15
19 reads
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
In last months one of the scenarios where you can use AI has been...
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
A factory reset will also eliminate viruses and malware on both Android smartphones and...
Comments posted to this topic are about the item Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers