How to remove CardinalityEstimate in query plan on computed columns…
Hello,
I have come across a really good tip if you’re using computed columns that involve a concatenation of columns and...
2014-06-15
721 reads
Blog Posts
PASS SQLSaturday Events: July 2014
DateEventJuly 12 SQLSaturday #312 – Sacramento 2014July 26 SQLSaturday #302 – Albany 2014July 26 SQLSaturday #322 – Guatemala 2014The post PASS SQLSaturday Events:...
2014-06-15
685 reads
Differences In Native Compiled Procedures Execution Plans
All the wonderful functionality that in-memory tables and natively compiled procedures provide in SQL Server 2014 is pretty cool. But,...
2014-06-13 (first published: 2014-06-10)
2,057 reads
Friday Followup For June 13, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-06-13
434 reads
Query backup history
As a quick script tip for today I'll show you a script I use regularly for reporting purposes.
It shows you the...
2014-06-13
17,664 reads
Query backup history
As a quick script tip for today I’ll show you a script I use regularly for reporting purposes.
It shows you the...
2014-06-13
412 reads
Reblog: June 6 to June 12
Photo credit – Mike Lynch
A good cure to a creepy doll is a good old post that is still useful. In...
2014-06-13
845 reads
SQL Saturday South Florida And Then Vacation
I’m leaving early afternoon for the longish drive to South Florida for SQLSaturday tomorrow. The schedule looks impressive! I missed...
2014-06-13
548 reads
Data loss in clustered index occurs when you run online build index in SQL Server 2012
Scared? Don’t worry, there is a workaround and a hotfix. More on that in a moment.
This morning I checked my...
2014-06-12 (first published: 2014-06-10)
2,742 reads
Giving Away Woodworking Magazines
I read a lot and one of the topics I enjoy reading about is woodworking. Recently I’ve been on a...
2014-06-12
629 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
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
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:...
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