Are there any tools out there that will check my tables (11.92) for Structural Integrity that don't take forever to run like DBCC.
Here's my problem:
Every once in awhile one of my Tables ge...
http://www.experts-exchange.com/Database/Sybase/Q_20118592.html
Zones:
SybaseDate Answered: 06/28/2002 Grade: A Views: 0
Anybody know the procedure to use DBCC corrupt, to forcibly corrupt a database table
http://www.experts-exchange.com/Database/Sybase/Q_20153816.html
Zones:
SybaseDate Answered: 07/20/2001 Grade: A Views: 0
Hi,
I have an SQL 7 server DB which I shrunk recently(using Enterprise manager not the DBCC option).I had problems with one of the tables existing outside the extent of the newly shrunk databas...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20181846.html
I have a 17GB mdf and a 400MB ldf on C: and then I have a 18GB mdf and a 13GB ldf on C:\MSSQL7\Data for the same database.
I ran DBCC SHRINKDATABASE and dump transaction database with no_log.
...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20514971.html
Why does DBCC CHECKDB automatically randomly execute? How do I change the run time from being random to a fixed time? I'm using MS SQL Server 2000. When the DBCC CHECKDB runs, the users would lock ...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20867935.html
Zones:
DatabasesDate Answered: 01/30/2004 Grade: C Views: 0
Our db server ran out of disk space causing us some problems. we've since rectified it however, now I cannot access the current activity window. It constantly times out. At first I thought we ma...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21096738.html
EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?')"
http://www.experts-exchange.com/Database/Miscellaneous/Q_21528943.html
Zones:
DatabasesDate Answered: 08/16/2005 Grade: A Views: 0
Over the last 2 days i have so many locks on our database i could not keep up with it.....thats all i did kept checking sp_who2....and sysproceses.
One of our databases did grew in size ....so i...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21912945.html
on our global web application platform we have an index defragging job that runs each sunday. We have an SP that gets fragmentation details for tables and does a DBCC INDEX DEFRAG if logical index...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22009997.html
DBCC SQLMGRSTATS: Used to produce three different values that can sometimes be useful when you want to find out how well caching is being performed on ad-hoc and prepared Transact-SQL statements.
...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22555450.html
