Inside the Optimizer: Constructing a Plan - Part 3

Question

Post reply

Inside the Optimizer: Constructing a Plan - Part 3

Paul White

SSC Guru

Points: 150468
More actions
September 14, 2010 at 12:00 am

#223830

Comments posted to this topic are about the item Inside the Optimizer: Constructing a Plan - Part 3[/url]
Link to Part 1[/url]
Link to Part 2[/url]
Link to Part 4[/url]
Paul White
All articles available on SQL.kiwi
@SQL_Kiwi

Viewing 6 posts - 1 through 5 (of 5 total)

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

Matt Whitfield SSCrazy Eights Points: 8107 More actions · Answer 1

I'm really enjoying this series - double thumbs up sir.

Just had a quick look, and [sys].[dm_exec_query_transformation_stats] exists in 2005 SP3 with no CUs (9.00.4035.00).

Atlantis Interactive - SQL Server Tools
My blog[/url]
Why I wrote a sql query analyzer clone

Paul White SSC Guru Points: 150468 More actions · Answer 2

Matt Whitfield (9/14/2010)
Just had a quick look, and [sys].[dm_exec_query_transformation_stats] exists in 2005 SP3 with no CUs (9.00.4035.00).

Thanks Matt. Part 4 is scheduled for Thursday this week, I hope you enjoy it.

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi

WayneS SSC Guru Points: 95460 More actions · Answer 3

Awesome series Paul!

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

Continued greatness in your articles.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Paul White SSC Guru Points: 150468 More actions · Answer 5

Thanks Wayne and Jason 🙂

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi