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 […]
2020-09-16
2,188 reads
2020-07-10
549 reads
Today Kendra talks about two of the online options used when working with indexes.
2020-01-14
180 reads
2019-12-16
827 reads
2019-12-09
1,142 reads
2019-10-15
762 reads
Learn how the INCLUDE phrase of an index can change the performance of a query.
2019-10-10
8,876 reads
2019-10-08
702 reads
2019-10-01
792 reads
Microsoft SQL Server has the feature to use “Included columns” for the creation of non-clustered indexes. This feature and its benefits and disadvantages will be explained in the following article. Included columns can be used to create a covering indexes without including all the data into the key columns. This covering index has the advantage […]
2019-09-17
7,481 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Christmas. Depending on where you live it’s a big deal even if you aren’t...
By Arun Sirpal
Quick Video showing you have to use a BACPAC to “import” a database into...
How do I exclude the "Appointments" that are not adjacent to a "Discharge"? This...
Hi SSC, I've got 2 Project Variables which I use to control wether a...
Hello, I have two simple tables: Invoices InvoiceID Date Value and PaymentsReceived PaymentID Date...
Ask SSC