create indexes on all the join fields and make sure they are of integer data type.

Yes use the virtual IP

From another machine can you try to connect from Query Editor using the virtual IP?

Also check out these docs and articles on how to setup...

Nita Reddy (4/15/2008)

---

I want to know what is the difference On Hearbeat.

I have nodeA (active) heartbeat IP address is 192.188.1.11

In NodeB the (passive) heartbeat IP address is 192.188.1.12

Do I need...

double check if you have a linked server named ODBDCP.

GSquared (4/15/2008)

---

If you can't normalize it, and can't modify the code, because the system is in production, then even if you could add a default constraint to the table to...

GSquared (4/15/2008)

---

Are these two columns in a larger table that has more columns with other data, or is this a table with just these two columns and five rows?

In the...

Thanks for input everyone

I used:

if update (columnname) or update(columnname) or update (columnname)

begin

--sql statements

end

and it worked

ksullivan (3/24/2008)

---

Why are you disabling your employee table triggers? Won't that make it possible for records to be added & updated that never get your idm table? Are you trying...

I'm disabling triggers because if i don't they will keep firing indefinitely since both tables IDM and Employees contain triggers which update each other. But the IDM trigger only updates...

Thanks John

I will look into partitioning tables.

Michael Valentine Jones (1/29/2008)

---

Even if your data files are on different arrays, the backup speed will also be limited by the speed that it can write the backup file. ...

Michael i appologize for a double post, the site was very slow yesterday and i didn't realize that...

Can you connect from the same server to the sql server from SSMS?

Jason

This can be easily done with SSIS.

Just use

Transfer Database Task with

Transfer Jobs Task and

Transfer Logins Task

you can't prevent creation of temp files.

you can install all of sql on D and that should be fine as long as you create logs and data files on the...