Feed on
Posts
Comments

Archive for the ‘SQL Coding Standards’ Category

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

Posted in Author Pinal, Best Practices, DBA, Database, 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 on October 2, 2008 | 8 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 Author Pinal, Best Practices, DBA, Data Warehousing, Database, 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 | 3 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 Author Pinal, Best Practices, Database, 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 | 7 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 Author Pinal, Best Practices, Database, 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 | 13 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 Author Pinal, SQL, SQL Authority, SQL Coding Standards, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged on June 13, 2008 | 2 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 - 2005 - Twelve Tips For Optimizing Sql Server 2005 Query Performance

Posted in Author Pinal, Best Practices, Database, SQL, SQL Authority, SQL Coding Standards, SQL Constraint and Keys, SQL Cursor, SQL Function, SQL Index, SQL Joins, SQL Performance, SQL Query, SQL Server, SQL Stored Procedure, SQL Tips and Tricks, SQL Trigger, T SQL, Technology on May 21, 2008 | 12 Comments »

I recently came across very nice article about optimization tips for SQL Server 2005. Here is the list of those 12 tips.
Twelve Tips For Optimizing Sql Server 2005 Query Performance
1. Turn on the execution plan, and statistics
2. Use Clustered Indexes
3. Use Indexed Views
4. Use Covering Indexes
5. Keep your clustered index small.
6. Avoid cursors
7. Archive old [...]

Read Full Post »

SQL SERVER - Four Basic SQL Statements - SQL Operations

Posted in Author Pinal, Database, SQL, SQL Authority, SQL Coding Standards, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, Software Development, T SQL, Technology on May 13, 2008 | 2 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 »

SQLAuthority News - 500th Post - An Interesting Journey with SQL Server

Posted in About Me, Author Pinal, Best Practices, DBA, Data Warehousing, Database, SQL, SQL Add-On, SQL Authority, SQL Backup and Restore, SQL Coding Standards, SQL Constraint and Keys, SQL Cursor, SQL Data Storage, 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, SQLAuthority, SQLAuthority Author Visit, SQLAuthority Book Review, SQLAuthority News, SQLAuthority Website Review, Software Development, T SQL, Technology on March 7, 2008 | 9 Comments »

I am very pleased to write my 500th post. After 500 posts, I still have same feeling when I wrote first post on this blog. I would like to thank my family for their continuous support in writing this blog. Most of all I want to thank all of YOU for being wonderful readers of [...]

Read Full Post »

SQLAuthority News - Best Articles on SQLAuthority.com

Posted in Author Pinal, DBA, Data Warehousing, Database, 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 | 2 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 Author Pinal, SQL, SQL Authority, SQL Coding Standards, SQL Function, SQL Query, SQL Server, SQL Stored Procedure, SQL Tips and Tricks, T SQL, Technology on November 3, 2007 | No Comments »

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)

Read Full Post »

SQLAuthority News - Best Downloads on SQLAuthority.com

Posted in Author Pinal, DBA, Data Warehousing, Database, SQL, SQL Authority, SQL Coding Standards, SQL Documentation, SQL Download, SQL Interview Questions and Answers, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology on November 2, 2007 | No Comments »

Best Downloads on SQLAuthority.com
SQL SERVER - Query Analyzer Shortcuts
SQL Server Interview Questions and Answers Complete List Download
SQL SERVER - Download SQL Server Management Studio Keyboard Shortcuts (SSMS Shortcuts)
SQL SERVER Database Coding Standards and Guidelines Complete List Download
SQL SERVER - Data Warehousing Interview Questions and Answers Complete List Download

Read Full Post »

SQL SERVER - Pre-Code Review Tips - Tips For Enforcing Coding Standards

Posted in Author Pinal, DBA, Database, SQL, SQL Authority, SQL Coding Standards, SQL Documentation, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on October 12, 2007 | 2 Comments »

Each organization has its own coding standards and enforcement rules. It is sometime difficult for DBAs to change code following code review, as it may affect many different layers of the application. In large organizations, many stored procedures are written and modified every day. It is smart to keep watch on all stored procedures, at [...]

Read Full Post »

SQL SERVER - 2005 - Different Types of Cache Objects

Posted in SQL, SQL Authority, SQL Coding Standards, SQL Documentation, SQL Download, SQL Error Messages, SQL Joins, SQL Performance, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL Tips and Tricks, SQLAuthority Book Review, SQLAuthority Website Review, T SQL, Technology on October 4, 2007 | No Comments »

About two months ago I reviewed book SQL Server 2005 Practical Troubleshooting: The Database Engine. Yesterday I received a request from reader, if I can write something from this book, which is not common knowledge in DBA community. I really like the idea, however I must respect the Authors copyright about this book. This book [...]

Read Full Post »

SQL SERVER - Two Connections Related Global Variables Explained - @@CONNECTIONS and @@MAX_CONNECTIONS

