Viewing 15 posts - 39,076 through 39,090 (of 49,552 total)
Luke L (5/15/2009)
We will walk in dark places no others will enter??
If you're talking about my sig, it's part of the Ranger oath from Babylon 5. Considering the really questionable...
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
May 15, 2009 at 12:59 pm
Gaby Abed (5/15/2009)
Weren't the capitals split to separate the three branches?
They are, with Cape Town and Bloemfontein the other two, but if one speaks about the capital city of the...
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
May 15, 2009 at 10:10 am
GSquared (5/15/2009)
So... that means you commute from Thailand to SA every day on the back of an elephant?? That must be rough. 🙂
Hehehe. With times and distances it would...
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
May 15, 2009 at 10:07 am
GSquared (5/15/2009)
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
May 15, 2009 at 9:12 am
GSquared (5/15/2009)
Gail: Check out the second story on this page[/url]. You'll get a chuckle out of it.
Hehe. That's not an uncommon comment. I showed someone a photo of...
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
May 15, 2009 at 8:38 am
I'm not going to try and explain all the errors, but it looks like at least 3 extents (at different places in the file) have been trashed. This is usually...
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
May 15, 2009 at 8:20 am
Grant Fritchey (5/15/2009)
GSquared (5/15/2009)
I'm here (most of the time).DUDE! I've visited that place before. How cool is that?
And the continent visible is where I live, or more specifically, here
Not great...
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
May 15, 2009 at 7:55 am
BigSam (5/15/2009)
The current database design has Simple recovery model
Isn't that a risk? If anything fails, you'll be losing everything back to the last full/diff backup.
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
May 15, 2009 at 7:30 am
I asked a few questions earlier that haven't been answered.
There's no where near enough info to tell you anything useful. Furthermore, this isn't the kind of thing that you...
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
May 15, 2009 at 7:12 am
Shukla (5/15/2009)
That continously users will be working on my application so as and when database gets corrupted i should be able to repair it immediately.
Users don't cause database corruption. This...
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
May 15, 2009 at 7:09 am
Jan Van der Eecken (5/15/2009)
But ever since we have the two dogs it has been calm.
I live in a block of flats, so dogs aren't an option
Anyhow Gail, I can...
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
May 15, 2009 at 3:10 am
Take a look at this article. http://www.sqlservercentral.com/articles/65804/
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
May 15, 2009 at 3:00 am
Christopher Stobbs (5/15/2009)
When you say that a Clustered index is included in every non-clustered index, what do you mean by this?
The clustering key is the row's identifier. Hence it is...
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
May 15, 2009 at 2:56 am
Depends what's wrong
Please run this and post the full results:
DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS
Do you have a clean backup?
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
May 15, 2009 at 2:55 am
Ahhh!!!! Damn it! Twice this year!
Flat broken into again last night. Among other things, took the zune that I bought to replace the ipod that they stole last bloody time.
As...
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
May 15, 2009 at 2:53 am
Viewing 15 posts - 39,076 through 39,090 (of 49,552 total)