SQL Coding Standards « SQL Server Journey with SQL Authority

Archive for the ‘SQL Coding Standards’ Category

SQL SERVER – Stored Procedure Optimization Tips – Best Practices

Posted in Best Practices, Pinal Dave, SQL, SQL Authority, SQL Coding Standards, SQL Optimization, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Stored Procedure, SQL Tips and Tricks, SQLServer, T SQL, Technology on February 16, 2010 | 132 Comments »

We will go over how to optimize Stored Procedure with making simple changes in the code. Please note there are many more other tips, which we will cover in future articles. Include SET NOCOUNT ON statement: With every SELECT and DML statement, the SQL server returns a message that indicates the number of affected rows [...]

Read Full Post »

SQL SERVER – Questions and Answers with Database Administrators

Posted in Best Practices, Pinal Dave, SQL, SQL Authority, SQL Coding Standards, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on May 11, 2009 | 9 Comments »

I have been in India for long time now, and at present, I am managing a very large outsourcing project. Recently, we conducted few interviews since the project required more Database Administrators and Senior Developers, and I must say it was an enthralling experience for me! I got the opportunity to meet some very talented [...]

Read Full Post »

SQL Server – 2008 – Cheat Sheet – One Page PDF Download

Posted in Best Practices, Database, DBA, Pinal Dave, Software Development, SQL, SQL Add-On, SQL Authority, SQL Coding Standards, SQL Documentation, SQL Download, SQL Interview Questions and Answers, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQL Utility, T SQL, Technology, tagged SQL Cheat Sheet on October 2, 2008 | 53 Comments »

Very frequently I have been asked to create a page, post or article where in one page all the important concepts of SQL Server are covered. SQL Server 2008 is very large subject and can not be even covered 1000 of pages. In daily life of DBA there are few commands very frequently used and [...]

Read Full Post »

SQL SERVER – Guidelines and Coding Standards Complete List Download

Posted in Best Practices, Data Warehousing, Database, DBA, Pinal Dave, SQL, SQL Authority, SQL Coding Standards, SQL Constraint and Keys, SQL Cursor, SQL Data Storage, SQL Documentation, SQL Download, SQL Function, SQL Index, SQL Joins, SQL Performance, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL Stored Procedure, SQL Tips and Tricks, SQL Trigger, SQL Utility, SQLAuthority, T SQL, Technology on September 25, 2008 | 45 Comments »

SQL SERVER – Guidelines and Coding Standards complete List Download Coding standards and guidelines are very important for any developer on the path of successful career. A coding standard is a set of guidelines, rules and regulations on how to write code. Coding standards should be flexible enough or should take care of the situation [...]

Read Full Post »

SQL SERVER – Guidelines and Coding Standards Part – 2

Posted in Best Practices, Database, Pinal Dave, Software Development, SQL, SQL Authority, SQL Coding Standards, SQL Documentation, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Stored Procedure, SQL Tips and Tricks, T SQL, Technology on September 24, 2008 | 17 Comments »

To express apostrophe within a string, nest single quotes (two single quotes). Example: SET @sExample = ‘SQL”s Authority’ When working with branch conditions or complicated expressions, use parenthesis to increase readability. IF ((SELECT 1 FROM TableName WHERE 1=2) ISNULL) To mark single line as comment use (–) before statement. To mark section of code as comment [...]

Read Full Post »

Older Posts »