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

Top 1 (7h)

Slab System (9h)

Subtract total counts from previous row (11h)

Replica Node availability Node (16h)

Is there a better way to do this (padding Time field with zeros) (1d)

Frustrated SQL newbie (1d)

Impact of changing server name SQL Server (1d)

SSRS - hide rows based on the user who run the report (1d)

- Advertisement -