What happens when you cancel or kill a resumable index creation?
SQL Server 2019 adds resumable online index creation, and it’s pretty spiffy according to Brent.
2019-04-11
SQL Server 2019 adds resumable online index creation, and it’s pretty spiffy according to Brent.
2019-04-11
When you index a nullable field, are the rows with nulls stored in the index? It’s easy enough to find out by creating a table with a nullable field, and then creating an index on it.
2019-03-29
2019-03-28
363 reads
Michael J. Swart posted an interesting question: he had a large table with 7.5 billion rows and 5 indexes. When he deleted 10 million rows, he noticed that the indexes were getting larger, not smaller.
2019-03-22
2,752 reads
2018-11-09
806 reads
Tara explains when index DMVs gets reset by telling a story from her dark past.
2018-11-09
3,197 reads
When you're not sure, start by aiming for 5 or less indexes per table, with 5 or less fields each.
2018-11-02
4,276 reads
2018-10-29 (first published: 2018-10-19)
1,004 reads
2018-08-30
817 reads
2018-08-23
850 reads
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers