one of the sp's had 22 table variables some of them could contain a few hundred rows. The thing only MS could explain is what the engine does. ...

keep telling 3rd party that, it's like some kind of company standard one person did it so now everyone has to use them. What is amazing I can run...

Thanks figured as much, nothing replaces experience

Will look more interested in IO times. Same database same sp_configure settings, indexes and stats rebuilt on both server. Only difference is one is older vmware server at...

probably should have mentioned this is all physical

kind of leaning that way, this is a point of new return migration with about 36 hours to get every piece done, as soon as we take the first node...

yes it is on a physical box

my bad

thats what was used, made no difference, I have actually seen several examples of this inside other stored procedures. even removed index statement from the table variable and...

actually she is right about the indexes however it does not look the the engine uses them correctly. I had a table variable with 200 rows an and index,...

this was for a warehouse load, it is clear and from what i have heard that if you have lots of records in the table variable joins to large tables...

Have all the license and we have SA for upgrade so that part we are OK on

market for dba's too good to put up with this. Dont let technology ruin your life. We are paid well but when you figure out the person delivering...

goal is to go to always on and dump log shipping. Money is kind of an issue, i will get one new box out of this. Really need...

to clarify

Currently setup

One SQL Server 2008r2 active passive cluster running on windows 2008r2

This cluster also does log shipping to two other sql server 2008r2 on windows 2008

One of these...