Viewing 15 posts - 37,756 through 37,770 (of 49,566 total)
This is kinda what the beginning of the output looks like (this particular graph is 120 lines long in total)
[font="Courier New"]deadlock-list
deadlock victim=processf14c58
process-list
process id=processc8f198 taskpriority=0 logused=1120 waitresource=KEY:...
July 10, 2009 at 5:06 am
BU69 (7/10/2009)
I use trace flag 1204, doesn't 1222 give the results in xml?
1222 is not xml. It's the profiler event "Deadlock graph" that gives xml. The output of 1222...
July 10, 2009 at 3:57 am
Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. The graph will tell you, among other things,...
July 10, 2009 at 3:27 am
There is no SP4 for SQL 2005. There's an SP4 for SQL 2000, but the very latest for SQL 2005 is Service pack 3, cumulative update 4, released Jun 15...
July 10, 2009 at 3:24 am
sanderstad (7/10/2009)
The weird thing is that the logfile grows from 100MB to 45GB overnight.
There's some operation overnight that requires 45 GB or so of log space.
Rebuilding all indexes?
Doing large data...
July 10, 2009 at 12:45 am
Only after an unusual activity has grown the log beyond what is needed for normal database activity.
July 9, 2009 at 2:36 pm
Lamprey13 (7/9/2009)
Whitefang, is that you?
Don't think so. There's been no mention of "Enterprise Application" or "Entry level DBA" yet. 😀
July 9, 2009 at 2:09 pm
doug turner (7/9/2009)
After doing all that, I ran the backup with truncate_only, then the dbcc_shrink and it went down to 104K!
Now do a full backup, because you've just...
July 9, 2009 at 2:02 pm
Why do you want to shrink the log at all? You should manage the log so that the file size is adequate for the activity in your database and the...
July 9, 2009 at 1:53 pm
Juanita (7/9/2009)
I have an existing sql 2000 server that has a maintenance plan whose only step is to UPDATE STATISTICS on the OPTIMIZER tab. I also notice that all of...
July 9, 2009 at 1:27 pm
In that case, somehow you've got a half-set up transactional publication. I really wish I knew how this happened.
The fix is fairly simple. Create a transactional replication publication. Add a...
July 9, 2009 at 1:16 pm
Run sp_helppublication in the published database. In the results, the replication frequency will tell you what it is
Books Online
Type of replication frequency:
0 = Transactional
1 =...
July 9, 2009 at 12:49 pm
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic750337-145-1.aspx
July 9, 2009 at 12:18 pm
doug turner (7/9/2009)
If I remember correctly, the replication occurs once a day.
Transactional replication is constant. What kind of replication are you using?
July 9, 2009 at 12:14 pm
Wish (7/9/2009)
Does it degrade my SP's performance? Is it better to use temp table ?
Probably and maybe.
Test the proc with a table variable, see how it runs. Test the proc...
July 9, 2009 at 12:05 pm
Viewing 15 posts - 37,756 through 37,770 (of 49,566 total)