Cursors

• Cursors vs Table Variables

 Misc

• Commonly used system functions and global variables
• DROP all PK and FK constraints for a database
• How to build a SELECT dynamically
• How to use RAISERROR and custom error messages
• How to use xp_cmdshell to locate a file
• PROC - Delete all indexes except primary key

• Script to migrate DTS packages
• Show all date formats
• Stored Procedure for Building Dynamic Crosstab Queries
• Stored Procedure to Backup All Databases on the Server
• Why you use SCOPE_IDENTITY instead of IDENTITY

 Misc Admin Scripts

• Append datetime string to backups
• Migrate Logins using BCP
• Migrate Logins
• Return all DatabasePropertyEx Values - sp_GetDBStatus

• Show all PKs for all tables
• Show all tables without a PK
• Shows all FKs for all tables
• Track SQL Server Application Usage

 Performance Tuning

• Federated Database

• Indexed View

 Security

• How to implement row level security using Views

• How to validate an application

 Triggers

• AFTER triggers
• INSTEAD OF trigger example

• INSTEAD OF Validation

 UDFs

• A function that checks for Leap Year
• A simple version of PROPER

• Prime Number Test
• Zellers Congruence

Templates and Patterns