SqlServer-QA.net

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard EditionNotification Contents: New and Major Modifications A query that references a nondeterministic user-defined function may run slower in SQL Server 2005 than in SQL Server ...

Interesting popup message on the down-right corner of my laptop when I'm performing SQL Server tasks against a 2005 version database using SQL Server Management Studio (SSMS), displays the message ''Microsoft SQL Server Management Studio is waiting for an internal operation to complete. If you regularly encounter this delay ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition& SQL Server 2005 Enterprise X64 EditionNotification Contents: New and Major Modifications FIX: A query that involves an outer join operation runs very slowly in Microsoft SQL Server ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard EditionNotification Contents: New and Major Modifications Performance is slow when you run a query in SQL Server 2005 that updates a table on a linked server and then joins the table to a table ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 EditionNotification Contents: New and Major Modifications FIX: Performance is very slow when the same stored procedure is executed at the same time in many ...

http://sqlserver-qa.net/blogs/tools/pages/why-my-database-performance-after-an-upgrade-is-so-slow.aspx

This is a common question for a DBA who have been the path of Upgrade from previous version of SQL server to 2005 version, there are many reasons associated and main one is nothing but bad-code or poorly optimized code. Here are list of things you need to go through:  Upgrade to SQL Server 2005 on same the hardware can perform slower than ...