You need to determine possible causes of the high count... It could be you've got to much going on on the publisher/distributor (you infer that these are on the same...

Any chance you have a trigger on the table in one of the subscribers?

Yes, please review that article...and then upload your current execution plan. Just guessing, but you'll most like have a clustered index scan on T1 and T2 (unless it's a...

Tracer tokens are really just for confirming that "yes" latency is poor (or good depending on if things are running smoothly). How large is your set up (i.e. how...

What's a performance review? :hehe:

Ummm. RCSI? What's that?

I faced the same issue here at this company. Prior to coming on board here I had never used the hint, but here's it's literally in every reporting procedure...

I know this is probably a retarded way to go about it, but got it to work using this:

CREATE FUNCTION [dbo].[fx_FolderExists] (

@Folder nvarchar(500),

@Action tinyint

)

RETURNS int AS

BEGIN

DECLARE @Exists int, @ObjFile...

Thanks for the suggestions guys! I'll take a deeper look over the next day or two and see what I can come up with!

This would work, however wedging it into the current query looks like an dreadful task. For the basis of my example I used @String to parse, but in relation...

Darn. Missed that one. Had it stated "In 2014 can you run SQL Server in your existing data center and store data files for a database in the Azure...

Yes you can simply take another full backup. Full backups do not affect the LSN chain for log backups in any way (except for the very first full backup...

That works, howeve, in the unlikely event there's stuff going on in the milliseconds portion of the datetime, I would opt for >= 1st day of the month and <...

Thanks Perry. I realize it was supported, just wanted to make certain there was no "behind the scenes" issues with the rename. Appreciate the assurance!

Yes, it should, but as sqlbuddy mentioned, it could be blocked for a variety of reasons. Try extending it to 180 for testing purposes only (or zero for no...