Thanks for provide that script..

Thanks for provide that Link. HyperV best pratices.

1. PAE x86 system can applicable on host operating system and it allows using more than 4GB.

2. PAE x86 virtual system can not...

one more help.. as per attached SQLDumper log, is it missing patch level on SP3? Pls. confirm

current version

Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (Intel X86) Sep 22...

Thank you so much for your help.. I have done successfully all the action.

DBCC CHECKDB ([Honeywell.MES.LimitRepository.DataModel.LRModel]) WITH NO_INFOMSGS, ALL_ERRORMSGS;

Command(s) completed successfully.

yes, immediate i will recreate constraint. drop and recreate it will take 2 0r 3 min times.

due to constraint not able to delete that index.

First drop that Uniqe key constraint and then it will allow drop that index..

Pls. confirm if drop constaint key if any impact...

Thank you, I found some blocking SPID and killed them, after that drop and create the new index..

But another one index not able to drop

Msg 3723, Level 16, State...

I could not drop that index, ..

TITLE: Microsoft SQL Server Management Studio

------------------------------

Drop failed for Index 'IX_OperatingLimitHighValues_EffectiveTime'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.4000.0+((KJ_PCU_Main).120628-0827+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+Index&LinkId=20476

------------------------------

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL...

I tried as below command but not clear that errors

ALTER INDEX [IX_OperatingLimitHighValues_EffectiveTime] ON

[Honeywell.MES.LimitRepository.DataModel.LRModel].[dbo].[OperatingLimitHighValues]

REBUILD WITH (SORT_IN_TEMPDB = ON, ONLINE = OFF)

go

ALTER INDEX [PK_OperatingLimitHighValues] ON

[Honeywell.MES.LimitRepository.DataModel.LRModel].[dbo].[OperatingLimitHighValues]

REBUILD WITH (SORT_IN_TEMPDB = ON, ONLINE = OFF)

go

ALTER...

DBCC CHECKDB ([DBName]) WITH NO_INFOMSGS, ALL_ERRORMSGS;

Msg 8952, Level 16, State 1, Line 1

Table error: table 'OperatingLimitHighValues' (ID 741577680). Index row in index 'uc_OperatingLimitHighValues_uid1' (ID 2) does not match any data...

I have checked DBCC CHECKDB ('DBNAME') WITH DATA_PURITY, it was reported huge currption

CHECKDB found 0 allocation errors and 104 consistency errors in database

Msg 8952, Level 16, State 1, Line...

There is only one Instance.

Yes. I am talking about Primary Key constraint., Not for...

Let me explain the table defination

Table TBL_UploadData_TRAN

Data_ID - column is primary key already defined, but constraint is not added in that PK column. I verified no other columns does...

Hi MyDoggieJessie, thank you for giving such a wonderfull information for finding potential index already exists in database. Mr.Brent Ozar's, sp_BlitzIndex - it is very useful for find idex issues.

Aggressive...