Posted in Author Pinal, SQL, SQL Authority, SQL Coding Standards, SQL Documentation, SQL Download, SQL Error Messages, SQL Function, SQL Joins, SQL Performance, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL Server DBCC, SQL Tips and Tricks, T SQL, Technology on September 29, 2007 | 1 Comment »

Few days ago, I was searching MSDN and I stumbled upon following two global variables. Following variables are very briefly explained in the BOL. I have taken their definition from BOL and modified BOL example to displayed both the global variable together.
@@CONNECTIONS
Returns the number of attempted connections, either successful or unsuccessful since SQL Server was [...]

Read Full Post »

SQL SERVER - 2005 - Version Information and Additional Information - Extended Stored Procedure xp_msver

Posted in Author Pinal, SQL, SQL Authority, SQL Coding Standards, SQL Cursor, SQL Documentation, SQL Download, SQL Error Messages, SQL Joins, SQL Performance, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL Server DBCC, SQL Stored Procedure, SQL Tips and Tricks, T SQL, Technology on September 22, 2007 | No Comments »

I was glad when I discovered this Extended Stored Procedure myself. I always used different syntax to retrieve server information. Many of information I was looking up using system information of the windows operating system.
Syntax:
EXEC xp_msver

ResultSet:
Index Name [...]

Read Full Post »

SQLAuthority News - Scale-Out Querying with Analysis Services Using SAN Snapshots

Posted in DBA, Data Warehousing, Database, Main, SQL, SQL Add-On, SQL Authority, SQL Coding Standards, SQL Documentation, SQL Download, SQL Error Messages, SQL Joins, SQL Performance, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL Stored Procedure, SQL Tips and Tricks, SQLAuthority Author Visit, T SQL, Technology on September 18, 2007 | No Comments »

White paper describes the use of virtual copy Storage Area Network (SAN) snapshots in a load-balanced scalable querying environment for SQL Server 2005 Analysis Services.
This architecture provides the following improvements

Improves the utilization of disk resources
Optimizes cube processing operations
Supports dedicated snapshots for specific users at different points in time

In selecting a snapshot implementation for use with [...]

Read Full Post »

SQLAuthority News - NASDAQ Uses SQL Server 2005 - Reducing Costs through Better Data Management

Posted in Author Pinal, DBA, Data Warehousing, Database, Main, SQL, SQL Add-On, SQL Authority, SQL Coding Standards, SQL Documentation, SQL Download, SQL Error Messages, SQL Joins, SQL Performance, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL Tips and Tricks, SQLAuthority Author Visit, SQLAuthority News, T SQL, Technology on September 17, 2007 | 4 Comments »

I just came across PDF published by Microsoft to promote SQL Server 2005. I find few things very interesting. I will list them here.
NASDAQ

NASDAQ, the world’s first electronic stock market replaced its aging mainframe computers with Microsoft® SQL Server™ 2005 on two 4-node clusters to support its Market Data Dissemination System (MDDS).
Every trade processed in [...]

Read Full Post »

SQLAuthority News - Scrum: Agile Software Development for Project Management

Posted in Author Pinal, DBA, Database, Main, SQL, SQL Authority, SQL Coding Standards, SQL Documentation, SQL Download, SQL Error Messages, SQL Humor, SQL Joins, SQL Performance, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL Server DBCC, SQL Stored Procedure, SQL Tips and Tricks, SQLAuthority News, Software Development, T SQL, Technology, tagged on September 12, 2007 | No Comments »

I have been working as Director of Technology in leading software industry in Las Vegas. I am responsible for Team Building and Product Management.The most important elements of Scrum are. These are presented below.
Scrum is organized around the following roles:

Product Owner - Determines what functionality is needed
ScrumMaster - Leads the Scrum and is primarily responsible [...]

Read Full Post »

SQL SERVER - 2005 - White Paper - Integrating Visio 2007 and Microsoft SQL Server 2005

Posted in About Me, Database, Main, SQL, SQL Add-On, SQL Authority, SQL Coding Standards, SQL Documentation, SQL Download, SQL Error Messages, SQL Joins, SQL Performance, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL Tips and Tricks, SQL Utility, SQLAuthority, T SQL, Technology on September 10, 2007 | No Comments »

This article focuses on integration techniques specific to Microsoft Office Visio 2007 and Microsoft SQL Server 2005. Using Visio 2007, you can connect Visio shapes to data that was generated outside Visio. A large amount of data can be captured in a SQL Analysis Services database. Being able to analyze that data in a visual [...]

Read Full Post »

SQL SERVER - 2008 - Book On-Line Link

Posted in SQL, SQL Authority, SQL Coding Standards, SQL Documentation, SQL Download, SQL Error Messages, SQL Joins, SQL Performance, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL Tips and Tricks, T SQL, Technology on August 16, 2007 | 2 Comments »

I am researching SQL Server 2008. Those who are asking me questions about SQL Server 2008, please refer following link. I will post my tutorials and articles very soon.
Here is SQL Server 2008 Book Online link.

Read Full Post »

Older Posts »