July 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – 2008 – SCOPE_IDENTITY Bug with Multi Processor Parallel Plan and Solution

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Database, SQL Error Messages, SQL Identity, SQL Index, SQL Scripts
This article is very serious and I would like to explain this as simple as I can. SCOPE_IDENTITY() which is commonly used in place of @@Identity has bug when run in Parallel Plan. You can read my explanation of @@IDENTITY vs SCOPE_IDENTITY() vs IDENT_CURRENT in earlier article. The bug is…
Read More

SQLAuthority News – Ahmedabad User Group Meeting February 21 2009

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQLAuthority News
MVP, SQL Index, SQL User Group, SQLAuthority Author Visit
We had Ahmedabad SQL Server User Group meeting on February 21, 2009 and it was wonderful to see so many people showing up for meeting. Gradually our group is growing and more and more developers and DBA are showing up. We had two session in this meeting. From the feedback…
Read More

SQL SERVER – My Observation – Effect of Clustered Index over Nonclustered Index

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
SQL Constraint and Keys, SQL Index, SQL Scripts
Note: This article is re-write of my previous article SQL SERVER – Observation – Effect of Clustered Index over Nonclustered Index. I have received so many request that re-write it as it is little confusing. I am going to re-write this with simpler words. Query optimization is one art which…
Read More

SQL SERVER – Technical Articles – Performance Optimizations for the XML Data Type in SQL Server 2005

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
Best Practices, MVP, SQL Index, SQL XML
I always wanted to learn XML and its usage. My friend and fellow MVP Jacob Sebastian is expert in XML, so if you are interested in XML please visit his blog here. If you are interested in performance optimization for XML Data type in SQL Server following article is must…
Read More

SQL SERVER – Introduction to Force Index Query Hints – Index Hint

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
SQL Constraint and Keys, SQL Index, SQL Scripts
This article, I will start with disclaimer instead of having it at the end of article. “SQL Server query optimizer selects the best execution plan for a query, it is recommended to use query hints by experienced developers and database administrators in case of special circumstances.” When any query is…
Read More