1) check the sql log just after startup for NUMA messages. If you don't see them then it isn't doing it I think, at least soft numa. I...

1) what is the transaction isolation level of both connections?

2) recall that dbcc inputbuffer only shows the LAST executed command - there could well be previous commands in the same...

Probably depends on what you are doing with the data after you suck it out of DB2. If you are just shoving it into a final resting spot perhaps...

the sp_spaceused issue isn't with performance it is with getting the wrong answer.

rja.carnegie (9/3/2009)

---

TheSQLGuru (9/3/2009)

---

I expect there to be lots of 'messes' out there related to MERGE and triggers. So incredibly difficult to follow some of the logic trees when both...

Guys,

How about the below queries which use only 1 table or view to get the required info.

Also the stress on the system will be reduced by using less number...

I expect there to be lots of 'messes' out there related to MERGE and triggers. So incredibly difficult to follow some of the logic trees when both are involved!

GilaMonster (9/3/2009)

---

There was a whole presentation on...

I sure wish there was more information available about NUMA and how SQL Server uses it and how it can affect performance. 🙁

Please note that there was a VERY important update to SP4 that you must apply if you use AWE.

As for connectivity problems, I recommend you get a professional...

I recommend batching up the inserts and updates so you only do some subset of the records in each transaction. This is very simple to do if you have...

check out sp_WhoIsActive, an AMAZINGLY capable sproc from Adam Machanic.

>>I just didn't want people that were going to write a script in 2k for this to even think about using a (ugh!) cursor or While Loop to get reasonably...

There can be a bad downside to COUNT(*) that has gone unmentioned: by doing a scan on something (especially the entire table if it has no non-clustered index on...

NOTE: if your IO subsystem sucks (as most I have encountered do), using 8 files for tempdb can actually result in LESS IO throughput than 1 or 2 or perhaps...