Viewing 15 posts - 121 through 135 (of 994 total)
Wherever you got that info from is incorrect - the off-row pointer size depends on the kind of inline root: SLOB, LOB, or legacy LOB: 24, 24, 16 IIRC
Edit: Read...
July 18, 2011 at 10:11 am
Syed Jahanzaib Bin hassan (6/8/2011)
June 8, 2011 at 5:48 am
I would agree that describing a cluster as active/active/active/passive can be more descriptive than saying N-1, where N=4 - depending on the audience. Both terms are in use and neither...
May 26, 2011 at 10:44 am
SanDroid (5/13/2011)
Paul Randal (5/13/2011)
May 13, 2011 at 10:50 am
Steve - I got this wrong because your wording is broken. Extents can NOT be owned by multiple objects. When an extent is a mixed extent, it is 'owned' by...
May 13, 2011 at 9:19 am
WadeN 75975 (5/6/2011)
May 6, 2011 at 8:32 am
tommyh (5/5/2011)
What the **** was Microsoft thinking here... ah thats right they wherent thinking as usual... sigh.Great question though, definatly worth knowing.
/T
There's no choice but to have it behave that...
May 6, 2011 at 8:30 am
You don't need to do that any more post SQL Server 2000 - using log backups will do it automatically for you. You might have to do 2 or 3...
March 24, 2011 at 9:51 am
The active portion of the log may be towards the end of the file.
Do a couple of log backups and it should kick the active portion around to the front...
March 24, 2011 at 9:29 am
It's your IO subsystem, without a shadow of a doubt.
Errors are moving around because the IO subsystem is corrupting different parts of the various files.
You need to move off that...
March 23, 2011 at 6:57 pm
Google is your friend. I blogged about this error here CHECKDB bug that people are hitting - Msg 8967, Level 16, State 216 almost 3 years ago.
March 7, 2011 at 12:03 pm
You're not going to be able to repair this - that log file is now toast.
Here's what I would try (follow these instructions at your own risk):
1) shutdown the server
2)...
February 9, 2011 at 12:17 pm
That's a known issue that can occur sometimes with non-IN_ROW_DATA allocation units. Your workaround is the only solution I know of.
February 8, 2011 at 1:52 pm
Viewing 15 posts - 121 through 135 (of 994 total)