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.
Reference : Pinal Dave (https://blog.sqlauthority.com)
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.
36 Comments. Leave new
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 .
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)
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.