Browse by Tags

A query that references a nondeterministic user-defined function may run slower in SQL Server 2005 than in SQL Server 2000

Published 12 May 8 1:43 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications A query that references a nondeterministic...

Filed under: sql server, performance, query, kba, 2000, 2005, slow

SQL Server is waiting for an internal operation to complete, message on SQL Server Management Studio

Published 17 December 7 2:49 AM | SSQA.net

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...

Filed under: sql server, performance, microsoft, users, sql express, service pack2, management studio, slow, delay

FIX: A query that involves an outer join operation runs very slowly in Microsoft SQL Server 2005

Published 26 October 7 9:38 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...

Filed under: sql server, performance, kba, joins, slow, outer join

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 on the local server

Published 24 October 7 11:14 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications Performance is slow when you run a query...

Filed under: sql server, performance, kba, joins, slow, linked server

FIX: The query performance is slower when you run the query in SQL Server 2005 than when you run the query in SQL Server 2000

Published 22 October 7 6:13 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications FIX: The query performance is slower when...

Filed under: sql server, query, kba, slow, query performance

FIX: Performance is very slow when the same stored procedure is executed at the same time in many connections on a multiple-processor computer that is running SQL Server 2005

Published 23 August 7 6:29 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...

Filed under: sql server, performance, kba, connections, stored procedure, slow, multi-processor