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?
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 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?
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 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...
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 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...
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 3:20 pm
I'm going to bed. Had enough for tonight (actually it's already tomorrow morning)
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 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...
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 3:11 pm
GT-897544 (2/16/2010)
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 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...
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: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
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: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...
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: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...
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: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...
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: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...
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 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.
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 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...
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 1:38 pm
Viewing 15 posts - 33,976 through 33,990 (of 49,552 total)