My user group meeting review for Ahmedabad on March 21, 2009: how Profiler works and how to find the most popular and longest running queries.
SQL SERVER – 2008 – SCOPE_IDENTITY Bug with Multi Processor Parallel Plan and Solution
SCOPE_IDENTITY can return a wrong value when a query uses a parallel plan on a multi processor server. Run it on one processor or, better, use the OUTPUT clause.
SQL SERVER – 2008 – Location of Activity Monitor – Where is SQL Serve Activity Monitor Located
Can’t find the location of Activity Monitor in SQL Server 2008? It’s not under Tools. Open it from the Standard toolbar or by right clicking the server node.
SQL SERVER – 2008 – Activity Monitor is Empty – Fix Activity Monitor for All Users
In SQL Server 2008, Activity Monitor is empty for a user without the right permissions. Here is how to fix Activity Monitor for all users.
SQL SERVER – 2008 – Optimize for Ad hoc Workloads – Advance Performance Optimization
One time ad hoc plans waste plan cache memory. See how the SQL Server 2008 option optimize for ad hoc workloads keeps them from filling up the cache.
SQL SERVER – AWE (Address Windowing Extensions) Explained in Simple Words
What is AWE? Address Windowing Extensions let 32 bit SQL Server use very large amounts of physical memory. Here it is explained in simple words.
SQLAuthority News – 900th Article – 9 Best Practices – Important Milestones
Today is my 900th article on this blog. You can see list of all the 900 articles here. I suggest you go over the list and read any article you like.