Viewing 15 posts - 41,056 through 41,070 (of 49,571 total)
kladibeeto (2/16/2009)
Conclusion:If You DON'T perform transactional log backup's
You need to do this:
Execute:
BACKUP LOG DatabaseName with truncate_only
DBCC SHRINKFILE (FILENAME, 1000)
Set recovery model to simple.
If you aren't doing log...
February 16, 2009 at 8:09 am
DBADave (2/14/2009)
CXPackets occur when a query has its operations run in parallel, but not all operations complete at the same time.
Not all threads processing a single query operator...
February 16, 2009 at 8:06 am
Jack Corbett (2/16/2009)
I just hope I never have to reference it to fix any of my DB's. 😀
I hope so too. This is an article that I would like...
February 16, 2009 at 8:00 am
kladibeeto (2/16/2009)
Please explain me which log chain will he break if he don't work transactional log backups?
Please read the article that ALZDBA linked to above. It's explained in there.
February 16, 2009 at 7:58 am
Before you try shrinking, you need to work out why it grew in the first place. Otherwise it may well grow again and cause bigger problems.
February 14, 2009 at 5:12 am
Mirroring is autofailover only. When the server that was the principal comes back online, it will become the mirror. If you want it to become the principal again, you'll have...
February 14, 2009 at 5:01 am
Simple recovery has no effect on what's written to a DB's log. Just how long it's retained after it's written.
February 14, 2009 at 4:37 am
Please don't cross post.
No replies to this thread please. Replies to:http://www.sqlservercentral.com/Forums/Topic657055-360-1.aspx
February 14, 2009 at 4:36 am
Please post the exact error that you're getting and the query that generates it.
February 14, 2009 at 4:35 am
DBADave (2/13/2009)
February 14, 2009 at 4:07 am
jeff_wiegand (2/13/2009)
While I understand there are design issues often at the root of SQL apps when they don't scale, Read Committed Snapshot Isolation seems like a slam dunk.
It's...
February 14, 2009 at 4:00 am
Ninja's_RGR'us (2/13/2009)
exec sp_update_resumeexec sp_distribute_resume
:hehe:
February 14, 2009 at 3:50 am
Ken, one other thing that came to mind yesterday.
When a query can get either a good plan or a bad depending where and when it's called, it can be due...
February 14, 2009 at 3:49 am
Lots of parallelism skew. Lower MaxDop
February 13, 2009 at 8:51 am
Brandie Tarvin (2/13/2009)
February 13, 2009 at 8:49 am
Viewing 15 posts - 41,056 through 41,070 (of 49,571 total)