Watch Past Sessions

The Perfect Index

Target Audience: Database Administrators or Developers who want to create useful and thoughtfully designed indexes Abstract: Creating indexes is one of the most powerful ways to improve performance in your SQL Servers. It’s not easy to form indexes for a large and complicated query, and things only get more complicated when queries can come from…
Read More

An introduction to partitioning

Target Audience: Database Administrators\Developers with minimal experience of partitioning in OLTP\OLAP databases. Abstract: This mainly demo based session will cover the following: An introduction to partitioning, core concepts and benefits. Choosing a Partitioning Key Creating Partition Functions & Schemes Indexing Considerations Splitting, Merging & Switching Partitions Implementing Partition Sliding Windows Filegroup Restores with Partitioning After…
Read More