• New harvesting force taxifier
• Databases structures
• Immediate File Initialization (IFI)
• How Microsoft® SQL Server™ stores data
• How Microsoft® SQL Server™ localises data
• Lab

1. Detecting and analyzing information on database engine

• Working with tables and temporary variables
• Concurrence
• Transactions
• Isolation levels
• Microsoft® SQL Server™ blokcades architecture
• Microsoft® SQL Server™ and Storage Area Networks
• Partitioning tables and indexes
• Lab

1. Project and table structures’ influence on DML and RDBMS operation performance

• Lab

1. Optimising queries and data access operators

• Tuning process
• Performance monitoring tool
• SQL query processing steps
• Understanding execution plans
• Measuring query performance (TIME and IO)
• Data access operators
• Lab

1.  Working with indexes

• Introduction to indexes
• Types of indexes
• Creating and modifying indexes
• Metadata
• Index-related Data Management Views
• Index fragmentation in Microsoft® SQL Server™ and counteracting the event
• Indexed views
• Monitoring indexes
• Best practices
• Lab

1. Working with statistics

• Statistics – what for?
• Numerical taxifier
• Incremental statistics
• Filtered type statistics
• Statistics maintenance
• Lab

1. Working with „in-memory" objects (as an option)

• „in-memory” architecture
• Tables and indexes
• Stored and natively compiled procedures
• Constraints
• Data Management Views for „in-memory” objects
• Lab

1. Performance measuring tools and techniques (as an option)

• Techniques and tools used among others to:
• Identify long-term queries
• Deadlock detection
• Detecting blocked processes
• Creating baseline