22-25 April 2026 
SQLBits 2015
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!
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.
Demos will include WireShark as well as extensive DMV queries.
Speakers
Argenis Fernandez's previous sessions
Why is understanding Kubernetes important for your career as a Data Professional?
A panel discussion on why both - admins and developers - should understand the impacts and benefits of containerized applications.
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!
Lean and Mean: Running SQL Server on Windows Server Core
Do you consider the Windows GUI to be a waste of resources? Starting with SQL Server 2012, you can run on top of Windows Server Core 2008 R2 or 2012. In this session we will discuss installation and management, along with lots of tips and tricks.