Confused by sp_who2 (Dear SQL DBA Episode 30)
Category:
monitoring-troubleshooting
This week’s ‘Dear SQL DBA’ question gets us down to the essentials: how to I tell if a transaction is hanging?
kendra little
Bug: Incorrect modification_counter for Column Stats on Tables with a Clustered Columnstore Index
Category:
query-performance
I don’t find bugs in SQL Server all that often. I find bugs in my own code all the time.
In this case I double checked, and I think it’s a real SQL Server bug.
Administering COTS databases (ISVs / Third Party Vendors)
Category:
database-administration
, sql-server
I recently received a question from a vendor about databases created by software vendors.
Configure Fields and Predicates for Multiple X-Events
Category:
monitoring-troubleshooting
I’m not always the best at learning to use graphical interfaces. Maybe that’s why I often don’t like them?
Columnstore Indexes and Computed Columns in SQL Server 2016
Category:
query-performance
You can’t do everything with a columnstore index – but SQL Server’s optimizer can get pretty creative so it can use a columnstore index in ways you might not expect.
Collecting the Blocked Process Report (XEvents and Server Side Trace)
Category:
monitoring-troubleshooting
I’m a big fan of the built-in Blocked Process Report in SQL Server. It’s come in handy for troubleshooting blocking situations for me many times.
Actual Time Statistics in Execution Plans: Elapsed CPU Time and more
Category:
query-performance
One of the coolest things to come to SQL Server Management Studio in a long time might be hard to see at first: it’s tucked away in the Properties Window.
But once you see it, it might just be something that you use all the time.