SPEAKER DETAILS

img

Hugo Kornelis

sqlblog.com/blogs/hugo_kornelis/default.aspx
SQL Server MVP Hugo Kornelis is co-founder and R&D lead of perFact BV, a Dutch company that strives to improve analysis methods and to develop computer-aided tools that will generate completely functional applications from the analysis deliverable. The platform used for this development is SQL Server. In his spare time, Hugo likes to share and enhance his knowledge of SQL Server by frequenting newsgroups and forums, reading and writing books and blogs, and attending and speaking at conferences.

Sessions

T-SQL User-Defined Functions, or: Bad Performance Made Easy

Level :
Beginner
Date :
9:45 AM Saturday
Room :
PSEC4501
Track :
SQL Server Developers and...
Interested : (-) - Registered : (18)

Speakers: Hugo Kornelis

User-defined functions in SQL Server are very much like custom methods and properties in .Net languages. At first sight, they seem to be the perfect tool to introduce code encapsulation and reuse in T-SQL. So why is this feature mostly avoided by all T-SQL gurus? The reason is performance. In this session, you will learn how user-defined functions feed the optimizer with misleading and insufficient information, how the optimizer fails to use even what little information it has, and how this can lead to shocking query performance. However, you will also see that there is a way to avoid the problems. With just a little extra effort, you can reap the benefits of code encapsulation and reuse, and still get good performance.

Details

Powerful T-SQL Improvements that Reduce Query Complexity

Level :
Beginner
Date :
1:15 PM Sunday
Room :
PSEC4501
Track :
SQL Server Developers and...
Interested : (-) - Registered : (42)

Speakers: Hugo Kornelis

We’ve all dealt with nightmare queries: huge, twisted monsters that somehow work, despite being ugly and unmanageable. The time has come to tame these beasts, and the solution is available now, in SQL Server 2012. New T-SQL functions offer out-of-the-box solutions for many problems that previously required complex workarounds. Paging, Running totals, Moving aggregates, YTD, and much more comes at the power of your fingertips in SQL Server 2012. The only thing you need to do is learn the syntax. And that is exactly what this session is all about: a thorough description and explanation of the syntax, and loads of demos to demonstrate how you can use all these new features. Attend this session to boldly take SQL Server where it has never gone before!

Details
  • Not Interested
  • Interested
  • Attending

SPONSORS List