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!