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.
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
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