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

By Bill Graziano on 10 July 2006 | 3 Comments | 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.

Follow the link to MSDN Webcast: What I Wish Developers Knew About Writing Queries in SQL Server 2005 (July 2006)...

Discuss this article: 3 Comments so far. Print this Article.

If you like this article you can sign up for our weekly newsletter. There's an opt-out link at the bottom of each newsletter so it's easy to unsubscribe at any time.

Email Address:

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

Create union qry (0 Replies)

Idea for exception in transaction with just one ta (0 Replies)

sqlit, transaction (3 Replies)

The SQL AND & OR Operators (0 Replies)

Database (In Recovery) (16 Replies)

Using SQL in Your Web Site (0 Replies)

What is SQL? (0 Replies)

Foreign key design guidelines in composite PK (0 Replies)

Subscribe to SQLTeam.com

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email. Subscribers receive our white paper with performance tips for developers.

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -