Agree with saidie_vs, when you have more data to delete than to keep, the best way is to create a new table, load the data you want to keep to...

Mr. Holio (7/6/2011)

---

You never worked as a DBA and looking for a junior position? In the meantime you are a MCTS and MCITP?!

How did you do that?? I have around...

Thanks for posting this article. But i think EXCEPT clause will do the trick. It is powerful and neat.

Excellent question and indeed a brain teaser!

My company has about 400 employees with 3 offices in the US and are planning to implement Work from Home policy soon. However they are going to implement a pilot...

Sorry but this is more of a question to the Networking guys and this site is for database related questions, so you might have little responses coming out to you.

Easy one 🙂

chris.stuart (4/3/2009)

---

I need to insert 800 million records (15 years worth of data) from my staging database to my final EDW database. The transform of the data in the table...

Nice question and i got it right 🙂

What do you want to become? SQL DBA or Oracle DBA?

james.morrison 19355 (6/23/2011)

---

Jeff Moden (6/23/2011)

---

james.morrison 19355 (6/22/2011)

---

Would you really put an MCM through all of that? If the person had 3 years of experience at Microsoft, would you really be...

Easy enough!

This is not going to be an easy task, you could however have a process that runs daily and compares the source and target system and then emails the comparision...

Smart technique. But beware SET ROWCOUNT is set to be deprecated in the future releases, instead you could use TOP 1.

An alternate method to remove duplicates is to use...

Didn't answer right, nevertheless learnt something new today. Great question!

Thanks,