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

Does the EdbMails support attachment recovery? (3h)

SQL Setup (12h)

DW Design help (1d)

Composite indexes and best practice for Interval-valid values (1d)

Need help writing SQL query to find value from a table based on two specific values (2d)

Backup history not showing - Sql server 2012 (2d)

Get the latest person initial last entered by date....REVISED (2d)

SQL Query singular column date as at today (2d)

- Advertisement -