SQL Server Cheat Sheet for Developers

For my Today's blog, I wanna share the Cheat Sheet for SQL Server Developers created by Xander Zelders that i have been using for some time now. It is a Microsoft SQL Server (versions 6.5, 7.0, 2000 and 2005) cheat sheet that can be printed on a A4 paper (printed on both sides), laminated and post on your cork board or place on the top of your desk. You need to print it with a color-printer to be able to see the color coded information.




The cheat sheet contains:
- Checklist for writing fast queries
- Sargability of queries
- Checklist for creating indexes
- Examples of connectionstrings
- The syntaxis for SELECT, UPDATE, DELETE and INSERT queries
- The syntaxis for CREATE TABLE and ALTER TABLE
- CREATING, ALTERING and DELETING Stored Procedures, Indexes, Views, Triggers and Functions
- 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

Download the Cheat Sheet for SQL Server [Dotnet4all]

For more SQL Tips and Tricks, subscribe now.