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 runs a Data Consultancy Sabin.io enabling companies to make the most of the data they have.

    He has worked with data for all his career and worked with companies across all industry sectors including online retail, insurance, finance, motor sport.

    He works with companies to help them

    1. Improve their data development practices including implementation of devops, agile methodologies and continuous integration.

    2. Understand and define a cloud data platform strategy.

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

    Education of people is at the heart of what Simon and his company sabin.io stand for. it is epitomised by SQLBits, which Simon founded in 2007. Its the largest SQL Server conference outside of Europe and many view as the best in the world, always maintaining a free element and ensuring education for everyone.

    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