MSDN Webcast: What I Wish Developers Knew About Writing Queries in SQL Server 2005 (July 2006)

By Bill Graziano on 10 July 2006 | Tags: Presentations , Webcasts


I'm doing a webcast on Wednesday, July 12th, 2006. The abstract reads "As a consultant, I visit many companies that are having performance problems with Microsoft SQL Server 2005 database. This webcast describes some of the most common problems I see from clients, and explains how to avoid them. I cover reading query plans, SQL Profiler, indexing, correlated sub-queries, temporary tables, and user-defined functions, and show how you can use them together to improve performance." It's going to be a mix of query tuning and some of the common problems I see writing queries.

You can download a ZIP file of the presentation and demo files here. You can view the presentation here.

Link: MSDN Webcast: What I Wish Developers Knew About Writing Queries in SQL Server 2005 (July 2006)


Related Articles

What I Wish Developers Knew About SQL Server (Presentation) (11 October 2007)

Speaking in Jacksonville and Orlando on October 8th & 9th, 2007 (4 October 2007)

SQL Server Express 2005 Tips and Tricks Presentation (6 March 2007)

SQL Server 2005 Express Tips and Tricks Web Cast (26 February 2007)

PASS 2006 Presentation: What I Wish Developers Knew About SQL Server 2005 (15 December 2006)

MSDN Webcast: What I Wish Developers Knew About Writing Applications for SQL Server 2005 (14 July 2006)

UPDATED: SQL Server 2005 Query Plan Webcast (20 March 2006)

Presentation: What I Wish Developers Knew About SQL Server (17 November 2005)

Other Recent Forum Posts

Count occurrences by time (14h)

AlwaysOn AG + Replication maintenance - two scenarios to get the job done (5d)

What happens in a dual LEFT OUTER join when the second join is NULL in both tables? (5d)

How to set a variable from a table with comma? (6d)

SSRS Expression IIF Zero then ... Got #Error (7d)

Understanding 2 Left Joins in same query (7d)

Use a C# SQLReader to input an SQL hierarchyid (8d)

Translate into easier query/more understandable (8d)

- Advertisement -