Perry Whittle (5/6/2014)

I'm assuming you mean AlwaysOn availability group?

What are the current backup settings you have defined for...

Thanks Lowell for the reply.

I am looking for procedures calling multiple same procedure inside.

Thanks Gail & Lynn..

Thanks Everyone for the Reply.

Free_mascot : Do you have any template for tracking this using extended events?

Thanks Gail.

We already have a case with MS and they provided some HotFix months back but our server is still generating dump file.

Thanks a lot for your help.

Thanks Gail,

I know the below is not corruption but that is what i got from error log.

Timeout occurred while waiting for latch: class 'FCB_REPLICA', id 00000000C0AB3630, type 2, Task 0x000000002A2634C8...

Thanks a lot Gail.

We had an issue here were our database got corrupted ,senior dba's are pointing that it was due to running CHECKTABLE. What you think.

Got below message from...

Thanks a lot Gail.

And when we rebuild the index it will defrag all the level and reorg on the leaf level right ie the last one..

Thanks a ton Adi..

This is what i was looking..

The table is have 150 million records and is around 1TB in size. I think still the index usage depends on the...

Thanks Grant...

You are definitely giving confidence..

Thanks Grant.

I didnt find an option in that query to specify the index names .

eg:

1.A

2.B

3.C

4.PK_ASSETID

5.ix_customer

6.ix_assetid

7.ix_placeid........

Thanks Gail..

I think the space used by non-unique non-clustered index is on higher side when compare to unique non-clustered index 111 vs 107.

Thanks Jessie.

Is there any issue if i create a new table with new name and create all indexes and move data ,any problem if i rename the DB afterwards,any issue...

Is there any difference if i load the data using SELECT * INTO and using an SSIS package to load??

Thanks Jessie. We have tried all the way and its taking time.

Tried loading data to a new table with new structure failed because we ran out of space.