Yip, I remember a while back having to look into a situation where transactional replication was causing some performance issues exacerbated by the server being used for some production processing....

An update would be quicker checking @@rowcount. Ultimately, 2 io's to insert a record vs. 3 to check first also doesn't sound like a bad deal. Regardless, my questions were...

Np, that's a busy set-up that you have there, have you considered (don't let your eyes glaze over) replication or some sort of pipe to a sub-repository that'll manage the...

Like the way you're thinking Rob, but @@RowCount isn't that resource intensive and it's probably set regardless whether you query it or not.

Could always do a dirty read (NOLOCK) for...

Indeed, someone offer this man a M&M (or is that a M - singular). The Scripting.FileSystemObject object will allow you to check the size property: http://msdn.microsoft.com/en-us/library/2d66skaf(VS.85).aspx

I agree with your comments Karma, just as buying a car, the responsibility is your own.

Without getting philosophical though, a lot of our reality is constructed for us and...

Hi Steve, belated congrats on your windfall.

I've been following the debate from a distance this time but considering you did request responses...

I appreciate that you are trying to appear "Master-in-Chief" of...

Hi Ramesh

Each character has it's own charater code whether the language is in en or es. There's no automatic translation between the characters, SQL Server isn't a translation engine.

What I suggest is to create...

I don't know why, but I kept on expecting the simpsons sound track to kick in during that story Steve. Did you check your pockets?

Sounds like you could definately do with a quick hop around the block L.

Now that's a tough one. I'm ambiguous when the head hunters come calling, they are generally interested in what you can offer their client not visa-versa and can give the impression of...

Absolutely right, but what I have noticed about the 10'er away from the desk is that it isn't a substitute for living in harmony. How many reach that state with themselves and...

no results Patrick...

until then, I'd recommend that you do one join at a time starting from

SELECT * FROM LeagueLevels LL