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

Linked Server Selection Query Fails with "MS DTC has stopped this transaction" (3d)

Query almost perfect but brings wrong record (4d)

Installing integration Services with Web edition (5d)

Can I add dynamic WHERE clause to this query? (6d)

Show difference between records in master file and submitted records (22d)

Sql_sap hana date calculation (29d)

Count the item when appearing more than once in the column (30d)

BATCH CTE and recursion - CTE table doesn't exists (32d)

- Advertisement -