Viewing 15 posts - 45,046 through 45,060 (of 49,571 total)
K. Brian Kelley (8/14/2008)
It's expected that our time there be used to bring back knowledge for the whole team's benefit. Since I had my laptop with me, I basically...
August 14, 2008 at 3:23 pm
Perhaps in between the delete batches restart the log reader, let it process the deleted rows, then backup the log, disable the log reader, delete, repeat.
It's a lot of script...
August 14, 2008 at 3:07 pm
Larry Johnson (8/14/2008)
Thanks for your feedback!I get a little frustrated when someone asks for money to attend a conference, and all the bloggers can talk about are silly things.
I...
August 14, 2008 at 2:56 pm
Jeff Moden (8/14/2008)
Oh hell no! 🙂 I'm not a "systems" type of DBA
:hehe: Me neither
Thanks again for the help... I may have to make...
August 14, 2008 at 2:42 pm
rbarryyoung (8/14/2008)
Now, now, be nice to the OP, Gail. 😀
I thought I was being nice 😉
August 14, 2008 at 2:31 pm
Jeff Moden (8/14/2008)
Aw crap! They've scheduled a job for every blood Log Reader Agent!!! I'm going to need to disable those buggers, too, huh?
It should, if I recall correctly,...
August 14, 2008 at 2:19 pm
Jeff Moden (8/14/2008)
Aw crap! They've scheduled a job for every blood Log Reader Agent!!! I'm going to need to disable those buggers, too, huh?
That's done by default when replication...
August 14, 2008 at 2:14 pm
Jeff Moden (8/14/2008)
79 not including the MS-4... appears that they have created 1 Log Reader Agent for every customer database... two of which are active constantly... the two each...
August 14, 2008 at 2:12 pm
I think I haven't explained clear enough.
fn_trace_getinfo shows you the active traces that SQL knows about. It just shows traceID, status (stopped, paused, running) and file location that the trace...
August 14, 2008 at 2:10 pm
GSquared (8/14/2008)
Nope. Didn't know about that option. MS Tech Support apparently didn't either
LOL.
The same file needs to be changes when running SSIS on a cluster. SSIS isn't...
August 14, 2008 at 2:06 pm
Pretty much, although you can interrogate SQL as to the traces that are running.
select * from fn_trace_getinfo(0)
Get profiler to generate the trace creation code for you. It's easier than...
August 14, 2008 at 1:55 pm
Jeff Moden (8/14/2008)
August 14, 2008 at 1:52 pm
David Branscome (8/14/2008)
DBCC UpdateUsage shrink file sp_updatestats Index RebuildImplementing these maintenance options will improve performance.
The shrink file certainly won't.
The update stats is...
August 14, 2008 at 1:46 pm
Server-side trace is only to a file. Tracing to a table isn't recommended even from profiler GUI because it has the highest impact on the traced server of all of...
August 14, 2008 at 1:40 pm
KATHLEEN Y ZHANG (8/14/2008)
August 14, 2008 at 1:13 pm
Viewing 15 posts - 45,046 through 45,060 (of 49,571 total)