Viewing 15 posts - 271 through 285 (of 994 total)
Yes, that's what I said two replies further up in the thread...
January 12, 2010 at 9:43 am
They had to have something else going on, or they're confused by nomenclature - snapshot just can't get bigger than the database - once all pages from the database are...
January 11, 2010 at 2:31 pm
It's not - it can't get any bigger than the size of the database at the time the snapshot was created. The only time the snapshot can be bigger than...
January 11, 2010 at 1:35 pm
I guess you could interpret the semantics of the article prose either way - at best it's ambiguous.
Snapshots are one of the features I liked the most when I helped...
January 7, 2010 at 11:32 pm
Here's my blog post which explains how this works and how transaction rollbacks do NOT cause pages to be copied into the database snapshot.
Thanks
January 7, 2010 at 3:22 pm
This is kind of obvious. A rollback of a transaction is a logical operation which generates more changes to the database - there's no concept of simply undoing a transaction's...
January 7, 2010 at 9:55 am
CHECKDB's not going to fix this. What's weird is that it looks like the text blobs for all sysindexes rows have been lost - did something nasty happen to this...
January 6, 2010 at 11:15 am
Well, you've hit a bug somewhere in the server - very hard to tell where though without having a debugger attached to it.
A 'kept' page is one that has a...
December 22, 2009 at 8:50 am
Which build of 2005 are you on?
Have you used any of the following recently in the database: online index operations, MARS, DML triggers? These all use versioning under the covers...
December 21, 2009 at 8:39 am
See CHECKDB From Every Angle: How long will CHECKDB take to run? and CHECKDB From Every Angle: Consistency Checking Options for a VLDB.
Seems like you're missing an 'h' from Thanx...
December 15, 2009 at 7:52 am
You don't want to turn it on unless you're *not* covered by page checksums already. It's going to vastly slow down reads while it does the extra auditing.
No problem if...
December 12, 2009 at 7:55 am
Thought this would make a good blog post: see What can cause log reads and other transaction log questions
December 9, 2009 at 6:34 pm
Yes - it's entirely feasible. How much transaction log do you generate in a day? How big is each log backup? The total log backups for a day should roughly...
December 9, 2009 at 3:32 pm
Not sure of Trace will trace system-issued rollbacks or not. Engineer a full transaction log with a long running transaction and you can check it out.
You can look for rollbacks...
December 9, 2009 at 2:47 pm
Viewing 15 posts - 271 through 285 (of 994 total)