Reason for Early Termination of Statement
Wouldn’t you like to know why the optimizer stopped tuning the execution plan you’re looking at? It’s actually possible and...
2010-11-18
3,054 reads
Blog Posts
Recompiles
I’ve looked at cache hit and miss events and at the cache insert and remove events. The only cache-monitoring event...
2010-11-18
2,161 reads
Scheduled Out
I’m all scheduled out for the next week with newsletters and content ready to go through Nov 29. I’m not...
2010-11-18
697 reads
SQLSaturday#59 Special Interview with Melissa Demcsak, aka SQLDiva
SQLSaturday#59 Special Interview with Melissa Demcsak, aka SQLDiva
Only two days left until our super SQLSaturday#59 event. Hope all is well...
2010-11-18
795 reads
What’s New in SQL Server “Denali” CTP1
Denali. No, not that one...
How many of you have heard that the Community Technology Preview (CTP1) for the next version...
2010-11-18
736 reads
XQuery for the Non-Expert – Terminology
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
It’s time...
2010-11-18
817 reads
A Plug for SQLSaturday #45 in Louisville
My friend Mala is heading up the 2nd annual SQLSaturday in Louisville, KY, being held next year on January 22,...
2010-11-17
482 reads
Announcing the SQLDoctor
Today I’m very proud to announce a FREE SQL Server consulting service from me called
the “SQLDoctor”.
The concept of the SQLDoctor...
2010-11-17
568 reads
Cleaner Code Demos – Speaker Hints
Recently I had the privilege of watching Paul Randal and Kimberly Tripp present (separately) at SQL Server Connections. If you...
2010-11-17
841 reads
Handling Type II Dimension with the MERGE Statement
Microsoft attempted to make our lives easier with the Slowly Changing Dimension task in SSIS. However, as we all know...
2010-11-17
2,010 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
Getting results from a Procedure to join to a query
I have a need to execute a stored procedure and return the results to...
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers