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
1,932 reads
2020-07-10
536 reads
Today Kendra talks about two of the online options used when working with indexes.
2020-01-14
179 reads
2019-12-16
826 reads
2019-12-09
1,136 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,138 reads
2019-10-08
701 reads
2019-10-01
790 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,056 reads
By gorandalf
A long time ago, in early days of the Azure SQL Database in 2015,...
By Rayis Imayev
(2020-Sep-26) Last week one of my Azure Data Factory (ADF) deployment pipelines failed with an...
By kleegeek
Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...
what kind of situation can I use "option (fast 1)" when I execute a...
During the installation I come to the step of configuring the database engine. It...
Comments posted to this topic are about the item A Getting Started PostgreSQL Tutorial
Ask SSC