Thanks Gila

Hi,

Did you tried DBCC CHECKTable with Repair_rebuild?

Regards

Moosa

Hi Bodsda ,

Hope you have the backup already. Please try with DBCC CHECKDB with repair_allow_data_loss. Hope this will help to resolve.

Regards

Moosa

Hi miguelxsc,

The SQL Server 2005 some time through this error, but i don't know why it is coming. However the database will attach successfully, even though it showed that...

Could you please run DBCC CHECKDB and see is there any error on the report?

Hi Kevin,

Thanks for your guidance, Let me hard code the query and see how the query plan is coming up. I have one more quick question here. I knew that...

1) you say you "got what you expected" after partitioning. what exactly was that?

We had slowness in one module which user pull the data and load in a grid, which...

MS completely screwed up the table partition in SQL 2005. If you see the query plan which i attached. It is going on nested loop to find the partition and...

Hi Gila,

I am having a few questions here. Could you please describe why we need to include these columns on the index.

1. Will the include columns on the index...

Hi Gila,

I am having a few questions here. Could you please describe why we need to include these columns on the index.

1. Will the include columns on the index...

Sorry for the confusion. In a datbase, i need to find what are all the master tables and what are the transactional tables.

WOW.. Now the query ran for 0 MS from 16 sec.

Gail thanks for your help. The index really helped..

Regards

Moosa

Hi Gila,

Thanks for your reply, I have attached the execution plan, Table and index script for your reference. For your informaiton i have used nolock because it is an dataware...

Gila,

Wow Awesome, THe script ran for 0 ms from 16 sec. Thank you so much. The index really helped.

Regards

Moosa

FYI, i have created a non clustered index on cotractkey table skip the table scan.

Dan i will change the query to BETWEEN clause instead of >= & <= that...