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 (http://blog.SQLAuthority.com)

About these ads

38 thoughts on “SQL SERVER – Download FAQ Sheet – SQL Server in One Page

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

  2. 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

  3. 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??

  4. Pingback: SQL SERVER - Four Basic SQL Statements - SQL Operations Journey to SQL Authority with Pinal Dave

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

    regards
    Afzal

  6. Pingback: SQLAuthority Download - SQL Server Cheatsheet Journey to SQL Authority with Pinal Dave

  7. 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

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

  9. 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.

  10. 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.

  11. Hi,

    I am having a problem related to INSERT INTO on the following platform:
    Microsoft SQL Server 2005 – 9.00.3068.00 (X64) Feb 26 2008 23:02:54 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2).

    However, if I use the same query on different platform, shown below, it works fine:
    Microsoft SQL Server 2005 – 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2).

    My Query:
    1) Drop and Create table
    2) add index to its columns:
    CREATE UNIQUE NONCLUSTERED INDEX [idxGroup4AndInseminationDate] ON [dbo].[tblForInseminationContainingHUKAndNMRDataWithNoDuplicates]
    (
    [herdBookNumber] ASC,
    [breedId] ASC,
    [IDType] ASC,
    [pedigreeStatus] ASC,
    [inseminationServiceDate] ASC
    )WITH (STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = ON, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO

    3) Insert data
    INSERT INTO [DBO].[tblForInseminationContainingHUKAndNMRDataWithNoDuplicates]
    SELECT *
    FROM dbo.tblTestForInsemination AS tblA
    WHERE tblA.herdBookNumber = ‘E5854/00220′ AND
    tblA.breedId = ‘1’ AND
    tblA.IDType = ‘2’ AND
    tblA.pedigreeStatus = ‘2’ AND
    tblA.inseminationServiceDate = ‘2001-03-16 00:00:00.000′
    ORDER BY ISNULL(tblA.authenticSire, ‘N’) DESC, tblA.PDResult DESC

    In expected result the order by works fine on the second platform but not on the first one, please help.

    Thanks

  12. hello Sir,

    is there any way to execute a query based on time.

    for example: evey 1st day of a month at 11am i want to execute one query. without user intraction

    is it possible?

    looking from you.

  13. I think the Microsoft website to download the trial version of their server sucks. I have spent 3 hours trying to find where to click to download the trial version. You get to one page and it’s a dead end every time. I would have thought that for a big IT company they would have hired people to do their web pages that knew what the hell they were doing.

    I don’t want to here that it cost $50.00 for the trial because it doesn’t. If you registered as I did do your supposed to be able to download the thing for FREE.

  14. i want to know ihave find issue on sql server 2000 storedprocedure script excute in a 5 second and on same script excute on sql 2008 take 2 min time plz help

  15. Hi all,
    I am getting an error while restoring a database from production to test server.
    Below is the error:
    Operating system error 1130(Not enough server storage is available to process this command.
    pls help

  16. Thanku very much 4 ur quick reply………backup file size is 140GB…and m having 350 GB of space in that drive…………….?

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