Feeds:
Posts
Comments

Archive for the ‘SQL Coding Standards’ Category

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 | 8 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, DBA, Database, Pinal Dave, 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, Software Development, T SQL, Technology, tagged on October 2, 2008 | 22 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, DBA, Data Warehousing, Database, 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 | 9 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 where [...]

Read Full Post »

SQL SERVER – Guidelines and Coding Standards Part – 2

Posted in Best Practices, Database, Pinal Dave, SQL, SQL Authority, SQL Coding Standards, SQL Documentation, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Stored Procedure, SQL Tips and Tricks, Software Development, T SQL, Technology on September 24, 2008 | 10 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 use (/*…*/).

Avoid the [...]

Read Full Post »

SQL SERVER – Guidelines and Coding Standards Part – 1

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

Use “Pascal” notation for SQL server Objects Like Tables, Views, Stored Procedures. Also tables and views should have ending “s”.
Example:
UserDetails
Emails

If you have big subset of table group than it makes sense to give prefix for this table group. Prefix should be separated by _.
Example:
Page_ UserDetails
Page_ Emails

Use following naming convention for Stored [...]

Read Full Post »

SQL SERVER – 2008 – Introduction to Policy Management – Enforcing Rules on SQL Server

Posted in Pinal Dave, SQL, SQL Authority, SQL Coding Standards, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged on June 13, 2008 | 3 Comments »

I have previous written article about SQL SERVER Database Coding Standards and Guidelines Complete List Download. I just received question from one of the blog reader is there any way we can just prevent violation of company policy. Well Policy Management can come into handy in this scenario.
If our company policy is to create all [...]

Read Full Post »

SQL SERVER – Four Basic SQL Statements – SQL Operations

Posted in Database, Pinal Dave, SQL, SQL Authority, SQL Coding Standards, SQL Query, SQL Server, SQL Tips and Tricks, Software Development, T SQL, Technology on May 13, 2008 | 4 Comments »

There are four basic SQL Operations or SQL Statements.
SELECT – This statement selects data from database tables.
UPDATE – This statement updates existing data into database tables.
INSERT – This statement inserts new data into database tables.
DELETE – This statement deletes existing data from database tables.
If you want complete syntax for this four basic statement, please download [...]

Read Full Post »

SQL SERVER – Add Column With Default Column Constraint to Table

Posted in Pinal Dave, SQL, SQL Authority, SQL Coding Standards, SQL Constraint and Keys, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on March 19, 2008 | 8 Comments »

Just a day ago while working with database Jr. Developer asked me question how to add column along with column constraint. He also wanted to specify the name of the constraint. The newly added column should not allow NULL value. He requested my help as he thought he might have to write many lines to [...]

Read Full Post »

SQLAuthority News – Best Articles on SQLAuthority.com

Posted in DBA, Data Warehousing, Database, Pinal Dave, SQL, SQL Add-On, SQL Authority, SQL Backup and Restore, SQL Coding Standards, SQL Constraint and Keys, SQL Cursor, SQL DateTime, SQL Documentation, SQL Download, SQL Error Messages, SQL Function, SQL Humor, SQL Index, SQL Interview Questions and Answers, SQL Joins, SQL Performance, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL Server DBCC, SQL Stored Procedure, SQL Tips and Tricks, SQL Trigger, SQL Utility, Software Development, T SQL, Technology on November 4, 2007 | 5 Comments »

SQL SERVER – Cursor to Kill All Process in Database
SQL SERVER – Find Stored Procedure Related to Table in Database – Search in All Stored procedure
SQL SERVER – Shrinking Truncate Log File – Log Full
SQL SERVER – Simple Example of Cursor
SQL SERVER – UDF – Function to Convert Text String to Title Case – Proper [...]

Read Full Post »

SQLAuthority News – Best SQLAuthority Articles on Other Popular Sites

Posted in Pinal Dave, SQL, SQL Authority, SQL Coding Standards, SQL Function, SQL Query, SQL Server, SQL Stored Procedure, SQL Tips and Tricks, SQLAuthority Website Review, T SQL, Technology on November 3, 2007 | Leave a Comment »

Best SQLAuthority Articles on Other Popular Sites
SQL SERVER – UDF vs. Stored Procedures and Having vs. WHERE (SQL Server Magazine)
SQL SERVER – Pre-Code Review Tips – Tips For Enforcing Coding Standards (dotnetslackers.com)
Reference : Pinal Dave (http://blog.SQLAuthority.com)

Read Full Post »

Older Posts »