SQL Server MVPs Aaron Bertrand and Kevin Kline continue their series on query tuning best practices. In the webinar, they continue to discuss some additional patterns, things that do well and make your SQL code perform better, and anti-patterns, which are things you want to avoid and stay away from. Aaron goes over the “Kitchen Sink” stored procedures and SP_Execute SQL vs. EXEC( ) and when to use each. Next, Kevin goes over what can cause your execution plans to self-destruct. Finally, Aaron wraps up the webinar by talking about decision of whether to MERGE or not to MERGE.
Click here to find out the winners of the Richard Petty Driving Experience: sqlsentry.tv/who-is-the-worlds-fastest-dba/
Note: eBook no longer available via Amazon. Email firstname.lastname@example.org if you are still interested in receiving a copy.