bitbucket - thanks for getting back - but you were right about your assumption of being not right -

I was looking to see if someone knew of a way...

ok now that things are returning to normal do we think ISNULL performing better than COALESCE for checking a single operand is no co-incidence?

Truly appreciate it Jeff .....

ok ok ..... spare me the barrage, smart, sweet people ..... you were right .... 1st and 2nd were quicker than 3rd and in fact 1st was quicker than...

alrite ... first thanks for 'all the guidance' ....

second .. while i admit to being a little lazy, I do not have access to the database itself that this...

ok gila now that confuses me ... let me ask this another way - would you even consider Cross apply as a performance alternative to inner join

Thanks much!

Leon

Thanks for straightening me out .... although I understand from the ODBC documentation, that even with the sp_prepare code, we could do a multi-row-insert by forming an array that could...

Gila,

I agree .... although the point I was trying to make was, when set to run Bulk inserts, it is performing well, telling me that SQL does not have a...

I would agree ... although I would take it a little further and say the problem is with the ODBC (more than with the app - Informatica) .... because when...

T_IBNR_INFO_RTC (6.1 million rows) has a non-clustered index on Sequence_no and TRSPL_RCC (6.9 million rows) has no indexes.

Thanks Gila!

Here are the actual queries for this one session I am seeing run now -

¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢

Insert Query

¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢¢

The application is executing a series of sp_executes with values for one row...

i should have that soon

We have perfmon running for 3 hours; thrice a day. Sampling once every 75 seconds. Is that a bad thing?

I will get the schema and queries ... although I am...

Do you find it interesting that when I switch on the /3GB option, the dm_os_wait_stats states "ASYNC_NETWORK_IO" is the item seeing the largest wait?

Also now, the Log file drive (primary...