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?
kendra little
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.
Does Truncate Table Reset Statistics?
Category:
query-performance
, sql-server
Short answer: the SQL Server optimizer will know that the table was truncated, but statistics might not update when you expect.
For the long answer, let’s walk through an example using the WideWorldImporters sample database.
Downgrading the SQL Server Edition of a Dev Environment
Category:
database-administration
I got a great question about Edition downgrades recently.
Filtered Indexes: Rowstore vs Nonclustered Columnstore
Category:
indexing
SQL Server has two types of filtered indexes:
- The “classic” filtered nonclustered rowstore index, introduced in SQL Server 2008, available in all editions
- The newfangled filtered nonclustered columnstore index, introduced in SQL Server 2016, available in Enterprise Edition