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...

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...

Using sys.columns cause it should have more than 50 rows. My test DB, I get estimated rows 1, actual 460. That cardinality inaccuracy is what really causes problems with...

Um - you Gail. Hope the suggestion's taken in the way it was meant ...... just thought it was nice and to the point

I'm not saying never use them - hey over the last decade I've even used cursors 3 or 4 times :w00t:. But in general - I find derived tables...

Hi,

in all honesty, I'm puzzled as to why your boss is demanding you use Temp Tables. Personally, I'd consider these a last resort other than the...

Ever thought of expanding that slightly and submitting as an article on here? Seen soooo many posts on forums and usenet where people just fail to grasp the issues...

Andras Belokosztolszki (8/11/2008)

Umm - surely that's our job?