This presentation looks at a number of common mistakes that people make in SQL Server. There are edge cases where these might not apply, but for the most part, these are mistakes that you do not want to repeat as you are building applications on the SQL Server platform.
The basic agenda:
- SELECT *
- Shrinking databases
- GUID as a Clustered Key
- Functions in the WHERE Clause
- IS NULL
- Multi-row triggers
- Indexing all Columns
- Cursors
- SA Account Usage
Presentations:
- V2 - Boulder SQL Server User Group - October 19, 2010
- V3 - Rocky Mountain Tech Trifecta v3 - Mar 5, 2011
Note: Presentation updated Mar 3, 2011.
