Introduction Every DML transaction reads the data before it makes any changes. Not only during a SELECT query, but when you run any DML statement, insert, update, or delete, SQL Server first fetches a bunch of pages into the buffer pool locating the desired rows and changes them while synchronously writing to the transaction log […]
2021-05-10
3,044 reads
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,383 reads
2020-07-10
558 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,143 reads
2019-10-15
766 reads
Learn how the INCLUDE phrase of an index can change the performance of a query.
2019-10-10
11,280 reads
2019-10-08
703 reads
2019-10-01
847 reads
By Devin-Knight
Power Virtual Agents empowers subject matter experts to build intelligent conversational bots, using a...
By Steve Jones
I’ve been struggling with an author for a few months. I tried to work...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hello! I am trying to create data source to connect to Azure SQL DB...
For 2019, how would one go about applying CU on multiple instances in a...
Hello experts, I'm trying to import some CSV data into a SQL database using...
Ask SSC