March « 2009 « SQL Server Journey with SQL Authority

Archive for March, 2009

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

Posted in Database, Pinal Dave, SQL, SQL Authority, SQL Error Messages, SQL Index, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged Identity, SQL Bug, SQL OUTPUT clause on March 24, 2009 | 19 Comments »

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 listed here in connect site [...]

Read Full Post »

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

Posted in Pinal Dave, Readers Question, SQL, SQL Add-On, SQL Authority, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, SQL Utility, T SQL, Technology, tagged SQL Activity Monitor on March 23, 2009 | 2 Comments »

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 it? [Other unrelated information removed] [...]

Read Full Post »

SQL SERVER – 2008 – Activity Monitor is Empty – Fix Activity Monitor for All Users

Posted in Pinal Dave, Readers Contribution, SQL, SQL Authority, SQL Error Messages, SQL Performance, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged SQL Activity Monitor on March 22, 2009 | 5 Comments »

This article is outcome of the technical discussion of activity monitor and its behavior with my friend and SQL Expert Tejas Shah. Tejas told me that he does not like to re-write content from MSDN but rather prefer to write real life scenarios, as that prepares him to become better SQL Expert. While discussing about [...]

Read Full Post »

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

Posted in Best Practices, Pinal Dave, SQL, SQL Authority, SQL Optimization, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Stored Procedure, SQL System Table, SQL Tips and Tricks, T SQL, Technology on March 21, 2009 | 21 Comments »

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 plans wastes memory and resources. [...]

Read Full Post »

SQL SERVER – AWE (Address Windowing Extensions) Explained in Simple Words

Posted in Best Practices, Database, Pinal Dave, SQL, SQL Add-On, SQL Authority, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged SQL Memory on March 20, 2009 | 2 Comments »

I was asked question by Jr. DBA that “What is AWE?”. For those who do know what is AWE or where is it located, it can be found at SQL Server Level properties. AWE is properly explained in BOL so we will just have our simple explanation. Address Windowing Extensions API is commonly known as [...]

Read Full Post »

« Newer Posts - Older Posts »