SQL Server Cheatsheet has been extremely popular download from my blog. There is plenty of request for me to update it with SQL Server 2012 features. I have finally upgraded the cheat sheet with SQL Server 2012 features. The new cheat sheet has following updates.
- SSMS Shortcuts
- Columnstore Index
- SQL Server 2012 Datetime Functions
- SQL Server Ranking Functions
- SQL Server 2012 Analytic functions
It has been an excellent experience to upgrade the cheat sheet. However, as the new cheat sheet contains way more information than earlier version of the cheat sheet, the size of the page is also increased. The page size is now no more A4 size, it has been increased to A3 size. When printed on A3 page it looks very clean and easy to read. If you print that on the A4, you will find the pages are a bit small.
Cheatsheet is free for anybody and everybody to download and print it, as long as you do not modify it. However, it is now allowed to store, host or upload anywhere without prior permission.
Previous cheat sheet was very popular and I have received many good comments. I am eagerly waiting for your feedback about this new updated cheat sheet.
Download SQL Server Cheatsheet
I have printed limited copies of the cheat sheet on photo quality laminated A3 size page. This looks AWESOME!
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
19 Comments. Leave new
Downloaded, thank you :)
Dear Pinal sir,
Thanks a lot for a great sharing…
Awsome resource, thank you!
Thanks sir…
Thanks,
one another shortcut:
ALT+F1 will give total description of selected table(name) on query window
Thanks a lot for the resource.
It’s a bit confusing when it comes to download it though, ad the download link is so close to the google ad…
In any case, a SQL cheat sheet is an absolute necessity, thanks again!
I think you have a typo above. I believe you meant to state “not” and not “now”.
However, it is “now” allowed to store, host or upload anywhere without prior permission.
Thanks for the great cheat sheet.
Thank you very much sir..
for the Cheat Sheet.
Thanks sir…
Thanks sir , it’s very helpful
Hi Pinal, I noticed 2 typos. You can see them in this screenshot I uploaded here:
Thank you so much. I will fix them in next version for sure!
Thank you sir
When i click the link its hows sql 2008 cheat sheet… can you please keep the new attached one…
Good One…Thanks.
Note:
1) Didnt see an entry for TRY_CAST under the New SQL 2012 Function
2) Pagination using OFFSET and FETCH NEXT implementation is missing
3) Sequence creation
4) Exception handling using THROW
There’s no link to download it
Fixed.
Seem like the link is broken again
Fixed!