Just came across this SQL Server Developer Fact Sheet made by Xander Zelders of DotNet4All. It’s a handy cheat sheet, with all the common stuff you need as a dev:
- Data types, common string/system/date and time/math/cursor functions
- Basic SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER syntax
- SARGability
- Concise checklist for creating indexes and fast queries
- Execution plan icons (aptly color coded – red means no-no!)
- … even connection strings!
Pretty handy and organized reference. Thanks Xander!
SQL Server 2005 Cheat Sheet,
- Tweet
Related posts:
- MySQL EXPLAIN Cheat Sheet …
- SQL Server-Related Cheat Sheets That Can Save You Time …
- Using the OUTPUT clause in SQL Server 2005 …
- Executing Batches Multiple Times (SQL Server 2005 only) …
- How to Use the OUTPUT Clause (SQL Server 2005/2008) …
- Troubleshooting SQL Server 2005 "No global profile is configured…" …
[…] Toolbox / T-SQL Scripts, Powershell by belle on October 17th, 2008 I previously posted about a SQL Server CheatSheet from DotNet4All that I thought was useful and comprehensive. If you already know what you need to do, but just […]