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 has worked with data for all his career enabling companies to make the most of the data they have .

    He works with companies to help them

    1. Understand and define a cloud data platform strategy.

    2. Optimise their data platform, including performance, scalability, security and certification

    3. Improve their data development practices including implementation of agile methodologies and continuous integration.

    Education of teams is at the heart of everything Simon does.

    The passion for education led Simon to found SQLBits, the largest SQL conference in Europe. He is also a SQL Microsoft Certified Master and has been Microsoft MVP since 2005

    You can follow him @simon_sabin or read his blog http://sqlblogcasts.com/blogs/simons

    http://sqlblogcasts.com/blogs/simons http://sqlblogcasts.com/blogs/simons/privaterss.aspx
  • Video
  • Session Files Explorer
    The network name cannot be found.