Query Optimizer Deep Dive – Part 2http://sqlblog.com/blogs/paul_white/archive/2012/04/28/query-optimizer-deep-dive-part-2.aspxThis is the second part in a series of posts based on the content of the Query Optimizer Deep Dive presentations I have given over the last month or so at the Auckland SQL Users’ Group and the SQL Saturday events in Wellington, New Zealand and Adelaide,enCommunityServer 2.1 SP2 (Build: 61129.1)Paul White: Page Free Space : Query Optimizer Deep Dive - Part 1http://sqlblog.com/blogs/paul_white/archive/2012/04/28/query-optimizer-deep-dive-part-2.aspx#43051Sat, 28 Apr 2012 05:02:30 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:43051Paul White: Page Free Space : Query Optimizer Deep Dive - Part 1<p>PingBack from <a rel="nofollow" target="_new" href="http://sqlblog.com/blogs/paul_white/archive/2012/04/28/query-optimizer-deep-dive-part-1.aspx">http://sqlblog.com/blogs/paul_white/archive/2012/04/28/query-optimizer-deep-dive-part-1.aspx</a></p> re: Query Optimizer Deep Dive – Part 2http://sqlblog.com/blogs/paul_white/archive/2012/04/28/query-optimizer-deep-dive-part-2.aspx#43063Sat, 28 Apr 2012 19:14:07 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:43063tobi<p>A great post!</p> <p>Here is a blogging suggestion: Talk about the new optimizer rules in SQL Server 2012 in detail! They are:</p> <p>BatchJoinToHS</p> <p>BHTBToBHTB</p> <p>JoinToBatchJoin</p> <p>GbAggToBatchGbAgg</p> <p>BatchGbAggToHS</p> <p>GenLGTop...(edited for space)</p> <p>Your in-depth posts are always a great resource. Thanks!</p>re: Query Optimizer Deep Dive – Part 2http://sqlblog.com/blogs/paul_white/archive/2012/04/28/query-optimizer-deep-dive-part-2.aspx#43064Sat, 28 Apr 2012 19:22:43 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:43064Paul White<p>Thanks for the suggestion, Tobi.</p> <p>Paul</p> Query Optimizer Deep Dive – Part 3http://sqlblog.com/blogs/paul_white/archive/2012/04/28/query-optimizer-deep-dive-part-2.aspx#43071Sun, 29 Apr 2012 07:30:33 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:43071Paul White: Page Free Space<p>This is the third part in a series of posts based on the content of the Query Optimizer Deep Dive presentations</p> Query Optimizer Deep Dive - Part 4http://sqlblog.com/blogs/paul_white/archive/2012/04/28/query-optimizer-deep-dive-part-2.aspx#43095Mon, 30 Apr 2012 13:36:18 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:43095Paul White: Page Free Space<p>This is the final part in a series of posts based on the content of the Query Optimizer Deep Dive presentations</p>