Join for free and connect with our local tech scene

Stay on top of the latest companies and upcoming events with our weekly newsletter, and be counted among the people building the future of your local tech community.

Raleigh-Durham, NC /

SQL Server Standard Candles: Slow Queries vs. Fast Queries

Vaco 2501 Blue Ridge Road , Raleigh, NC 27607 (map)

SQL Server is Microsoft's flagship relational database product. It is powerful, popular, and battle-tested. It can store and query billions of rows of data without breaking a sweat.

But sometimes we write a query, and it ends up being slow. What's going on here?

In this presentation we will discuss query performance. We will get into the weeds here and there, but not so deep as to get lost. This is meant to be a presentation that gives practical tips for query performance improvement; it will not be a course on the implementation details of SQL Server itself.

Here is a list of topics that will be briefly covered:

How data is stored and accessed

Data type storage sizes

How data table design affects query performance

How index design affects query performance

How query design affects query performance

Determining query performance when a stopwatch is not available

Predicting optimal query performance

Identifying queries that are already at or near peak performance

We will not be covering:

Hardware/File/OS performance improvement techniques

Advanced T-SQL scripting

Table/Query hints

Concurrency

Calling into SQL Server from other languages

This presentation will exclusively cover SQL Server. No .NET language experience is required. This means everyone interested in SQL Server query performance is welcome, regardless of preferred programming language!

Presenter: Derick Linkous

Comments

Sign in to comment.