Viewing 15 posts - 1 through 15 (of 62 total)
Yes, you are correct. Darn -- I thought I had proofread it better than that. 🙁
Cheers,
Mike
Mike Byrd
July 11, 2021 at 10:25 pm
I would rephrase your first sentence to ..."why indexes should lead with equality columns and then range searches." Inequality columns (from your query) will almost always cause a scan rather...
Mike Byrd
September 27, 2020 at 9:08 pm
Great catch! And that was with 4 other sets of eyes reviewing the article before I submitted it.
Mike Byrd
September 16, 2020 at 3:07 am
Hmmm, not sure how the code in the article got changed, but you are absolutely right.
Mike Byrd
August 14, 2020 at 12:47 pm
I continue to be amazed by the overall reduction in wait times (from DPA free) for the production database. There are still spikes and sometimes short plateaus, but overall during...
Mike Byrd
February 10, 2020 at 7:39 pm
You are correct in asking about PAD_INDEX setting. While I was still in the experimental and analysis part of this project I was trying to keep minimal variations on what...
Mike Byrd
February 10, 2020 at 6:37 pm
All of ya’lls comments are absolutely correct. Not sure where my brain was when I wrote the original paragraph, but obviously not in this universe. This is what I should...
Mike Byrd
November 26, 2019 at 5:54 pm
Stand by for an undated script in GitHub. You can find it with my UserName: MByrdTX
I also have listed there this 2 parter in Word format, a PowerPoint presentation I...
Mike Byrd
August 27, 2019 at 5:15 pm
I'm not seeing your attachment. 🙁
Mike
Mike Byrd
August 21, 2019 at 7:16 pm
Actually the script has evolved some since I wrote the article. Have attached latest script (currently in production on one of client's databases). (Change file extension from txt to sql)
Mike Byrd
August 20, 2019 at 2:19 pm
Nice Jeff,
This follows some of the patterns I've found in my upcoming Dynamic Fill Factor article. Amazing how it all ties together.
Mike Byrd
August 8, 2019 at 11:55 am
The rest of the article (minus Fig 16 & Fig 17) is below:
with now a clustered index seek on CIX_SalesOrderHeaderBig_OrderDateSalesOrderID having a query plan cost of 83.0901, 3595 logical reads,...
Mike Byrd
April 9, 2019 at 4:00 am
The article is missing the last 2 pages of Figures and text. Not sure how SQLServerCentral lost that, but I will try and put rest of article back if they...
Mike Byrd
April 9, 2019 at 3:57 am
Mike Byrd
March 2, 2019 at 10:30 am
Table definition is Mike Byrd
CREATE TABLE Sales.SalesOrderHeaderBig(
SalesOrderID int IDENTITY(1,1) NOT NULL,
RevisionNumber tinyint NOT NULL,
OrderDate datetime NOT NULL,
DueDate datetime NOT NULL,
ShipDate datetime NULL,
[Status] tinyint NOT NULL,
March 1, 2019 at 6:38 pm
Viewing 15 posts - 1 through 15 (of 62 total)