This view will only work in the database the view is created:

and????????a.database_id = DB_ID()????????????-- for current database only

(that's the only thing which comes into my mind, or there are no...

Sorry, MSSQL 2005 and higher

Got it, I'll post an explanation later this week.

Excellent piece of code! I implemented it to speed-up some Datawarehouse processing routines. Processing time dropped from 500 minutes to 70 minutes! :w00t: :w00t: :w00t:

Regarding the temptable: I use the @toggle flag to determine if the temptable is already created or not.

In the first loop, @toggle=0 and a "select into" is used to create...

I am currently evaluating 2K8 and also trying to find the ultimate answer for this question. these are my thoughts:

+ Data compression. I think this is the most important reason...

This CTE method is not fool proof: it doesn't work if the separator character is not in the main string:

Msg 536, Level 16, State 5, Line 3

Invalid length parameter passed...

"Treshold" ... That's probably because my foreign language is dutch :hehe:

Thanks (I saw that in the code).

Maybe I was not clear enough: if TABLE XYZ is selected by SP_UPDATESTATS for updating, is "UPDATE STATISTICS XYZ" (without any additional parameter)...

Thanks, but I don't think this is the right query.

currrently, MaxDop is set to 2, but this query reported:

sessionid request_id parallel wanneer

-----------...

Forgot to say: rebuilding indexes eates logspace.

In order to prevent blowing up your logfile, you could consider a more intelligent rebuild. There are some scripts available (kimberly tripp has some...

I would say a 25GB logfile on a 9GB database is a little "out of balance"

How much of this 25GB is active? (measure over a longer period of time)

dbcc...

As reported, something else is locking this file. Maybe a filebackup is running at...

try this:

select * from sys.objects where name='XXXX'

The column [type_desc] is telling you what type of object this is

Added a new execplan. Have a look at the key lookup on ProjProposalRevenue. This now costs 96% (instead of 61%). The operator cost/SubTree cost is much higher.

Also attached the details...