This level will examine the most common problems and forms of mismanagement that lead to excessive growth of the transaction log.
2012-11-26
10,239 reads
Generally, you will have no need to worry about the number of virtual log files in your transaction log. However, if you use the default settings for 'auto-grow', you can end up with such 'fragmentation' in your transaction log as to affect performance noticably. How can this be avoided? How can you tell it's a problem? What do you do about it? Greg explains.
2012-11-23 (first published: 2012-05-01)
7,126 reads
2010-08-16 (first published: 2010-03-05)
3,634 reads
Comments posted to this topic are about the Question of the Day for 07 Jan 2004 posted at http://qa.sqlservercentral.com/testcenter/qod.asp?QuestionID=155.
2004-01-11
1 reads
Thanks Jonathan. That worked great. It was just what I needed.
2003-12-08
You're not trying to install on Win 2003 Beta, or the Web Edition are you? There's issues/restrictions with them. Cheers, - Mark
2003-08-03
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-07-11
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers