Browse Site by Tags - MSMVPS.COM

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

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 user-defined function may run slower in SQL Server...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 05-12-2008
Filed under: sql server, performance, query, kba, 2000, 2005, slow

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

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 FIX: A query that involves an outer join operation...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 10-26-2007
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

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 in SQL Server 2005 that updates a table on a linked...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 10-24-2007
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

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 you run the query in SQL Server 2005 than when you...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 10-22-2007
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

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 FIX: Performance is very slow when the same stored...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 08-23-2007
Filed under: sql server, performance, kba, connections, stored procedure, slow, multi-processor