All I can find is this incredibally useful info on msdn :

Exists in every database. Contains a row for each general value property of an entity.

Can you show us...

ronmoses (10/19/2011)

How could I look at that cute little face and assume there was potential for even a shred of evil behind...

ronmoses (10/19/2011)

Oh I know. I made a conscious decision not to take it...

You mean 1 plan executed 700 times

or 700 plans executed once?

Neither and both are a problem.

SS manages the ram used for the plan cache and wipes out old & unused...

Thank for the feedback.

P.S. I've confirmed your findings in my sql 2005 SP3-ish environement.

Shows FF = 0 in the GUI but scripts out to the correct 85 FF.

P.P.S. I never...

The only time I had a similar issue was an id10t issue in the script (db context wrong).

Since copying the files doesn't edit them, that just can't happen.

Maybe you were...

I have to put it in the briefcase or something. Must be the first time it happens this year...

And of course the script to solve the fragmentation once it happened :

http://sqlfool.com/2010/04/index-defrag-script-v4-1

Further explainations on how I used it to figure out the FF :

http://www.sqlservercentral.com/Forums/Topic1126147-146-1.aspx

Fill factor is also 1 of the next logical steps.

100% FF will definitely shoot you in the foot fast with that type of usage.

Here in a fairly well designed app...

That's too vague to answer!

What type of join? inner, outer, full?

In the inner join there's no real right or left. They just have to match and the server...

Save as native html + all the files separately.

Then try mailing it to use if the upload to the message boards doesn't work.

Dev @ +91 973 913 6683 (10/19/2011)

You then need to find the javascript code called download and reverse engineer what it does.

From that you have a shot @ getting the...

PS

NEVER use SA account for this.

Create an account for the web reports and use that instead. Much less dangerous security wise.

You need to preset the authentication (credentials) in the code.

Google those terms and see if you can't find the same code I found 2 years ago and which I don't...

You then need to find the javascript code called download and reverse engineer what it does.

From that you have a shot @ getting the correct & final url.