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
805 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
Are you ready to take your SQL skills from theoretical to tactical? If you've...
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...
Comments posted to this topic are about the item New article
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers