The Case of the Weirdly Long COLUMNSTORE_BUILD_THROTTLE Wait
Category:
columnstore-indexes
A funny thing happened on the way to my filtered nonclustered columnstore demo recently…
It was taking forever to create my demo index.
Category: columnstore-indexes
The Case of the Rowgroup Deadlock in a Columnstore Index
I came across a fun deadlock when writing demos for my session on the Read Committed isolation level this week. (It’s OK to call it “fun” when it’s not production code, right?)
I was playing around with a nonclustered columnstore index on a disk-based table. Here’s what I was doing:
Removing Query Hints with Plan Guides (Dear SQL DBA Episode 43)
If you need to add, remove, or replace hints from ad-hoc queries where you can’t change the code, plan guides can help. See a demo of removing a query hint from parameterized TSQL run from an application, and get tips on how to make your plan guides work in SQL Server.