I must admit I was wrong on this one....

USE tempdb

GO

CREATE TABLE dbo.Accounts

(

ID int IDENTITY(1,1) PRIMARY KEY CLUSTERED,

TransactionDate datetime,

Balance float

)

go

DECLARE @i as INT

set @i = 0

while @i < 1000000

begin

insert into...

A thread is never dead on the internet....

also I'd rather welcome him to the stie and congratulate him for his first post ;).

Ya but the subcriptions are pointless for guys like me... are even much less addict. I have over 10 000 forum subscriptions. There's no easy way to...

Try running that on a 1M rows table then tell us how long it takes to run... assuming your query is done before xmas!!!

Have you actually looked at books online to see what might be causing all those errors... no offense but a simple F1 hit could get you almost all those answers...

My bad about the reorg / reindex thing, I was thinking about another script... this scripts runs in about 2H15 every night... the first time I used it, the log...

Not really, but it doesn't matter since any one can use google to find this thread again, so any new info is still usefull to post!

I think you can do that... here's something you can try and test out for yourself (and let us know if it works).

Create a new filegroup.

Move the table to that...

Looks like I can bid higher... so I'll move my rates up to 175$ / hour,do the maths for me : That'll be cheaper that way!

I've had weirder requests than this... sometimes the user wants the data if and only if a certain amount of days has been taken into account.

But I agree... that looks...

Great I'll be the first to put a bid on this... 80 hours @ 95$ / hour >>> that'll be 7600$ to check up on this. Plus whatever flight,...

Yup that's the one!

Thanks for the clarifications!

I meant this by quirky update :

Update table set @var = UpdatedColumn = @var + WhateverIttakesToEvalutateThisVariable

This must be used with a index hint on a temp table to be...

Hugo, are you talking about the quirky update for 2000?

and I third :P.