Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – 2005 – Mechanisms to Ensure Integrity and Consistency of Databases – Locking and Row Versioning

March 23, 2008

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

Today I was going through Book On Line while researching something, I come across one interesting small article about two mechanisms to ensure integrity and consistency of databases – 1) Locking 2) Row Versioning Let us see their definition from Book Online Itself. Locking Each transaction requests locks of different…

SQL SERVER – 2005 – Find Highest / Most Used Stored Procedure

March 22, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Stored Procedure, SQL System Table

How many times we all DBA’s might have wonder which stored procedure is executing most in the database? I have wondered it often and I have written following small script which gives me answer to my above questions. I am also retrieving few additional data along with the highest used…

SQL SERVER – Introduction to Live Lock – What is Live Lock?

March 21, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Software Development, SQL Lock

Some questions are very interesting to answer. I just received following question in Email. What is Live Lock? A Live lock is one, where a request for exclusive lock is denied continuously because a series of overlapping shared locks keeps on interfering each other and to adapt from each other…

SQLAuthority News – Book Review – Joe Celkos SQL Puzzles and Answers, Second Edition, Second Edition

March 20, 2008

Pinal Dave

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

Database, SQLAuthority Book Review

Joe Celko’s SQL Puzzles and Answers, Second Edition, Second Edition (The Morgan Kaufmann Series in Data Management Systems) (Paperback) by Joe Celko (Author) Link to Amazon Short Review: This book is for all of them who enjoy little puzzles or just something which gives them challenge. Some puzzles took hours…

SQL SERVER – Add Column With Default Column Constraint to Table

March 19, 2008

Pinal Dave

SQL Tips and Tricks

SQL Coding Standards, SQL Constraint and Keys, SQL Scripts, SQL Server

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 achieve what was requested.

SQL SERVER – 2005 – Analysis Services Query Performance Top 10 Best Practices

March 18, 2008

Pinal Dave

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

Best Practices, Database, SQL Documentation

Analysis Services Query Performance Top 10 Best Practices Optimize cube and measure group design Define effective aggregations Use partitions Write efficient MDX Use the query engine cache efficiently Ensure flexible aggregations are available to answer queries. Tune memory usage Tune processor usage Scale up where possible Scale out when you…

SQLAuthority News – Download White Papers – Migration from MySQL, Oracle, Sybase, or Microsoft Access to Microsoft SQL Server

March 17, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Download, SQL White Papers

Note : Download White Papers by Microsoft Guide to Migrating from MySQL to SQL Server 2005 This migration guide explains the differences between the MySQL and SQL Server 2005 database platforms, and the steps necessary to convert a MySQL database to SQL Server. Guide to Migrating from Oracle to SQL…