My Account
Home Events Current Events Upcoming Events Past Events SQL Immersion Events Event Log Services Mentoring Custom Courses Resources Articles Blogs Books Event Resources Knowledge Base Articles Q & A SQL Scripts Useful Links Whitepapers Partners Communications Contact Us		SQL Immersion Events   Tuning High Performance Databases using SQL Server 2000 Nothing but Real-world High Performance Tuning Techniques for the Backend 11-14 October 2004 - Chicago, Illinois 4-day Immersion event presented by Kimberly L. Tripp   Event Cost $2,195 USD Early Registration Deadline 1 August 2004 Early-bird Registration Cost $1,995 USD   Special Offer For August: If you attend the 5-day Immersion Week, stay in the special conference hotel (the Hilton Garden) and register by September 1st - your price will be the earlybird discount of $2,295.   Combine this event with the 1-Day ADO.Net Event and create an Immersion week to save even more! See the full price list here.   Web Registration is available for this event   Join us for a four day event which will immerse you into the world of performance tuning and optimization for SQL Server 2000. This event started from a series of popular conference sessions and workshops - including sessions that have been top rated at conferences around the world. Together these materials combine to create a cohesive and interesting four day course. Fast-paced and packed full of information, Kimberly's lectures are always interesting. In 2003 Kimberly was the top rated speaker at virtually every US event at which she lectured. In fact, at Microsoft Tech*Ed US 2003, Kimberly delivered 5 sessions [out of 380] and all 5 were rated among the top 12 - including the number one spot! A common comment made is that Kimberly has the gift of being able to communicate technical materials and make subjects that would otherwise be dull - somewhat interesting. Kimberly's looking forward to this new combination immersion event which pulls top sessions, top recommendations and some of the most effective ways to improving performance - both quickly and effectively.   If you want to understand index internals, statistics, how the optimizer chooses indexes, strategies for index coverage, procedure plans, caching and recompilation, design techniques to improve cache utilization, how to minimize lock contention and blocking - and just want a better understanding of the SQL Server environment...this rare immersion event is the place to be!   Also, if you're wondering how much information will be applicable to SQL Server 2005 - almost everything! Where changes are expected; they will be discussed.   Improve your performance today and acquire knowledge and skills that will continue to help you tomorrow!   Here's the comprehensive agenda:   Overview The Goals in Achieving Optimal Performance   Methodology Where can performance be improved? Our Focus - SQL Server Designing for Performance Known Problems Finding the Unknown Problems Long Running Queries Frequently Executed Queries Tools for "fishing" Keeping the performance optimal Where to go for more information! Database Structures for Performance Creating Databases Database Structures The Anatomy of a Data Modification From Data Access Locking Write-ahead Logging Data and Log File Placement How the Transaction Log Works Optimizing Log Activity Table Design for Performance Data Integrity Principles Table Relationships Mathematically Directionally Concepts in Partitioning Table Partitioning Partitioned Views Features Creation Implementation Performance SQL Server 2005 Partitioned Tables/Indexes Range Partition Concepts Creation The Rolling Range Writing Effective Queries for Performance Limiting Results Avoid Ambiguity Aliasing Tables/Columns Character Strings Search Arguments Indexing for Performance - Index Internals Index Concepts Table Structure Index Internals Heaps Why Cluster Table Usage Employee Table Case Study Why Cover Internals? Key Points... Indexing for Performance - Statistics Query Specific Index Usage - How? Data Access Patterns Statistics What do they look like? What are they telling us? Statistics and Interpolation Statistics How do you see them When/how do they get created When/how do they get updated Interpolation - When it goes wrong Even better... Indexes! Indexing for Performance - Search Arguments and Joins Selectivity How to Improve Queries with Varying Search Arguments (SARGs) Indexing for AND Indexing for OR How to Improve Joins Phase I Phase II Phase III Indexing for Performance - Aggregations and Indexed Views Indexing for Aggregations HASH Aggregations Stream Aggregations Views & Indexes Indexed Views Defined Indexed View with Joins Indexed View with Computations Indexed View with Aggregations Another Option Power of Indexed Views Creation Maintenance Index Maintenance How Fragmentation Occurs What Fragmentation Means Internal Fragmentation External Fragmentation Swiss cheese Problem How to See Fragmentation Manually Programmatically Automatically How to Minimize Fragmentation Rebuilding an Index Defraging an Index Restructuring an Index Why When How Automating Index Rebuilds Optimizing Procedural Code Initial Processing Resolution Compilation/Optimization Execution/Recompilation Recompilation Issues When do you want to Recompile? Options for Recompilation? What to Recompile? Stored Procedure Best Practices Naming Conventions Avoiding Excessive Recompiles Writing Solid Code Detecting Excessive Recompiles Profiling using EventSubClass Transactions - Locks, Logging, Locking and Blocking Transactions Nesting The Anatomy of a Data Modification (re: locking) Lock Granularity/Escalation Lock Compatibility Lock Isolation Levels Types Concerns (re: Lock Duration v. Consistency) Lock Hints Query Level Session Level Locking Livelocks Deadlocks Minimizing Blocking Investigating Locks/Locking  Wrap-up
Privacy Policy. All Rights Reserved. ©2007 SYSolutions, Inc.