Presentation Last Week
Last week I presented at the Southern New England SQL Server User Group (SNESSUG) where I'm the Program Director. I presented from the book, Dissecting Execution Plans, that is supposed to be published any day now. I kept it basic and it flowed very well. The audience seemed receptive and there were a few questions. Mostly around figuring out what to do when you saw certain problems within the execution plans. Since that was the goal of the presentation, I was ready for most of the questions. I got stumped once on a Constant Scan operation. I finally looked it up this morning and feel silly. Here's the query: INSERT INTO [AdventureWorks].[Person].[Address] Â Â Â Â ([AddressLine1] Â Â Â Â ,[AddressLine2] Â Â Â Â ,[City] Â Â Â Â ,[StateProvinceId] Â Â Â Â ,[PostalCode] Â Â Â Â ,[rowguid] Â Â Â Â ,[ModifiedDate] VALUES ('1313 Mockingbird Lane'…