Viewing 15 posts - 43,111 through 43,125 (of 49,552 total)
Not offhand.
Do you need to see it? I know it's interesting from an academic point, but from what I can see of this one and the previous graph, there's more...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 14, 2008 at 12:50 am
CTM?
The most recent version of SP3 is RC0 (Release Candidate 0)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 14, 2008 at 12:46 am
You're going to have to ask someone who knows sharepoint well.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 13, 2008 at 1:24 pm
It's the sharepoint search database. It indexes all content in the sharepoint sites.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 13, 2008 at 12:41 pm
Swirl80 (11/13/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 13, 2008 at 12:06 pm
Swirl80 (11/13/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 13, 2008 at 9:58 am
jcrawf02 (11/13/2008)
now that I've read this thread, gotta go fix something . . .
😀 :hehe:
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 13, 2008 at 9:40 am
Viewing 15 posts - 43,111 through 43,125 (of 49,552 total)