Luis Cazares (10/29/2012)

---

Lynn Pettis (10/29/2012)

---

Jeff Moden (10/29/2012)

---

rajeshpalo2003 78748 (10/29/2012)

---

Please go to the following link:-

http://sqlcheatsheet.wordpress.com/2012/10/26/sql-server-2008-2008-r2-cheatsheet/

Download the PDF (sqlserver2008r2_cheatsheet_v1-01.pdf). Password: Harinam

This is very good document for the freshup your memories with SQL Server features.

For all those who would use such a thing... Caveat Emptor!

And while you're studying such canned answers, be advised that a lot of us don't ask canned questions on interviews especially for senior positions. For example...

{Me} How many columns can a table have?

{You} 1,024!

{Me} So why are INSERTs designed to handle up to 4,096 columns?

{You} {wtf???}

Or:

{me} Why would you have table with that many columns?

{Interviewee} ?????

I know. To support a bad database design.

The idea might be good for a cheat sheet (poorly executed) but it shouldn't be taken as a guide for a good interview.