Level 300 - Advanced
It is not always the wrong configuration of a Microsoft SQL Server which causes bad running applications. Quite often you’ll find design problems in the database, bad indexes or a mix of all together. This workshop shows the different types of indexes you can use in an OLTP-System. Beside the basic stuff you’ll get introduced to different DMV’s which give you the chance to analyze and rate existing indexes and execution plans. Equipped with the basics of row-based indexes and the used tools we walk through different detailed examples and build solutions for common problems based on wrong indexing and/or database design.
Fasten seat belts for these topics which will be handled in detail:
- HEAP / Clustered Index / non-clustered Index – basics of indexing
- What key is an ideal candidate for a clustered index? Analysis of workloads is an essential part for a good determination
- Importance of statistics for performant queries
- Tools for the analysis of index performance and index conditions
- DML-Operations and its side effects to indexes
- Understanding and reading execution plans
- Difference of the physical JOIN operators
- Problem solution with partitioned views
- SARGable queries
- Usage of correct data types for a good performing execution of queries
- Foreign keys and it’s correct indexing
- Impact of different collations on queries
- Ascending key Problem
PrerequisitesHaving your own laptop with you with SQL Server 2012 or newer installed will give you the best experience.
Uwe Ricken is working with IT systems since the 90’s. He found the way to the technology of Microsoft SQL Server with the assignment for the development of membership administration software for the American Chamber of Commerce in Germany. After the development the software has been distributed to five additional European countries. The primary passion for developments with Microsoft SQL Server expanded in 2007 with his engagement as a DBA for the Deutsche Bank AG in Frankfurt am Main. After 6 years of operational experiences as a DBA and over 14 years as a developer of complex database models he earned in May 2013 the “Microsoft Certified Master – SQL Server 2008” certification which “was” the highest technical certification by Microsoft. The successful year 2013 has been finalized with the first MVP award for his outstanding support to the Microsoft SQL Server community in Germany and Europe. Uwe Ricken was the first MCM + MVP in Germany!
To provide his deep knowledge about Microsoft SQL Server to the interested community Uwe Ricken is blogging since 2010 at www.sqlmaster.de about his daily experiences with Microsoft SQL Server. His blog posts are in German language only to provide the German speaking SQL community enthusiasts deep inside views into the technology of Microsoft SQL Server.
Uwe Ricken is a speaker on many international conferences and events and preferred topics for “Database Internals”, “Indexing” and “Development”.