Experts Exchange - Writing Faster SQL Server Queries: Pt 2

Learn strategies for improving database performance from Experts Exchange SQL Server pro Tim Chapman.

Properly written queries and well-designed indexes are key to improving database performance and working faster and more efficiently. In part two of Writing Faster SQL Server Queries with Experts Exchange Expert Tim Chapman, you'll learn:

- How to efficiently design transactions to minimize system blocking
- Strategies for handling queries involving many joins
- How to leverage SQL Server constructs to de-dupe data
- Common execution plan "red-flags"
- How to use a Numbers table for efficient operations
- An overview of indexing

Tim Chapman is a SQL Server consultant specializing in system architecture, administration and performance tuning. Co-owner of www.sqlservernation.com, Tim is a Microsoft MVP and has passed the SQL Server 2005 & 2008 MCITP tests for Database Administration and Database Development. He is also an Experts Exchange certified Expert with thousands of questions answered in the SQL Server 2005 and SQL Server 2008 zones.

** View the high-quality version of this webinar at http://experts-exchange.posterous.com **

Category:

Science & Technology

Tags:

• SQL server
• queries
• training
• de-dupe data
• numbers table
• indexing
• minimize system blocking
• Experts Exchange