bteraberry (6/30/2010)

---

PaulB-TheOneAndOnly (6/30/2010)

---

Gopal Rathore (6/30/2010)

---

Is this will be a good database design because it will make joins faster but again I will have to compromise with finding formulaId in Detail...

On DTS Export wizard, once you have selected the source SQL Server tables click on "Transform" then select "Delete rows on destination". This has to be done for each table.

1- Share a directory on remote server

2- On primary server map...

Glad to help.

Gopal Rathore (6/30/2010)

---

Is this will be a good database design because it will make joins faster but again I will have to compromise with finding formulaId in Detail table as...

Were all 108 databases set to full recovery model?

I'm in agreement with Gianluca.

Having said that - as a rule of thumbs - I generally favor functions when the piece of code is expected to be reused and can...

stewartc-708166 (6/30/2010)

---

Partitioning should not be used on moderate sized transactional tables.

It works best for the archiving of huge datasets (hundred million plus records) that are not interrogated on a regular...

Yes.

1 - Do not use delete, use truncate - much faster.

2 - Drop constraints / Truncate / Load...

I wouldn't call them "customers" but "victims".

I'm tempted to say: "just ask everybody for her/his SSN and use it as PK" but I'll behave well and I'll refrain for saying...

Larry Kruse (6/29/2010)

---

Paul - Thanks for your feedback. I reviewed the article which mostly discusses the MAXDOP settings. While it certainly provides something interesting to consider regarding parallelism,...

MyLocalTable is the local, pre-created, empty SQL...

Shall we understand Data Warehouse core tables are being truncated and fully reloaded in a daily basis?

rkpuhan (6/9/2010)

---

My insert statement is like below.

insert into test@SQLTEST (name, fullname)

values ('Oracle', 'Oracle server data');

Test is the SQL server table name and sqltest is the db link name.

If I am...

Gopal Rathore (6/25/2010)

---

Which is better to have either Numeric Candidate Key or Composite Key in the dependent table to make joins faster to execute say for example I have FormulaId...