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, 15 June 2006 11:58:51 (Pacific Standard Time, UTC-08:00) #    Comments [2]  | 

 

Friday, 21 July 2006 04:33:25 (Pacific Standard Time, UTC-08:00)
Any chance of bringing this session to DNRtv ?
Tuesday, 05 September 2006 15:35:57 (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.

CL
Comments are closed.
All content © 2019, Richard Campbell
On this page
This site
Calendar
<2019 January>
SunMonTueWedThuFriSat
303112345
6789101112
13141516171819
20212223242526
272829303112
3456789
Archives
Sitemap
Blogroll OPML
Disclaimer

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: