June 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

SQL SERVER – 2008 – Location of Activity Monitor – Where is SQL Serve Activity Monitor Located

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
SQL Activity Monitor, SQL Utility
I received question from Aloke Sinha after reading my article SQL SERVER – 2008 – Activity Monitor is Empty – Fix Activity Monitor for All Users. Hello Pinalbhai, Thank you for your post about activity monitor, but I can not find activity monitor under Menu — Tools. How to activate…
Read More

SQL SERVER – 2008 – Optimize for Ad hoc Workloads – Advance Performance Optimization

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
Best Practices, SQL Scripts, SQL Stored Procedure, SQL System Table
Every batch (T-SQL, SP etc) when ran creates execution plan which is stored in system for re-use. Due to this reason large number of query plans are stored in system. However, there are plenty of plans which are only used once and have never re-used again. One time ran batch…
Read More

SQL SERVER – Practical SQL Server XML: Part One – Query Plan Cache and Cost of Operations in the Cache

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
Database, SQL Scripts, SQL Utility, SQL XML
I am very fortunate that I have friends like Michael Coles. Michael Coles is SQL Server and XML expert and have written many books on SQL Server as well XML. He has previously written book which I have reviewed on this blog SQLAuthority News – Book Review – Pro T-SQL…
Read More

SQL SERVER – Interesting Observation of ON Clause on LEFT JOIN – How ON Clause affects Resultset in LEFT JOIN

Pinal Dave
SQL, SQL Performance, SQL Puzzle, SQL Server, SQL Tips and Tricks
SQL Joins, SQL Scripts
Today I received email from Yoel from Israel. He is one smart man always bringing up interesting questions. Let us see his latest email first. Hi Pinal, I am subscribed to your blog and enjoy reading it. I have a question which has been bothering me for some time now.…
Read More