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)
This is remakable work ! Really Appreciated.
Nice to go through it with one page before any exam or technical interview :)
Thanks a lot ! Enjoy :)
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
In the constraints section the spelling of the Foreign key is wrong. Kindly correct the spelling.
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??
hi Ben Nadel
UPDATE contact
SET date_created = DEFAULT
WHERE id = 1
its true .
[...] 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 [...]
Great sheet!
Hi Pinal,
Excellent work. Appreciated.
Regs
HEMAL
Hi,
i want to do certification in Sql server 2005 as an DBA.can you suggest any book for the same.
regards
Afzal
hai sir
Excellent work. Appreciated
Hai
Great Work
Keep it up
hi to all
the great work
by
M.Prabha
DJAME
Hi
It’s really wonderful
We can say it as Sql in a Page.
(for the reference)
[...] The article which discuss about SQL Server cheatsheet is SQL SERVER – Download FAQ Sheet – SQL Server in One Page. [...]
Hi,
How to open a database in sql2005,and how to work with that?
Very Good Work
Appreciated
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
Is there any way to find nonalphanumeric characters in a column? I need to remove all nonalphanumeric characters from a column.
nice resource ! thank you~
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.
Hi good job.
I want to do MCDBA will u please sugest me a good book.
I am Production DBA.
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.
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
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.
Make use of job which is specifically used for it
Great job buddy..
good sir in sqL Server
Great Job
Good Job…
Really a group of excellent query statement
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.
Fantastic!
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
Are they in the same server? Are the table having the same number of records?
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
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
Thanku very much 4 ur quick reply………backup file size is 140GB…and m having 350 GB of space in that drive…………….?