SQL Performance Archives - Page 84 of 100 - SQL Authority with Pinal Dave

SQL SERVER – Guidelines and Coding Standards Part – 2

September 24, 2008

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Best Practices, Database, Software Development, SQL Coding Standards, SQL Scripts, SQL Stored Procedure

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 a single line as comment use (–) before the statement.…

SQL SERVER – Guidelines and Coding Standards Part – 1

September 23, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Best Practices, Database, Software Development, SQL Coding Standards, SQL Constraint and Keys, SQL Index, SQL Joins, SQL Scripts, SQL Stored Procedure

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_…

SQLAuthority Author Visit – Ahmedabad SQL Server User Group Meeting – September 2008

September 22, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, DBA, MVP, SQL Download, SQL Humor, SQL User Group, SQLAuthority Author Visit

On September 20, 2008 was one of the best day so far for Ahmedabad SQL Server User Group Meeting. We had two very interesting sessions by two SQL Server MVPs. SQL Server MVP Jacob Sebastian had began the meeting with very interesting introduction note. Along with many news Usergroup President…

SQL SERVER – Explanation about Usage of Unique Index and Unique Constraint

September 7, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Database, DBA, SQL Index

I enjoy reading questions from blog readers and answering them. One of the another SQL enthusiastic is Imran who also regularly answer questions of users on this community blog. Recently he has answered in detail about when to use Unique Index and when to use Unique Constraint. Cristiano asked following…

SQL SERVER – 2008 – Introduction to Table-Valued Parameters with Example

August 31, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Stored Procedure, SQL Utility

Table-Valued Parameters is a new feature introduced in SQL SERVER 2008. In earlier versions of SQL SERVER it is not possible to pass a table variable in stored procedure as a parameter, but now in SQL SERVER 2008 we can use Table-Valued Parameter to send multiple rows of data to…

SQL SERVER – Behind the Scene of SQL Server Activity of – Transaction Log – Shrinking Log

August 21, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Scripts, SQL Server DBCC, SQL Server Security, SQL Stored Procedure

Imran Mohammed continues to help community of SQL Server with his very enthusiastic writing and deep understanding of SQL Server architecture. Let us read what Imran has to say about how Transaction Log works and Shrinking of Log works. Question from lauraV Please help me understand. I am taking a…

SQLAuthority News – Microsoft SQL Server Management Pack for Microsoft Operations Manager 2005

August 21, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Download, SQL Server Security

Note: Download Microsoft Operations Manager 2005 by Microsoft The Microsoft SQL Server Management Pack provides both proactive and reactive monitoring of SQL Server 2008, 2005 and SQL Server 2000 in an enterprise environment. Availability and configuration monitoring, performance data collection, and default thresholds are built for enterprise-level monitoring. Both local…