SQL Server Execution Plans, Third Edition, by Grant Fritchey

Question

SQL Server Execution Plans, Third Edition, by Grant Fritchey

Grant Fritchey

SSC Guru

Points: 398713
More actions
July 28, 2020 at 12:27 pm

#3775336

Comments posted to this topic are about the item SQL Server Execution Plans, Third Edition, by Grant Fritchey
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 9, 2021 at 9:04 am

This was removed by the editor as SPAM
April 11, 2022 at 5:21 pm

This was removed by the editor as SPAM
April 11, 2022 at 5:22 pm

This was removed by the editor as SPAM

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1003894 More actions · Answer 1

First of all, I've not yet read the 3rd edition but I did the first two. If Grant continues his tradition of excellence in this 3rd edition as he did the first two, then this book is a must have/must read/must study. You'll not only learn about execution plans but a wealth of excellent ancillary information that will also help you write better/faster code.

Shifting gears to the description of the book in the article...

@Grant,

I believe the following statement ...

through how to interrupt them in their various forms

... should be...

through how to interpret them in their various forms

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Grant Fritchey SSC Guru Points: 398713 More actions · Answer 2

Nah, interrupt sounds fine. Ha! I'll see what I can do to get that fixed.

BTW, 3rd edition is WAY better than the first two.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Jeff Moden SSC Guru Points: 1003894 More actions · Answer 3

Hard to believe the "way better" comment... the first two were awesome! You've enticed me to read the 3rd edition to see. 😀

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Muhammad Macdonald Grasshopper Points: 14 More actions · Answer 4

Muhammad Macdonald

Grasshopper

Points: 14

December 11, 2021 at 12:44 pm

#3962682

Excellent reviews, I will gladly read all editions

Jeff Moden SSC Guru Points: 1003894 More actions · Answer 5

Grant,

Didn't you say that you were coming out with the 4th Edition sometime in the first half of next year (2022)?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Grant Fritchey SSC Guru Points: 398713 More actions · Answer 6

Muhammad Macdonald wrote:

Excellent reviews, I will gladly read all editions

Nah, just the 3rd edition. It's updated & cleaned up. The others are out of date, wrong, or unclear.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Grant Fritchey SSC Guru Points: 398713 More actions · Answer 7

Jeff Moden wrote:

Grant,
Didn't you say that you were coming out with the 4th Edition sometime in the first half of next year (2022)?

No plans to update the execution plans book at this point, no. I am rewriting the entire query tuning book (on Chapter 7 of 24, or maybe 23). I plan to release it about the time that SQL Server 2022 gets released so that I've got all the new bits incorporated.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Jeff Moden SSC Guru Points: 1003894 More actions · Answer 8

Grant Fritchey wrote:

Jeff Moden wrote:
Grant,
Didn't you say that you were coming out with the 4th Edition sometime in the first half of next year (2022)?
No plans to update the execution plans book at this point, no. I am rewriting the entire query tuning book (on Chapter 7 of 24, or maybe 23). I plan to release it about the time that SQL Server 2022 gets released so that I've got all the new bits incorporated.

Ah... that's right. I remembered it incorrectly. Thanks, Grant!

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)