SQL SERVER – Download FAQ Sheet – SQL Server in One Page

One of the most popular request I have received on this blog is to create one page which list all the SQL Server FAQs. SQL Server technology is very broad as well very deep. This is my humble attempt to list few of the daily used details in one page. Let me know your opinion and suggestion.

Download SQL Server FAQ Sheet in PDF format

Reference : Pinal Dave (https://blog.sqlauthority.com)

, , , , ,
Previous Post
SQL SERVER – Query Analyzer Shortcuts – Part 2
Next Post
SQL SERVER – Find Table in Every Database of SQL Server

Related Posts

36 Comments. Leave new

  • Mitesh L Shah
    April 29, 2008 9:22 am

    This is remakable work ! Really Appreciated.
    Nice to go through it with one page before any exam or technical interview :)
    Thanks a lot ! Enjoy :)

    Reply
  • I tried to load a very large txt file(144GB) to database.

    I received this error after first 2 hrs of load.

    Step Error Source: Microsoft Data Transformation Services Flat File Rowset Provider Step Error Description:Error creating file mapping view: Not enough storage is available to process this command.

    Step Error code: 80004005
    Step Error Help File:DTSFFile.hlp
    Step Error Help Context ID:0

    We have HP EVA SAN.

    Is this because I/O issues? How do we fixed this problem?

    Thanks,
    Kevin

    Reply
  • In the constraints section the spelling of the Foreign key is wrong. Kindly correct the spelling.

    Reply
  • Very cool cheat sheet. From the UPDATE statement, it looks like you can use DEFAULT as an actual value, as in :

    UPDATE contact
    SET date_created = DEFAULT
    WHERE id = 1

    Is that true?? Does it just use the default value of the field??

    Reply
  • hi Ben Nadel

    UPDATE contact
    SET date_created = DEFAULT
    WHERE id = 1

    its true .

    Reply
  • Great sheet!

    Reply
  • Hi Pinal,

    Excellent work. Appreciated.

    Regs
    HEMAL

    Reply
  • Hi,
    i want to do certification in Sql server 2005 as an DBA.can you suggest any book for the same.

    regards
    Afzal

    Reply
  • hai sir
    Excellent work. Appreciated

    Reply
  • Srinivas Reddy K
    June 9, 2008 6:40 pm

    Hai

    Great Work

    Keep it up

    Reply
  • hi to all
    the great work
    by
    M.Prabha
    DJAME

    Reply
  • Srinivas Arvapally
    June 30, 2008 6:57 am

    Hi
    It’s really wonderful
    We can say it as Sql in a Page.
    (for the reference)

    Reply
  • Hi,
    How to open a database in sql2005,and how to work with that?

    Reply
  • Very Good Work
    Appreciated

    Reply
  • Mahesh Chudamani
    July 9, 2008 6:46 pm

    Hi Pinal,
    It’s a gr8 work and also I suggest you to include all the system tables,procedures and also system Information Views etc;

    Regards,
    Mahesh Chudamani

    Reply
  • Is there any way to find nonalphanumeric characters in a column? I need to remove all nonalphanumeric characters from a column.

    Reply
  • nice resource ! thank you~

    Reply
  • Hi,

    I have a problem with the report creation while exporting around 5000 records to an excel file from my asp.net application. Each time i am getting “Out of memory exception”.Please suggest what can i do with the my database so that i won’t get this error.I am using sql server 2005 database.

    Reply
  • Hi good job.

    I want to do MCDBA will u please sugest me a good book.
    I am Production DBA.

    Reply
  • Hi,
    I’m Hari . can you Please send me the book Name which includes all about SQL server 2005. i like to do certification in mssql server 2005. Kindly help me.

    Reply

Leave a Reply

Menu