Thank you for your reply ,but i got same results with '0's

Well,when i rebuild index i specify fill factor(100).My question was why is it not saving .Also check the link that you pasted.It is creating copy of this(sqlcentral) page.

Never mind.Got it

Thank you.

How do you add permissions to a folder?

Got it.It works When i point the output file to C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\xxxxx.txt which is default location.I am still trying to find out why it does not work with...

Thank you Steve.I'll go through your suggestions and i'll post the results. Meanwhile i talked to management and asked them to move prd database to 64 bit box ,so we...

Also these messages were logged in the error log:

"AppDomain 171508 (mssqlsystemresource.sys[runtime].181191) is marked for unload due to memory pressure."

No,it is not busy instance.It started few days .We are backing up prd database (full) twice a day and trn log backup every 2 min.I change server database settings ...

It is available.Trust me

.

Go to their web site. They have all info(price ,hours ,topics...). Actually now it calls "learnnowonline".http://www.learnnowonline.com/appdev/courses

Hi Fabrizio,

AppDev has nice DVD's. I bought set of SQL Server 2005,2008 3 years ago.Very helpful.

Correct me if i am wrong:

Using Clustering key sql server retrives data from memory vs

using Rowid from disk

thank you guys for your responses.i found the problem.

DNS

Thank You