OK, it's good that you understand the implications.

My experience with replication is limited, and therefore so is my advice! I think that you need to be monitoring what is going...

Sounds like a join. But without knowing more about the data and table structure, it's difficult to help any more than that.

Yes it matters. Put it before the statements you want it to apply to. It applies to all of the statements which follow it in the proc, unless you issue...

Here is a detailed article on the topic: http://rusanu.com/2010/03/26/using-tables-as-queues/

Can't see an easy way of fixing that. Seems that the Excel code does not allow you to specify the delimiter and instead picks whatever you have in Regional Settings.

The...

I think you've been a forum member long enough to know that "it didn't work" doesn't cut it as a technical reply.

Change the delimiter from a comma to a pipe to avoid that issue.

Use square brackets:

CREATE USER [DT-SERVICES-TEST] WITHOUT LOGIN;

As Jonathan AC Roberts mentioned, this is difficult without knowing more....

OK, what I was angling towards is this: can your process be re-engineered to process all currently unprocessed rows in the queue, rather than picking them off one by one?

Do you execute one or more procs for every row hitting the queue?

It might be helpful if you would elaborate on the 'performance issues'. Are we talking CPU, disk access, locking/concurrency, parallelism ...?

What makes you think that the cursor is causing the...

The query you have provided contains both a subquery and a ranking function, so I don't understand what you are asking for.

Alternatives are described by Adi Cohn. An SSIS solution sounds plausible.

• This reply was modified 4 years, 3 months ago by Phil Parkin. Reason: Fix typo

There is no easy way. As far as I know, it is not possible to select which objects should be restored from a SQL backup.

You can, of course, restore the...