now that is EXACTLY what i was looking for.

excellent work!

thanks!

any one care to give this a go?

dbcc inputbuffer(spid) sounds easy to me.

so we are looking for this file: c:\program ?

rename it to what exactly?

i'm also having this exact same error, and can't figure

out why it's happening. sql service is...

you mentioned this...

"Then I create only the indexes that were recommended by all three."

you mean you ran 3 different workload files, and only chose

the index which was recommended by all...

you mention "...by keeping 8k pages"

by this do you mean keeping the default 80% fill factor

because this is what it maintains of course when you do

not specifically adjust it upon...

probably due to the design vs index comment.

even a poorly designed table would benefit from an index.

found this on another site. seems pretty good.

http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=60&threadid=84680&STARTPAGE=1

found this post on sqlmag. might be a bit of an overload,

but it does have alot of useful information in it.

http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=60&threadid=84680&enterthread=y

when i ask.. i mean what to look out for? any thing i should consider?

for example... what if there are say a dozen of inner joins... does

that affect performance...

i'll restart; but this is going on day 2 for me actually.

i'll look around for a client patch/upgrade or hotfix or

something to see what might fix this.

thanks for the response...

i'm checking the bol now, and seems what

i need to do is force population of other filegroups.

thanks yelena.

yes it's close, but certainly not the same.

just about every one i know who uses management studio needs

to 'resize' not really toggle on/off the result pane although that

is also quite...

incidentally it's for the column of the SYSFILES table.

here's my query:

select name, left (filename, 3) as 'drive', size

from MyDatabase..sysfiles

order by drive, len(), size

actually; you are correct in the list example.

it was not ordered properly, but

when i ran this:

order by len(), size

it was properly ordered.

thanks again.