Viewing 15 posts - 181 through 195 (of 1,583 total)
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 8, 2014 at 8:15 am
Any chance you have a trigger on the table in one of the subscribers?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 8, 2014 at 8:09 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 8, 2014 at 8:05 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 8, 2014 at 8:00 am
What's a performance review? :hehe:
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 6, 2014 at 12:47 pm
Ummm. RCSI? What's that?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 6, 2014 at 12:36 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 5, 2014 at 10:10 pm
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 5, 2014 at 11:20 am
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!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
May 20, 2014 at 11:28 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
May 19, 2014 at 10:44 pm
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 21, 2014 at 8:27 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 17, 2014 at 10:22 am
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 <...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 16, 2014 at 7:50 am
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!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 16, 2014 at 7:32 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 15, 2014 at 1:40 pm
Viewing 15 posts - 181 through 195 (of 1,583 total)