Jargons – GDR and QFE release?

Another quick one for the day – for a frequent query – what is the difference between GDR, QFE and other release terms. For all such queries I redirect my customers to http://support.microsoft.com/kb/935897 – a nice article on Incremental Servicing Model (ISM). ·         GDRs (General distribution release) are new means of providing support. GDR fixes are reserved…

2

Stored procedure vs. SQL Query

One of the common questions that I face while reviewing the applications at customer site is if SQL Server caches and reuses the plan then where is the difference in stored procedure vs. SQL Query. There is no single answer; recommend to read Batch Compilation, Recompilation, and Plan Caching Issues in SQL Server 2005  as…

1

SQL Server Standard Edition to Enterprise Edition

Another common query – How can I upgrade from SQL Server Standard Edition to Enterprise Edition Use the following command to upgrade to a different edition of SQL 2005. Go to Command prompt “start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=<Instance Name> UPGRADE=SQL_Engine SKUUPGRADE=1” For complete details on command line based install refer to http://msdn2.microsoft.com/en-us/library/ms144259.aspx Quick Note 1.      …

1

Windows 2003 SP2 and Performance gains for SQL Server 2005

Faced a question couple of time “What are the performance gains in Win 2003 SP2 for SQL Server 2005 as mentioned in: http://www.microsoft.com/technet/windowsserver/sp2/faq.mspx“ 2 important performance areas that I know of: ·         Optimization done for Dispatch locks (refer to http://download.microsoft.com/download/e/b/a/eba1050f-a31d-436b-9281-92cdfeae4b45/synch_table.doc for more details) Timer processing done on CPU #0 have significant performance impact on enterprise…


Must read for SQL Guys

As a consultant I face a common question where can I find useful whitepapers and reading material on SQL Server 2005. A simple cross reference approach –   Troubleshooting Performance Problems in SQL Server 2005 Physical Database Storage Design Online Indexing Operations in SQL Server 2005 ·         Next Buzzing word for Database experts – MDM…


A must for DBA: SQL Server 2005 Performance Dashboard

Microsoft recently released a free download – SQL Server 2005 Performance Dashboard reports.  Joint effort of SQL support and SQL development teams to help field with performance issues identification with focus on resolving the problem.  The dashboard reports are light (as compared to other tools like SQL Profiler and PSSDiag) as they rely uses SQL…

1

To apply SQL Server 2005 SP2 or not?

A common question from customers; should we apply SP2 or wait. There is no Golden answer; I would suggest: a.      Test the application in testing / staging environment first b.      Compare the performance against baseline c.       Refer to wonderful blog article from SQL PSS team – that explains the details about the re-release of SQL Server…