Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – Orphaned MS DTC Transaction Information

May 14, 2008

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

Few days ago, one of our application was crashing IIS application pool because of unhandled exception. After researched we figured out the case of it was orphaned MS DTC transaction. When multiple connections are operating over one MS DTC transaction, this problem sometime shows up. As many connection are working…

SQL SERVER – Four Basic SQL Statements – SQL Operations

May 13, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, Software Development, SQL Coding Standards

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…

SQL SERVER – SQL SERVER – Comparison : Similarity and Difference #TempTable vs @TempVariable – Part 2

May 12, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Temp Table

Some questions never get old. One of them is temp table variable and temp table in SQL Server. I have previously wrote about this indepth here : SQL SERVER – Comparison : Similarity and Difference #TempTable vs @TempVariable Recently I received question: Can temporary table have indexes? If yes, are…

SQL SERVER 2005 – Microsoft Will Release SP3 Soon

May 11, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Download, SQL Service Pack

I have received quite a few inquires if Microsoft is going to release SP3 for SQL Server or not? Yes! Microsoft is going to release SP3 very soon. The exact date is not announced yet. You can read the announcement of SP3 here. Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL SERVER – Function Property – Deterministic or Non-Deterministic

May 10, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

I recently received question through email that how to determine if any user defined function is deterministic or non-deterministic? First go through two articles I have written about deterministic and non-deterministic function. SQL SERVER – Deterministic Functions and Nondeterministic Functions SQL SERVER – 2005 – Use of Non-deterministic Function in…

SQL SERVER – FIX : Error 7311 – You may receive an error message when you try to run distributed queries from a 64-bit SQL Server 2005 client to a linked 32-bit SQL Server 2000 server or to a linked SQL Server 7.0 server

May 9, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

Following email is received from SQL Server Expert Roy Cheung. He faced issue of creating and running distributed queries from a 64-bit SQL Server 2005 client to a linked 32-bit SQL Server 2000 server. He has found solution and would like to share with SQLAuthority Blog Readers. Hi Pinal, Recently,…

SQL SERVER – 2005 – Find Tables With Foreign Key Constraint in Database – Part 2

May 8, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Scripts, SQL System Table

What I love most about this blog is active readers participation. If readers are becoming contributor is the true success for any blog or online community. Recently many readers have contributed their suggestions and script to this blog. Joffery has provided nice script which is modification to previous article of…