Viewing 15 posts - 36,526 through 36,540 (of 49,562 total)
Generally corruption is an IO subsystem problem. If you're having repeated corruption, I'd take a long, hard look at the drives/SAN that the server uses. Have a look in the...
September 9, 2009 at 9:01 am
GSquared (9/8/2009)
jcrawf02 (9/8/2009)
It's a shame they're not doing this with a laden swallow...Yes, but African swallows are non-migratory.
They are? Or is that a Monty Python reference?
September 9, 2009 at 8:49 am
GilaMonster (9/8/2009)
Only in South Africa - http://pigeonrace2009.co.za/pigeon-race-2009My money's on the pigeon.
The pigeon won. By a significant amount. The download was 4% complete by the time the pigeon arrived
September 9, 2009 at 8:44 am
Florian Reischl (9/7/2009)
September 8, 2009 at 10:13 am
I'm in a silly mood right now, so...
Silverfox (9/8/2009)
how do you clone a report server
Start with a bounty hunter and a water-covered planet.
when do you use a cursor
As seldom as...
September 8, 2009 at 9:58 am
jimmycjen (9/8/2009)
I noticed that when the server is rebooted, it automatically runs DBCC CHECKDB. Is there a place I can disable it?
It's not running CheckDB. All SQL's doing is adding...
September 8, 2009 at 9:57 am
Might be worth putting a trace in place, from the time you know the table is 0% fragmentation to when it's really high. See exactly what's happening to it.
September 8, 2009 at 8:16 am
TheSQLGuru (9/8/2009)
2) As the plan gets big, the number of permutations (and the CPU effort and duration it takes to calculate them all) grows . . . hmm, is...
September 8, 2009 at 8:14 am
PiMané (9/8/2009)
Doesn't CREATE DATABASE FOR ATTACH_REBUILD_LOG do the job in SQL Server 2005 or 2008?
Yes, if the database was shut down cleanly. For the cases where is wasn't, the DB...
September 8, 2009 at 7:28 am
Paul White (9/8/2009)
I thought you were asking what to do if you received the DBCC message after restoring the database from the backups."
You know, I've had that once, and not...
September 8, 2009 at 6:36 am
MrT-SQL (9/8/2009)
In answer to your question Gail, no it is not turned on. Sorry for the delay in getting back to you.
Is there a shrink job? A shrink operation...
September 8, 2009 at 5:41 am
That technique is valid on SQL 2000 only. It cannot be done on 2005 or 2008 since the system tables are not updatable any longer and sysdatabases is not a...
September 8, 2009 at 5:20 am
Viewing 15 posts - 36,526 through 36,540 (of 49,562 total)