SQL Querying Tips & Techniques at Tech Ed Boston#

I'm about to do my last session at Tech Ed Boston, a repeat of my session on Monday, SQL Querying Tips & Techniques.

I figure I better just put the session sample here, so you can download it if you're so inclined.

sample.zip (5.49 KB)

The following files are inside the sample zip:

  • AdvQuerying_Setup.sql contains a script to create the tables and data for the samples
  • AdvQuerying.sql is the script with all the example queries I demoed in the session
  • Error Handling Main.sql is the script for the deadlock error handling stored proc
  • Error Handlng Secondary.sql is the script for setting up the deadlock demo

So to use these samples, create a database (I called it AdvQuerying) and then run the setup script. Then you're good to go!

Thursday, June 15, 2006 11:58:51 AM (Pacific Standard Time, UTC-08:00) #    Comments [2]  | 


Friday, July 21, 2006 4:33:25 AM (Pacific Standard Time, UTC-08:00)
Any chance of bringing this session to DNRtv ?
Tuesday, September 5, 2006 3:35:57 PM (Pacific Standard Time, UTC-08:00)
Dear Richard,

Your TechEd session in KL on tips and tricks for SQL Server especially leveraging on version 2005 really opens up a new perspective of database to me. Thanks for sharing your precious experience with all of us. I'm sure that "math idea" makes a big difference! Haha..well, keep up your good work. Thanks for allowing us to download and study your SQLs too. Your presentation humours and educates. Inspires too. Great job! :)

Have a wonderful time in Tech Ed and Malaysia.

Comments are closed.
All content © 2020, Richard Campbell
On this page
This site
<August 2020>
Blogroll OPML

Powered by: newtelligence dasBlog 1.9.7067.0

The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

Send mail to the author(s) E-mail

Theme design by Jelle Druyts

Pick a theme: