GilaMonster (8/13/2008)

---

Desert camel rides in Mauritius? Dubai, I could see, but Mauritius is a small tropical island. The...

It's possible that the issue is related to the fact that this version of the driver returns a default field length of zero (unlimited) for Varchar(MAX) which I think you'd...

Sunderland AFC footy chant - the club's ex striker, current chairman and all round good egg Niall Quinn's song

http://en.wikipedia.org/wiki/Niall_Quinn

http://www.youtube.com/watch?v=SsX12TVJD3Y

But, there's even a way around that (and many similar problems not listed) without an explicit cursor or While loop OR UDF using a single set-based update to solve...

Jeremy Brown (8/12/2008)

---

Simply put, there's too much legacy code and legacy mindfame out there. Marketing disaster. I'd prefer some optimizer enhancements that detect cursor calls and decide on a set-based...

Do they have desert in Mauritious?

Once in v7 where I was doing some rather complex statistical work and the cursor was faster. Other than that quick and dirty DBA type rubbish looping through stuff...

Oh - and dawn quad bike runs through the desert have to be done if you get the chance

Adam Zacks (8/12/2008)

---

andrew gothard (8/11/2008)

---

Ummm well yes, I suppose... Depends what mood I'm in. Getting married next...

Well - usually in QA once it's written. Prototype in MS - then you get that sinking feeling when a colleague comes up to you baffled that someone normally...

Hi Krish,

have a look at SSIS - very easy to do it using that

Personally - since 6.5, I've been waiting for the ability to write a view, and then, when I open it...

Hi - forgive me if I'm missing the point of what you're trying to do, but here's my understanding;

Basically - what you're wanting to do is have a login tied...

Was thinking of this one

http://sqlinthewild.co.za/index.php/2008/07/23/recovery-model-and-transaction-logs/

Think we all know how often people seem to get parachuted into 'looking after the database(s)' and over the years I've seen a pretty large number...

On temp tables being used insanely: Yeah! I recently ran into a query that used twenty-one temp tables and six cursors. I changed the whole thing into a...