DDL triggers can help you...

give a close look on indexes used for your query

khushbu (5/4/2010)

---

sample data :

col1 col2

1 1

1...

Additionally you need to take care about indexes in the concerned tables

ColdCoffee (5/3/2010)

---

I dint exactly understand what you wnat to do, but as far i could comprehend from your post, here is a set of code that might interest you.

1. INSERT...

Did you notice ? this post has 9 views and still NO reply , just becoz of incomplete information.

Atleast post desired result for sample data.

sqlwars (5/4/2010)

---

My restore failed with the error: backup begins at LSN which is too recent to apply.

On checking backup history: i have the following backups taken:

Missing LSN backup 2:30...

Also the business hours matters mean are you building index in peak hours or off-peak hours, on production always go for off peak hours.

Below link contains explanation as well as workaround for your problem

http://www.developmentnow.com/g/113_2006_7_0_0_797273/Cannot-resolve-collation-conflict-for-equal-to-operation-.htm

thats great...

we can hope so

Adam Haines (5/3/2010)

---

I think it is also important to understand what is going on underneath the hood, when NULLIF is used. Unbeknownst to some, NULLIF is actually a case expression...

I dont understand why we have very few girls in database field ? , i think ROLLBACK doesnt work for them 😀

i...

you can find good article here http://www.sqlservercentral.com/search/?q=improve+query&t=a