Viewing 15 posts - 43,126 through 43,140 (of 49,566 total)
CTM?
The most recent version of SP3 is RC0 (Release Candidate 0)
November 14, 2008 at 12:46 am
You're going to have to ask someone who knows sharepoint well.
November 13, 2008 at 1:45 pm
This one?
deadlock victim=processe3dc48
pagelock fileid=1 pageid=534789 dbid=5 objectname=LVTS.dbo.allocations id=lock1d81d0c0 mode=SIU associatedObjectId=72057596482748416
owner-list
owner...
November 13, 2008 at 1:24 pm
It's the sharepoint search database. It indexes all content in the sharepoint sites.
November 13, 2008 at 1:07 pm
Mike (11/13/2008)
Is there a way to give the DB a max size so that it doesn't keep eating up my space on my server?
Yes, but if you do and...
November 13, 2008 at 12:46 pm
Muralidharan Venkatraman (11/13/2008)
Is there like a standard script which can go over the tables and make that decision?
None that I've ever seen. While it's possible to tell currently what columns...
November 13, 2008 at 12:41 pm
Swirl80 (11/13/2008)
November 13, 2008 at 12:09 pm
Swirl80 (11/13/2008)
but i was on the understanding that if i restored the database and all tlogs (incl the tail) then i'd just be restoring the database in the corrupt state.
Only...
November 13, 2008 at 12:06 pm
Swirl80 (11/13/2008)
November 13, 2008 at 11:38 am
Swirl80 (11/13/2008)
Can anyone confirm whether if a table becomes corrupt, will this be replicated to the DR boxes?
No. What's shipped to the failover are the log backups. Corruption is typicaly...
November 13, 2008 at 11:14 am
davidm (11/13/2008)
As for backing up to disk--I agree with that method--now I need to sell it to the IT Manager.
Shouldn't be too hard. Point out to him that at...
November 13, 2008 at 10:01 am
Loner (11/13/2008)
I plan to put the log file and tempdb both on the same disk with RAID 10.
Not a good idea if there's a lot of TempDB activity.
How busy...
November 13, 2008 at 9:58 am
jcrawf02 (11/13/2008)
now that I've read this thread, gotta go fix something . . .
😀 :hehe:
November 13, 2008 at 9:53 am
Every database should have this on in SQL 2000. In 2005 it's been replaced by page checksums which should be used instead.
It's a way for SQL to detect that a...
November 13, 2008 at 9:40 am
http://sqlinthewild.co.za/index.php/2008/11/04/what-are-statistics-and-why-do-we-need-them/
You can't change the frequency. The % of changes that kicks off a stats update is hardcoded. You can update stats manually using UPDATE STATISTICS.
November 13, 2008 at 9:36 am
Viewing 15 posts - 43,126 through 43,140 (of 49,566 total)