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.

Simon Sabin

Simon is an independent Database consultant specialising in the world of search, distributed architectures, business intelligence and application development. He has worked with SQL Server since 1998 and has always focused on high performance reliable systems. He was awarded as an MVP in 2006 and is regular speaker at SQL Server events as well as writing for SQLServerCentral and Simple-Talk.com.

Simon Sabin's blog http://sqlblogcasts.com/blogs/simons

---

Downloads

File Type Ext ContentName Presentation .pptx High Performance Functions.pptx

<< 1 >>

---

Other sessions from this conference

Denormalisation –having your cake and eating it.

Design patterns for SSIS Performance

Designing and Tuning high speed data loading

Event Driven Cube Performance and Security Monitoring

Fast Track Foundations: Get Serious about Sequential I/O

Getting Started with SQL Azure

High Availability in the Real World!

Improving Database Performance by Removing the Database

Inside the SQL Server Query Optimizer

Introduction to Performance Tuning Analysis Services 2008

Lessons Learned from 128 Core OLTP Testing

Make your DBA life better using SQL Server technologies - notes from field & best practices

Monitoring and Tuning Parallel Query Execution

Non-Functional Dependencies - A talktorial on getting performance and scalability right through proper Database Design and understanding Set and Relational theory

Optimizing tempdb and temporary object use

Performance Management for SQL Server with SCOM 2007

Performance Monitoring & Tuning - Documented Tips & Tricks

Performance Troubleshooting made easy with PAL

Photograph: SQL Server Crash Dump Analysis

Scaleout scenarios with Service Broker

SQL Server 2008 Reporting Services Scalability and Performance

Supercharge MDX performance using MDX Studio

Transaction Log Performance Tuning, Stop shouting Timber!