That's it, something like

ALTER TABLE UserProfileInfoDetails DROP CONSTRAINT fk_Country

Then

ALTER TABLE UserProfileInfoDetails ADD CONSTRAINT fk_Country

...

Just use the "NOT FOR REPLICATION" clause when you create the constraints.

Try this:-

select reqno, v.empno, deptno, fromdate, vac_days

from vacation v

inner join (select empno, sum(vac_days) as vacdays

...

I'm surprised that the performance is poor just firing the trigger.

What is the "clause" you have put in the trigger to recognize the stored procedure... is this clause causing the...

You are checking for the existence of the column in the [Promotion] table, and then inserting into the [PromotionSchedule] table... is that correct?

If your update query decides to scan the whole table, then it's not going to take any longer with or without the complex criteria.

The difference in the time is due...

Steve,

Just think of the transaction log backups as being independent of the full log backups.

As long as you have an unbroken "chain" of these, any full backup taken somewhere...

If you have one database per survey, you'll have a lot of fun trying to produce any consolidated reports...

I hope you aren't wrong Mr Irish!!

Take the following backup sequence:-

Full Backup 1

Txn Log Backup 1

Txn Log Backup 2

Txn Log Backup 3

Full Backup 2

Txn Log Backup 4

Txn Log Backup 5

Txn...

select db_name()

I'm sure someone will come up with a more elegant solution, but this should work (where @s-2 is the string you're looking to extract from)

select reverse(substring(reverse(@s),0,charindex('|',reverse(@s))))

Ummm... What's your question?

I know every case is different, but deleting 20,000 doesnt sound as though it should be taking anything like 5 minutes.

A few thoughts:-

Assuming you are doing a DELETE... WHERE..., are...

I also did a lot of interviewing recently for experienced DBA's, and gave each candidate the same list of 20 questions. Just as in Grant's post, these were simple e.g....

I assume your columns are tab delimited, and each line is CR delimited. If so you had /t instead of \t), and had an additional space after the /t:, same...