February 16, 2010 at 2:10 pm
Time to go for a walk behind the wood shed? :w00t:
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
February 16, 2010 at 2:11 pm
Alvin Ramard (2/16/2010)
CirquedeSQLeil (2/16/2010)
Lynn Pettis (2/16/2010)
How about a different rant. Don't you get tired of answers that really don't help?Gail just responded to the suspect thread. Awesome 😀
Should we recommend running a "level 3 diagnostic"? 😀
I am going to recommend DBCC Timewarp
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 16, 2010 at 2:13 pm
He is insistent on the data extraction.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 16, 2010 at 2:18 pm
Lynn Pettis (2/16/2010)
Okay, Gail is in rare form here. Or should I say, I'm glad I'm not the one who is on her bad side today.
I'm not angry with him (not yet anyway, though if he keeps on...) He just doesn't seem to get the hint.
http://www.sqlservercentral.com/Forums/FindPost865778.aspx Fragmented indexes is the reason the mdf doesn't shrink when data's deleted.
http://www.sqlservercentral.com/Forums/FindPost865647.aspx Manual statistics updates are not necessary on SQL 2005/2008
http://www.sqlservercentral.com/Forums/FindPost864972.aspx and http://www.sqlservercentral.com/Forums/FindPost864952.aspx Make sure that you backup TempDB's log file
http://www.sqlservercentral.com/Forums/FindPost863718.aspx Diff backups take the same size and time as full backups
http://www.sqlservercentral.com/Forums/FindPost863580.aspx Database backups can make TempDB log fill the drive, even if you restrict the size of the log file. Don't forget to backup TempDB's log
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
February 16, 2010 at 2:20 pm
And then he recommends a DBCC with REPAIR_ALLOW_DATA_LOSS. Only as a completely last resort, say I discovered that my backups were corrupt (or worse, never done).
February 16, 2010 at 2:21 pm
CirquedeSQLeil (2/16/2010)
Chad Crawford (2/16/2010)
RBarryYoung (2/16/2010)
Just knowing that I am helping someone is what makes it all worthwhile.(if that doesn't make sense, then note closely the dates & times in the thread above, and at the one he links to... :angry:)
I think the time on the MSDN Server is off or it doesn't know what timezone I'm in, which comes out to be about the same. I watched a thread that was "Last Reply 23 hours 49 minutes ago" and when it ticked over to 24 hours it changed to Monday, February 15, 2010 8:28 PM. It's 1:30 PM here, so the date on MSDN is off by 7 hours for me. His original post on MSDN was at 5:37 PM, which would be 10:37 AM for me and your first reply to his thread was at 10:45. So I think yes, he was posting multiple places, but I think he might have posted out there just a few minutes before being able to see your reply.
Chad
I think both run off UTC Time. I think that is about right for the Mountain Time Zone (diff of 7 hours).
Correct. Mountain is currently UTC-7.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 16, 2010 at 2:23 pm
One of the things we're seeing is the fact that so many people lack troubleshooting skills. They don't know how to find out what's wrong so they quickly jump to trying to figure out which solution is most likely to help, or, maybe even worse, which solution can be implemented the fastest.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
February 16, 2010 at 2:29 pm
Alvin Ramard (2/16/2010)
One of the things we're seeing is the fact that so many people lack troubleshooting skills. They don't know how to find out what's wrong so they quickly jump to trying to figure out which solution is most likely to help, or, maybe even worse, which solution can be implemented the fastest.
Or which one is most likely to cause the most harm.
I just tried Googling "suspect database", just to see what came up. The first several hits aren't comprehensive, but they all suggest checking the error log as a first/early step.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 16, 2010 at 2:32 pm
Lynn Pettis (2/16/2010)
And then he recommends a DBCC with REPAIR_ALLOW_DATA_LOSS. Only as a completely last resort, say I discovered that my backups were corrupt (or worse, never done).
That's exactly what it it. That's generally referred to as "Emergency mode repair" A repair with allow data loss when the DB's in emergency mode. Last resort as, if it fails, there's nothing that can be done and you must resort to extracting what data you 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
February 16, 2010 at 2:33 pm
Ok - it is now real interesting. Referencing Paul Randal's blog on corrupt databases. I think that thread is turning for the south.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 16, 2010 at 2:33 pm
I'm waiting for him to respond to my last comment.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
February 16, 2010 at 2:34 pm
CirquedeSQLeil (2/16/2010)
Ok - it is now real interesting. Referencing Paul Randal's blog on corrupt databases. I think that thread is turning for the south.
it's coming my way? :w00t:
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
February 16, 2010 at 2:39 pm
Now Gail's got an Interview question from the poster.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
February 16, 2010 at 2:42 pm
FYI, we still have not heard anything from the OP.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
February 16, 2010 at 2:44 pm
Alvin Ramard (2/16/2010)
CirquedeSQLeil (2/16/2010)
Ok - it is now real interesting. Referencing Paul Randal's blog on corrupt databases. I think that thread is turning for the south.it's coming my way? :w00t:
I guess that depends where you are in relation to the thread. 😛
Viewing 15 posts - 11,476 through 11,490 (of 66,749 total)
You must be logged in to reply to this topic. Login to reply