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
Useful Notes
very good articles keep doing things more and more
Hi Pinal,
That is a Very Very Good Compiled Document. Appreciate it
However, just one things i noticed. Please correct me if i am wrong.
Stored Procedure Naming Convention
– Is it feasible to start the User Created Stored procedure Name with “sp” ,since SQL Server looks for the Stored Procedure in the Master Database and assumes it to be as a System defined Stored Procedure?
I know you have mentioned not to start with “sp_”, but just a thought.
Thanks
Deepan S.
Its Really Good Article…
Best Of Luck for Bright Future…..
really great articals to be referred by any .net programmer.
thanks to pinal dave……..
Really fantastic…!
hi pinal,
This site is very much usefull
thanks to u
Thanks,
Vinod Dhone
Hello Mr. Dave,
Your articles are amazing and really very useful. I am a beginner in SQL BI and looking for resources, interview questions. It would be a great help if you can point me to those resources.
Thanks
Hi. Nice articles but I am interested in why you would want to prefix all stored procedures with ‘sp’. In the case of stored procedures I understand there is no impact but it seems superfluous and makes the natural reading of code less easy.
It reminds me somewhat of the polish notation used by many VB programmers that in the end leads to problems. Luckily ones that don’t currently afflict SQL.
Hello Mr. Dave,
Your articles are amazing and really very useful. This should
be done by each professional to encourage the begginners.
your work is really appreciable.
Go ahead
Thanks
sachin
Coding standards are very usefull. i like it very much. keep it up boyz.
Hi,
The articals are really very useful,keep uploading these type of DOC
Hi,
I think you should add the (NOLOCK) attribute as well.
eg:
SELECT UserID FROM [User] (NOLOCK)
or
SELECT u.UserID,s.SessionID FROM [User] u (NOLOCK) INNER JOIN [Session] s (NOLOCK) ON u.UserID=s.UserID
Jaysam
Its very good work done by you people.
I really thankful to u……..
Keep Uploading such good technical stuff. Thanks
this is very important .and very easy way to understanding
its nice
hi Pinal Dave, I just graduated with a degree in network communication and management i would like to know of any more info to help me learn the sql server to further my carrer. i am studying now for my ccna and want all the expeirence i can get to futher myself if u can help i would greatly appreciate the info to learn maybe some books you could recommend. i am egar to learn from someone who has such a vast knowledge of this field
thanks R.Haynes
Excellent Web Site.
Thank you, I really appreciate your work. I hope one day I will be able to give back too.