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

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

A common scenario in SQL Server environment that often application users complained about slow performance and same time you observe high CPU usage/spikes on the SQL Server instance, so better to follow the methods from HighCPU-whyitis blog and still you have not seen no sign of resolution to the problem, go down this blog. Back to basics, ...

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 X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Enterprise EditionNotification Contents: New and All Modifications FIX: A query that has many outer joins takes a long time to compile in SQL Server ...

This is a typical error you would get when a SSIS package is executed that involves remote server connectivity. Basically on the error note it will clearly identified as a network related issue. Similar issue happened at our end whereas the SSIS package uses an application is using the SqlClient provider that will write big datachunks to ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Enterprise X64 EditionNotification Contents: New and All Modifications FIX: A memory leak occurs when you call the Initialize method and the Terminate method of the ...

Here comes another Frequently Asked Question (FAQ) on the forums and Frequently Posted Blog (FPB) here about high cpu issues on the SQL Server 2000 instances. Looking at high cpu spiks and performace issues is a common problem in all SQL Server installations, handling this issue within SQL Server 2005 is not a problem as there are DMVs to extend ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Standard EditionNotification Contents: New and All Modifications FIX: The merge agent does not use a specified custom user update to handle conflicting UPDATE statements in SQL Server 2005http://support.microsoft.com/kb/913494/en-US

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise EditionNotification Contents: New and All Modifications FIX: The performance of a query that performs an insert operation or an update operation is much ...