-
as seen on Server Fault
- Search for 'Server Fault'
Hi all,
When running stored procedures in MSSQL Server, I found it failed and the DBMS (MSSQL Server 2005 Dev Edition) notified that some indexes are corrupted.
Please advice me, here below is DBCC logs:
DBCC results for 'itopup_dev'.
Service Broker Msg 9675, State 1: Message Types analyzed: 14…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a SQL Server 2000 database. When I run the following command
select * from sysindexkeys
This display the appropriate records.
I then do a DBCC command for the sysindexkeys. It doesn't display anything. Strange there is no page having the sysindexkeys records. Then how the query display…
>>> More
-
as seen on SQL Server Central
- Search for 'SQL Server Central'
Returning author Wayne Sheffield recently had some database corruption - read about how it was fixed.
>>> More
-
as seen on SQL Blogcasts
- Search for 'SQL Blogcasts'
Before I post anything I just want to clarify what I mean by RAID 10 , this is sets of mirrored pairs that have been striped as against a RAID 0 which has been mirrored. I've just had a disk failure in the data array for one of my dev servers, it's an eight disk raid 8, no real worries, replace…
>>> More
-
as seen on SQL Authority
- Search for 'SQL Authority'
First of all – if you are going to say this is very old subject, I agree this is very (very) old subject. I believe in earlier time we used to have this only option to monitor Log Space. As new version of SQL Server released we all equipped with DMV, Performance Counters, Extended Events and…
>>> More
