SQL Server developers factsheet

A colleague pointed me to a nice cheat sheet for SQL Server developers. It contains:

- A checklist for writing fast queries
- Sargability of queries
- A checklist for creating indexes
- A legend of the ‘Execution Plan Icons’, including some optimizing tips and tricks.
- All datatypes, including memory-usage and indication for best performing types
- All string functions
- All system functions
- All date and time functions
- A list of all dateparts
- The cursor functions
- The mathematical functions

Source: http://www.dotnet4all.com/snippets/2008/04/factsheet-for-sql-server-developers.html

Direct link: http://www.dotnet4all.com/snippets/factsheet%20SQL%20Server.pdf

Note: Cross posted from Rob Pellicaan IS Blog.

Permalink