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

  • 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

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

    Reply
  • Great job buddy..

    Reply
  • good sir in sqL Server

    Reply
  • Great Job

    Reply
  • Good Job…

    Reply
  • Really a group of excellent query statement

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

    Reply
  • Fantastic!

    Reply
  • 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

    Reply
  • 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

    Reply
    • It means that your server’s disk does not have enough space to load the database files. Try restoring in another disk with enough space

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

    Reply
    • Hi Vikas, the backup may well be compressed so the size of the MDF and LDF may exceed 350GB when uncompressed

      Reply

Leave a Reply

Menu