The UK SQL Server User Group in combination with SQLskills.COM is pleased to bring you what we think is a really fantastic and unique SQL Server event with one of the world's leading SQL Server guru's - Kimberly Tripp.
Join us for a three day event which will immerse you into the world of performance tuning and optimization for SQL Server. For 3-days most labs and demos will be targeting SQL Server 2005, however, many techniques will work across both SQL Server 2000 and SQL Server 2005 and when something is version specific it’s limitations, restrictions and requirements will be discussed. More importantly, our classroom environment will include both versions.
This course started from a series of popular conference sessions and seminars – including sessions that have been top rated at conferences around the world – and now includes hands-on labs and significantly more time to really dive into the content. Together with these hands-on labs, the materials combine to create a cohesive, interesting and in-depth course.
Fast-paced and packed full of information, this is the way to understand better design practices that can improve resource utilization, scalability and overall system performance. If you want to improve performance and get a better understanding of SQL Server internals...this is the place to be!
Improve your performance today and acquire knowledge and skills that will continue to help you tomorrow!
Key features discussed: vertical and horizontal partitioning, table structures, index internals, statistics, how the optimizer chooses indexes, strategies for index coverage, procedure plans and plan caching, caching and recompilation, techniques to improve cache utilization, methodologies for finding performance problems.
For a full agenda and more information: http://sqlserverfaq.com/train/kt200608