your DB server should be in a DMZ (dead mans zone/demilitarised zone) which is effectively 2 firewalls

but if you want to allow client access to your data then you could...

normally you will get a rollback transaction that puts everything back into place, but if you have for example a sql agent job with 5 steps and you kill it...

1st question  - how big is the database? just asking in case a normal snapshot might be a better option

joe - your examples didn't have a join in - they were single table selects

and I have to disagree, the reason we have Inner/outer join syntax makes code more readable...

I had this same conversation with an Nhibernate developer

he said it was just faster than writing stored procs

I asked him "would you write a c# class that exposed all of...

The trace flag can be set at the session level (add 1 line of code at the beginning of the proc).  I wouldn't set this at the server level...

you can't be 2 of the dwarfs at the same time

rather surprised that table variable are faster.

normally if the necessary indexes are added to the temp tables performance is similar if the table variable also has the...

rather surprised that table variable are faster.

normally if the necessary indexes are added to the temp tables performance is similar if the table variable also has the same indexes.

As...

this is just one scenario - you know how it is?. find the proc that is causing you issues.... find out that the guy who wrote it left 3 years...

thanks for the links guys

- afraid the option(recompile) would be a bugger to implement as it's at statement level and some of this code is maybe 7000 lines long (hence...

who needs these new fangled inner and outer join types anyway? 🙂 they are so 1992 🙂

its 28 years since that standard came into play and i cannot understand why...

does your SQL code (that you haven't posted) use a linked server? if the linked server is being service packed or gets rebooted then this will occur

other than that erland ...

nah, i know you are a big cuddly teddy bear underneath - now get back to...

I'm dealing with a crappy proc, and a crappy design, right now.

The devs did the "Code first" design.  In other words, the ORM designed the database for them.

I can't...