SQL Server – 2008 – Cheat Sheet – One Page PDF Download

Very frequently I have been asked to create a page, post or article where in one page all the important concepts of SQL Server are covered. SQL Server 2008 is very large subject and can not be even covered 1000 of pages. In daily life of DBA there are few commands very frequently used and for novice developers it is good to keep all the important SQL Script and SQL Statements handy.

I have attempted to create cheat sheet for SQL Server 2008 most important commands. User can print this in one A4 size page and keep along with them. This can be used in interviews where T-SQL scripts are being asked.

Let me know your opinion and if you find this useful.

Download SQL Server 2008 Cheat Sheet

Reference : Pinal Dave (http://blog.SQLAuthority.com)

63 thoughts on “SQL Server – 2008 – Cheat Sheet – One Page PDF Download

  1. Sorry my bad. It worked today :) I downloaded the cheat sheet.

    Thanks the cheat sheet is really useful. You have done a wonderful job.


  2. Hello Sir,

    The information there on this blog is very useful & helpful thanks for providing such informative infromation.

    Sir i have a query in ms-sql server2000
    can we convert numeric(18,0) to identity(1,1) which will be primary key ,
    since this ID numeric(18,0) is a foreign key in another table so i wanted that this key should be as primary auto incrementing key

    whereas i am also unable to do insert into statement for the same
    error ocuuring is as : Cannot insert explicit value for identity column in table

    Can you please help me out.


  3. hi, i would like to ask a question,
    do you know how to get month from a query?
    if i want to get a date, i use

    select birthday
    from user

    what if i want to get a query where the birthday month is May for example?


  4. HI Dave sir,
    I m new to sql server .. can u please provide me some links where i can find out how sql server is used on application point of view. How we stored procedures are useful in practical scenerio..

    provide me some good links for clearing basic concepts

    Thanks soo much for your help.



  5. Hi,

    Can anybody tell me the difference between server studio and server studio express?

    Dont mind if this is silly qtn. m new to sql server.

    thanks munch in advance.


  6. Hello Sir,
    i have a query on Sql server 2000. Can we Restore selective databases from Tape Drive(BrightStor ARCserve Backup Tape Drive) having tape of Ultrium(800 GB) to a remote server’s folder location through Query analyser. Because it is showing error in restoring that database to that remote server from that Tape Drive due to Space issue. So i want to directly restore that database from query analyser without coping it to that location and then from there to restore.

    manoj kumar


  7. Hi Pinal,
    wishing u a very happy Diwali.
    May I know as a fresher how to start reading your blog. I find all your blogs are very helpful, but for a fresher, its hard to find where to start.
    So suggest me any point from where I can start reading it.

    thanks & Regards
    Vikrant Bam


  8. Hi Pinal Dave,

    Is there a query to check from the SQL log to see who got access to the DB and what was the Query executed by that user ?

    Also if the DB is hacked how to check the logs to see what was the attempt made to get into the database.


  9. Hi everybody! Someone could help me about UDF calls over linked servers or if it’s possible to create a synonym for a scalar UDF in a linked server (I’m trying this from denali and a sql 2008 but no way…)?

    Thanks in advance!



  10. hi sir
    this cheat is very useful for us.. i am very thankful for you if you give a good answer for this qus >
    what is the main different of sql, my sql, sql 2000, sql 2005, sql2008,
    what is the magic tables?
    still i am waiting for your kind revert..


    • hii pinal im using window 7 home basic 64 bit os,when im installing sql server 2008,some error not be install appear native sql install boot strapper error message.please let me know d exact answer.


  11. Dear Dave,

    I am managing an OLTP server. Sometimes my replication become down due to unknown reason. Is there is any way to find which cause replication failure?


  12. another problem is to we had connected six web server towards our database server.Sometimes the net work traffic is very high between some of these web server and DB server.
    so far i being understand that its problem in the application side.how we can exactly identify which query raises N/W traffic.


  13. sir, i m installed sql express with advanace service 2008 . but in last installation progress facing in errorTITLE: Microsoft SQL Server 2008 Setup

    The following error has occurred:

    The service did not start due to a logon failure.

    For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.1600.22&EvtType=0xB4A84AA1%25400x5D9A8C61



    so pl help me . how can i sucseed sql .

    With Regards


  14. For all those struggling to download these pdf docs, try using a different browser other that IE. I had issues so switched to Chrome.

    All’s well that end’s well..


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s