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!
1 Comment
