Jeff,

Love your point about keeping your finger on the pulse. A colleague and I take regular smoke breaks which we have dubbed "IT meetings" because no matter what, that's...

Most of my vices are personal, some are professional. The most notable ones are 1) beer 2) cigarettes 3) reactionary behavior at times and 4) desire for perfection. ...

I was wondering if that was the case (regarding the heap table).

Thanks so much for the responses!

Nate

Hi All,

Got a response from Red Gate which I included below since it's got some decent info in it. As for my particular case, it turned out the 3rd...

Hi All,

We just recently started using Red Gate SQL Backup. I'm still getting used to the features but one thing I'm finding is that the restore from Transaction Log...

Makes sense, thanks!

Gail,

This did the trick nicely, thank you. However, I'm seeing that my processors are tracking extremely high now. Any idea why this would be happening?

Thanks,

Nate

Okay sounds good. Is there a way to specify what the FKs reference explicitly?

Query 1:

DF_NAMES_UPDATE_DATEDEFAULT_CONSTRAINT

PK__NAMES__NAMEID PRIMARY_KEY_CONSTRAINT

NAMES ...

sp_helpindex:

index_name index_description

_dta_index_NAMES_6_1110295015__K1_K4_2nonclustered located on PRIMARY

_dta_index_NAMES_8_1110295015__K1_2nonclustered, hypothetical located on PRIMARY

_dta_index_NAMES_8_1110295015__K1_6nonclustered, hypothetical located on PRIMARY

_dta_index_NAMES_8_1110295015__K1_K2nonclustered, hypothetical located on PRIMARY

_dta_index_NAMES_8_1110295015__K1_K2_3_4_5_6_7nonclustered, hypothetical located on PRIMARY

_dta_index_NAMES_8_1110295015__K1_K3nonclustered, hypothetical located on PRIMARY

_dta_index_NAMES_8_1110295015__K1_K4nonclustered, hypothetical located...

Gail, the quick response is much appreciated. Also, nice presentation at PASS 2008.

The primary key is actually non-clustered, and I'm trying to delete a clustered index that's on...

Hi All,

This is something that has interested me as well. When I set the Agent to automatically remove job logs older than 7 days and click 'okay,' everything appears...

Thank you Pam and Gail, this was helpful.