Scripting out the publications, deleting and recreating them and the subscriptions worked for us.

You need to start by identifying in what parts of the code the deadlocks happen, and start analyzing why they happen.

Here is a good resource for a start:

[/url]

You can also...

Generally speaking, Itzik Ben-Gan's books are the best you can find out there. He has a few of them that are worth reading. Some of the materials overlap, but there...

Hi Rod,

The Code Snippets directory doesn't replace the projects directory. It holds custom code snippets you can develop for common routines you do every day.

For example, I run a query...

Hi,

Basically, the parallel plan is chosen if its cost is lower than the cost of the serial plan.

The thing is the parallel plan's cost is calculated a little different, so...

Brilliant!

Here's another good link for completion:

http://msdn.microsoft.com/en-us/library/ff878716.aspx

Thank you Steve

I'm not sure what you mean when you say "ideal", but the default is 600 and most of the times it is left that way.

About the 3 sessions, do they...

Hi,

The timeout is not for the amount of time a client is connected.

The remote query timeout kills a running query if the timeout is passed.

If the query is finished on...

Hi Steve,

Have you solved the issue?

.

Hi,

Is intellisense enabled?

If it is, can you try to disable it and see if the problem persists?

Hi,

SQL Server supports (only) range partitioning.

Nevertheless, I wouldn't suggest doing it without understanding well the capabilities and overhead related to it.

I'd start with the following article:

http://msdn.microsoft.com/en-us/library/ms190787.aspx

Hi Tom,

Generally I think the process you outlined is good, but you will want to leverage bulk operations, and you have a few options for it.

I suggest you have a...