17th - 19th July 2014

The International Centre, Telford

Platinum Sponsor

High performance functions

Encapsulating common code in fucntions is one of the first things you learn as a programmer. However with SQL Server functions can be very bad for performance. In this session we will examine scalar functions in both TSQL and in .Net.
You will come away from this session understanding the pitfalls of TSQL functions and how you can make them run 100 times faster.
Presented by Simon Sabin at SQLBits VI
  • Downloads
    Slide deck available Slide Deck 250 KB
    Video available WMV Video 180 MB
  • SpeakerBIO
    simon_sabin.jpg
    Simon is Head of Data at Wonga.com. Prior to Wonga Simon ran a SQL Server Consultancy specialising in performance and scalability.
    He has worked with SQL Server since 6, became an MVP in 2006 and in 2007 founded SQLBits. He is also a SQL Microsoft Certified Master.

    You can follow him @simon_sabin or read his blog http://sqlblogcasts.com
    http://sqlblogcasts.com/blogs/simons http://sqlblogcasts.com/blogs/simons/privaterss.aspx
  • Video
  • Session Files Explorer
    The network name cannot be found.