Viewing 15 posts - 33,976 through 33,990 (of 49,552 total)
Why? I'm sure you're just as capable as I am of opening visual studio and looking at the tabs.
What's the point of all of these 'trivial pursuit' type questions?
February 17, 2010 at 6:21 am
234 MB with only 400 rows? Sure it's not 234 kb? How many pages does the index (not the table) have?
February 17, 2010 at 6:20 am
There are a number of things that can cause a stored proc's plan to be dropped from cache. Stats updates, index rebuilds, table alterations, etc. Be very careful relying on...
February 16, 2010 at 3:24 pm
The model DB is essential for SQL's operation, it's used to recreate tempDB. SQL cannot start without the model DB.
Check Books online, I'm sure there's something in there about restoring...
February 16, 2010 at 3:20 pm
I'm going to bed. Had enough for tonight (actually it's already tomorrow morning)
February 16, 2010 at 3:15 pm
Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in their nature.
Shrinking causes massive fragmentation and will just result in the...
February 16, 2010 at 3:11 pm
GT-897544 (2/16/2010)
February 16, 2010 at 3:03 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...
February 16, 2010 at 2:32 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic866336-150-1.aspx
February 16, 2010 at 2:27 pm
GT-897544 (2/16/2010)
And by dbcc I mean with “DBCC CHECKTABLE” REPAIR_REBUILD. If that did not complete successful after two or three times I would then use “REPAIR_ALLOW_DATA_LOSS” option.
Oh for crying out...
February 16, 2010 at 2:26 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...
February 16, 2010 at 2:18 pm
GT-897544 (2/16/2010)
Please try to change your DB to Emergency mode and see if you can extract data or not using import export wizard.
No! Extract data is NOT the first choice...
February 16, 2010 at 2:04 pm
GT-897544 (2/16/2010)
Bru Medishetty (2/16/2010)
GilaMonster (2/16/2010)
GT-897544 (2/16/2010)
Extract all the objects using SSIS package, to be in safe side.
Do you have the vaguest idea what you're talking about here?
A suspect database...
February 16, 2010 at 1:53 pm
I'm getting quite sick and tired of people posting answers to corruption/suspect DB questions when it's obvious they don't have a blithering clue what they're talking about.
February 16, 2010 at 1:52 pm
GT-897544 (2/16/2010)
Extract all the objects using SSIS package, to be in safe side.
Do you have the vaguest idea what you're talking about here?
A suspect database is not online (that's...
February 16, 2010 at 1:38 pm
Viewing 15 posts - 33,976 through 33,990 (of 49,552 total)