While preparing for my SQL Saturday Salt Lake City presentation, Climbing the B-Tree, I ran into one of the “word of mouth” facts that the first column of an index should be highly selective, i.e., it should only point to one or a few rows. This is not always the case and I’ll show you […]
2023-01-02 (first published: 2020-09-16)
5,432 reads
2020-07-10
576 reads
Today Kendra talks about two of the online options used when working with indexes.
2020-01-14
281 reads
2019-12-16
846 reads
2019-12-09
1,362 reads
2019-10-15
781 reads
Learn how the INCLUDE phrase of an index can change the performance of a query.
2019-10-10
25,437 reads
2019-10-08
717 reads
2019-10-01
948 reads
Learn about the advantages and disadvantages of using INCLUDE columns in your index.
2021-04-30 (first published: 2019-09-17)
27,954 reads
By Steve Jones
A customer asked if they needed to restore a database from backup to compare...
By Brian Kelley
If we aren't having the same conversation, we aren't going to be heard. That's...
A while back I wrote about using AI to explore why people are not...
Comments posted to this topic are about the item Is GenAI Coming Faster Than...
Comments posted to this topic are about the item Local Storage Options
Comments posted to this topic are about the item DeepSeek: What is new with...
I'm setting up a SQL Server 2019 instance and we are planning on using SMB storage for our database files. However, the file share isn't ready, so the idea is to use the \127.0.0.1dbfile as the location to start and then move these files to the remote server. Can I do this?
See possible answers