Our next meeting will be on the third Wednesday of the month. We use EventBrite for registrations, so please register at http://adssug201501.eventbrite.com.
Our next meeting is: Wed, Jan 21 2015 12:00 to 14:00 in Adelaide.
Stored Procedures vs. Ad-Hoc SQL: Performance Showdown!
Still not sure of which is faster? Let us put this matter to rest once and for all. We will measure every single aspect of the execution of a stored procedure vs. its Ad-Hoc query counterpart, and only one will prevail! We will look at raw performance, memory consumption, plan cache usage, and network bandwidth utilization. We will also discuss options for environments on which the code cannot be modified.
Speaker: Argenis Fernandez
Argenis Fernandez works in the Database Engineering team at SurveyMonkey, and is based in Redmond, WA. He has worked with SQL Server for over 15 years and enjoys heavy OLTP workloads and performance tuning. Formerly a Senior Consultant for Microsoft, Argenis is also a Microsoft Certified Master in SQL Server 2008, and founder of the Security Virtual Chapter for PASS.