High performance functions

2010

TL; DR

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.

Session Details

3 things you'll get out of this session

Simon Sabin's previous sessions

Maximising everyone's super powers - Panel discussion

In this panel we will discuss approaches with leaders in the field who have first hand experience of managing neurodiversity in the work place. Welcome questions from the audience as to how everyone can maximise their and their teams super powers

Achieving PCI with SQL Server - Don't be the next Sony

This session covers all aspects of what you need to do, to enable the storage of card details in SQL Server and achieve PCI certification. We will deep dive into the solutions for storing the data securely using SQL Servers encryption functionality

Performance tuning from the field

In this session we will look at some common practices I have seen in the field that cause performance problems. We will diagnose the cause of the problem and the resolution to the problem.

10 things you should never do with SQL Server

In this session we will look at some of the practices that you shouldn't follow when developing a SQL Server database. We will cover items such as query design, table design, indexes, constraints and more. After this session you will have some practices that you know you should avoid in your SQL Server database if you want the best performance. If you have them you will know what you need to do to resolve them.