I have created a factsheet for SQL Server (6.5, 7.0, 2000 and 2005) developers that fits on one A4 (printed on both sides) so that you can laminate it and keep it on your desk. You have to print it with a color-printer to be able to use all information!
An overview of the contents of this factsheet:
- A checklist for writing fast queries
- Sargability of queries
- A checklist for creating indexes
- Some 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
If you have some feedback, please send it to me so that I can improve this factsheet.
Download the SQL Server factsheetLabels: Factsheet, SQL Server, SQL Server 2000, SQL Server 2005
Posted by Xander Zelders
0 Comments:
Post a Comment
<< Home