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

SQL SERVER – 2008 – Find If Index is Being Used in Database

October 3, 2008

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

It is very often I get query that how to find if any index is being used in database or not. If any database has many indexes and not all indexes are used it can adversely affect performance. If number of index is higher it reduces the INSERT / UPDATE…

SQL SERVER – Guidelines and Coding Standards Part – 2

September 24, 2008

Pinal Dave

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…