Multiple query plans for the same query?
A while back i was creating a stored procedure to be used for pulling data from the SQL Server into...
2011-10-25
13,722 reads
When was SQL Server restarted?
One of the main goals with this blog is to write stuff when we learn / discover new things or smarter...
2011-10-18
1,471 reads
Dude, Where is my memory?
We all know that SQL Server loves memory, and in my opinion SQL Server can never have to much RAM....
2011-10-11
683 reads
Index usage
Last week I blogged about how to get help identifying possible missing indexes by using some of the DMV’s provided...
2011-10-04
792 reads
Missing indexes
One of the most common things I encounter when asked to help with performance problems, is wrong or inadequate indexing....
2011-09-27
1,404 reads
How to monitor number of VLF’s in your database
A few weeks back we did a blog post about a file grow bug that has been fixed with SQL...
2011-09-20
1,625 reads
T-SQL Function: EOMONTH
We have all been in a situation where we had to get the last day of the month with T-SQL....
2011-09-13
5,767 reads
Blog Series: T-SQL Enhancements
Three months back in this blog post – T-SQL Enhancements in SQL Server Denali (2011) – we promised to do a series...
2011-09-06
993 reads
New LOGICAL functions in SQL Server Denali
IFF Function
If you are an old Access or Excel “developer” you know this one. This is not a function I...
2011-09-06
2,966 reads
T-SQL Enhancements: FIRST_VALUE() and LAST_VALUE()
A couple a weeks ago I blogged about a few of the enhancements in the OVER clause, and now I...
2011-08-30
4,630 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers