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,338 reads
2020-07-10
557 reads
Today Kendra talks about two of the online options used when working with indexes.
2020-01-14
186 reads
2019-12-16
829 reads
2019-12-09
1,142 reads
2019-10-15
765 reads
Learn how the INCLUDE phrase of an index can change the performance of a query.
2019-10-10
9,954 reads
2019-10-08
702 reads
2019-10-01
807 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,962 reads
By Steve Jones
This series looks at the Advent of Code challenges. As one of my goals,...
After the Professional Association of SQL Server (PASS) unceremoniously closed down in January this...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hi all, I have two SQL jobs. These jobs execute SSIS packages and then...
I am using SQL Server 2008 R2 Express edition. I have already set Maximum...
Hi Experts, Is there any difference between Developer & Enterprise Edition of SQL Server...
Ask SSC