Can you give me an example of empty code block?

I tried using this trigger, it stopped the deletes on the parent table but deleted the records in the child tables.

CREATE...

Thanks. Hoping to avoid the trigger - are there any other options?

What does the execution plan show?

lol...

*crickets chirp*

Thanks Steve, John and Shrikant.

Very helpful info!

Np.

No...drill down into High Availability - then drill down into 'Availability Databases' then right click and 'suspend data...

I just had to do this after a volume failure.

No issues. I would manually stop the data transfers first.

Thanks Gail.

My understanding is that in most cases the max memory should be changed from the default.

Is this correct, and does the VM ware admin need to make changes...

Let's say this is a memory buffer issue...is there any way to force this to stay in buffer without querying the indexes..?

Are you sure it's the plan being cached that saves the time, and not the data being cached. Test with a warm data cache and the plan removed from cache,...

fixed issue - developer was using dbmail

I just noticed that allot of the fragmentation seems to be on HEAP tables.

So if I exclude the HEAP tables I still have 100 tables that have fragmentation over 20...

auto shrink if OFF

I do manually shrink the t-logs once a week due to space issues.

Okay thanks guys. I'll leave it be.

Thanks again for all the info