SQL SERVER - Download FAQ Sheet - SQL Server in One Page « Journey to SQL Authority with Pinal Dave

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

April 28, 2008 by pinaldave

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

Posted in Best Practices, DBA, Database, Pinal Dave, SQL, SQL Add-On, SQL Authority, SQL Constraint and Keys, SQL Documentation, SQL Download, SQL Function, SQL Index, SQL Joins, SQL Query, SQL Server, SQL Tips and Tricks, SQL Trigger, SQL Utility, Software Development, T SQL, Technology | 27 Comments

27 Responses to “SQL SERVER - Download FAQ Sheet - SQL Server in One Page”

on April 29, 2008 at 9:22 am Mitesh L Shah

This is remakable work ! Really Appreciated.
Nice to go through it with one page before any exam or technical interview :)
Thanks a lot ! Enjoy :)
on April 29, 2008 at 10:38 am Kevin

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
on April 29, 2008 at 12:38 pm Babar Javaid

In the constraints section the spelling of the Foreign key is wrong. Kindly correct the spelling.
on April 30, 2008 at 5:13 am Ben Nadel

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??
on April 30, 2008 at 12:56 pm raman

hi Ben Nadel

UPDATE contact
SET date_created = DEFAULT
WHERE id = 1

its true .
on May 20, 2008 at 4:56 pm SQL SERVER - Four Basic SQL Statements - SQL Operations Journey to SQL Authority with Pinal Dave

[...] If you want complete syntax for this four basic statement, please download FAQ (PDF) from SQL SERVER - Download FAQ Sheet - SQL Server in One Page [...]
on May 29, 2008 at 9:47 pm Jason

Great sheet!
on June 3, 2008 at 7:46 pm HEMAL SHAH

Hi Pinal,

Excellent work. Appreciated.

Regs
HEMAL
on June 5, 2008 at 9:51 pm Afzal

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

regards
Afzal
on June 7, 2008 at 7:40 am bvreddy

hai sir
Excellent work. Appreciated
on June 9, 2008 at 6:40 pm Srinivas Reddy K

Hai

Great Work

Keep it up
on June 17, 2008 at 10:38 am prabha

hi to all
the great work
by
M.Prabha
DJAME
on June 30, 2008 at 6:57 am Srinivas Arvapally

Hi
It’s really wonderful
We can say it as Sql in a Page.
(for the reference)
on July 1, 2008 at 2:47 pm SQLAuthority Download - SQL Server Cheatsheet Journey to SQL Authority with Pinal Dave

[...] The article which discuss about SQL Server cheatsheet is SQL SERVER - Download FAQ Sheet - SQL Server in One Page. [...]
on July 3, 2008 at 11:53 am Shankar

Hi,
How to open a database in sql2005,and how to work with that?
on July 9, 2008 at 2:20 pm Zuzer

Very Good Work
Appreciated
on July 9, 2008 at 6:46 pm Mahesh Chudamani

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
on July 11, 2008 at 12:52 pm Bhavani

Is there any way to find nonalphanumeric characters in a column? I need to remove all nonalphanumeric characters from a column.
on July 12, 2008 at 10:39 am kimminseok

nice resource ! thank you~
on July 17, 2008 at 1:27 pm Tanmaya

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.
on July 23, 2008 at 10:32 am Raghu

Hi good job.

I want to do MCDBA will u please sugest me a good book.
I am Production DBA.
on July 30, 2008 at 3:47 pm Haribaskar

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.
on August 19, 2008 at 8:47 pm Umer

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
on August 25, 2008 at 1:56 pm lakshimsha

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.
on September 5, 2008 at 12:27 am PRashanth

Great job buddy..
on November 20, 2008 at 11:23 am Prashant Gupta

good sir in sqL Server
on December 23, 2008 at 11:52 am codingsense

Great Job