SQL Server 2016 features: Live query statistics
Ever wanted to look at a query’s actual execution plan (execution plan with runtime information) without waiting for the query...
2016-04-12
538 reads
Gail Shaw
- Interests: Computer Graphics, Aikido, Roleplaying
SQL Server 2016 features: Live query statistics
Ever wanted to look at a query’s actual execution plan (execution plan with runtime information) without waiting for the query...
2016-04-12
206 reads
SQL Server 2016 features: Query Store
Given that SQL Server 2016 is coming ‘real soon now’, it’s probably well past time that I write up some...
2016-03-29
913 reads
SQL Server 2016 features: Query Store
Given that SQL Server 2016 is coming ‘real soon now’, it’s probably well past time that I write up some...
2016-03-29
480 reads
Monitoring wait stats
This post, like last week’s, is based off the presentation I did to the DBA Fundamentals virtual chapter.
The request was...
2016-03-02 (first published: 2016-02-23)
2,273 reads
Monitoring wait stats
This post, like last week’s, is based off the presentation I did to the DBA Fundamentals virtual chapter.
The request was...
2016-02-23
165 reads
and other pointless query rewrites
In a similar vein to last week’s blog post… I heard an interesting comment recently. “Change that Column != 2 to...
2016-02-17 (first published: 2016-02-09)
1,920 reads
Q&A from the DBA Fundamentals Virtual Chapter presentation
A couple weeks ago I presented to the DBA Fundamentals virtual chapter. The presentation was recorded and is available from...
2016-02-16
464 reads
Q&A from the DBA Fundamentals Virtual Chapter presentation
A couple weeks ago I presented to the DBA Fundamentals virtual chapter. The presentation was recorded and is available from...
2016-02-16
98 reads
On the addition of useless where clauses
I remember a forum thread from a while back. The question was on how to get rid of the index...
2016-02-10 (first published: 2016-02-02)
2,408 reads
Blogs
Join me at the Microsoft Fabric Community Conference with a discount code
I’m excited to be speaking at the Microsoft Fabric Community Conference this year, which...
Is Your Business Truly Ready for AI?
The AI revolution isn’t coming – it’s here. Companies are racing to integrate artificial...
Data Governance: The Invisible AI Accelerator
Introduction Do you remember the effort of tidying up your BI and reporting systems,...
Forums
MSDTC not available on Windows 2022 clustered SQL 2019 CU30
I connect to this clustered instance and run : begin distributed transaction Msg 8501,...
Time Outs Here
Several times in the last couple of days I've had submissions time out with...
Data Diagrams: Data Types with Column Names
In the ss below I highlighted several rows in each block showing tables in...
Question of the Day
Counting Bits III
What is the output of this code in SQL Server 2022?
select bit_count(0xEF)See possible answers