2022-01-26
499 reads
2022-01-26
499 reads
2021-08-09
521 reads
In the last year I’ve published articles on indexes to include Indexes: When Column Selectivity Is Not Always A Requirement – SQLServerCentral and Query Optimizer Suggests Wrong Index and Query Plan -- Why? – SQLServerCentral. This article is a continuation of just how the optimizer interacts with the index wizard. We’ve all heard and read […]
2021-07-07
2,181 reads
The script returns all the fragmented indexes on all databases on the instance you run it. Can be run on multiple instances in the same time using central management capability.
2021-07-12 (first published: 2021-07-06)
1,301 reads
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,922 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,655 reads
2020-07-10
563 reads
Today Kendra talks about two of the online options used when working with indexes.
2020-01-14
195 reads
2019-12-16
833 reads
2019-12-09
1,191 reads
By kleegeek
I am thrilled to have been a part of this year’s Storage Field Day...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Steve Jones
Here are the slide decks for my sessions at SQL Saturday Jacksonville 2022 Continuous...
hi, I am trying to execute ssis package from command line. I also tried...
Hello I need to migrate existing sql server 2012 replication to the SQL Server...
Hello, I cant understand what this code is doing, can some one please...