Download SQL SERVER Database Coding Standards and Guidelines Complete List
Just like my previous series of SQL Server Interview Questions and Answers Complete List Download, I have received many comments and emails regarding this series. Once I go through all the emails and comments, I will make a summary of them and integrate them with my series. I have also received emails asking me to create PDF for download. I have created that as well. Please feel free to download it and use it.
Please ask me any questions you might have. Contact me if you are interested in writing a mini series with me.
Download SQL SERVER Database Coding Standards and Guidelines Complete List
Complete Series of Database Coding Standards and Guidelines
SQL SERVER Coding Standards and Guidelines – Introduction
SQL SERVER – Coding Standards and Guidelines – Part 1
SQL SERVER – Coding Standards and Guidelines – Part 2
SQL SERVER Coding Standards and Guidelines Complete List Download
Other popular Series
SQL Server Interview Questions and Answers Complete List Download
SQL SERVER – Data Warehousing Interview Questions and Answers Complete List Download
I personally find this standard very useful and I practice everyday during my consultancy business. Let me know your thoughts.
Reference: Pinal Dave (https://blog.sqlauthority.com)
76 Comments. Leave new
can u send imparten link log shipping and mirring ,replication pls send me liinks about
i want to learn some innovative techniques in sqlserver.please give me help.
I found your article very usefull and with many good advices.
I just noticed in the first advice in page 6, when you share how we can handle apostrophe withing a string, that you named the variable as @sExample, where I belive the “s” after “@” is part of your sintaxis for naming your variables depending of the data type.
That is a another good think to do, but you did not go in further details about that.
I would like to know what are your advices for variabe naming.
do you have or do you know a good web site or book with erd design case scebario? thanks
nic e job,
you have done..
i never seen this type of this type of user frendly knowledge shearing blog.
i impressed..
many time when i get problem or in trouble it helped me..
Its really helpuful, thank u sir.
Ved Sharma
Actully i nead the sql query for the interview purpose only query not thoery.
sir plz give the full coding for creting the database in sql server2005(ceeate row ,collum etc)
now i am learning sql server management . will you pls give me a link of downloading free ebook of sql server
Hi Pinal,
This is related to the guideline “Do not store binary or image files inside database.”
As per the research paper published in April 2006 – “Objects smaller than 256K are best stored in a database while objects larger than 1M are best stored in the filesystem. Between 256K and 1M, the read:write ratio and rate of object overwrite or replacement are important factors.”
Link – https://www.microsoft.com/en-us/research/publication/to-blob-or-not-to-blob-large-object-storage-in-a-database-or-a-filesystem/
Thanks,
Anoo S Pillai
Hi,
i am create two tables and primary key also and i created foreign key but not create the foreigh key the query i will send to you
create table Employee(Employee(empid) foreignkey References Department(deptid)).
it is correct query or not please give me rply .
Thanks&Regards
Srinivas