what error? could u send the error statement plz?

it runs here perfectly! 🙂

Always remember to create backup before reindexing because this is much possible to happen.

By the way, following script displays missing indexes in each table, see if this can help:...

Thank you Jack! I'll check it

Thank You 🙂

so far as I know it sets status of a server side trace.

maybe I've not asked my question clearly; I need history of data changes and the queries that...

:laugh: :laugh: :laugh:

thanks all for your comments!

actually,I'm DBA ( a novice one 😛 ) and we usually have performance problem in our servers> I've decided to send all developer, general...

the size of my DB is around 20GB

peace2007 (3/16/2009)

---

by the way, I have 2 drives, shall I set the page file size for each drive to 12 GB or the total size should be 12? besides, what...

by the way, I have 2 drives, shall I set the page file size for each drive to 12 GB or the total size should be 12? besides, what shall...

I set initial size and maximum size of page file to 12GB and enabled AWE then set the max server memory to 6GB now let's see what happens when all...

for page file size, there is an initial size and max size (computer properties-> advanced -> ..virtual memory) I don't know if it is the correct place to change and...

AWE is not enabled!

How can I check this please:blush:

total paging size for all drive is 2046MB

Check out any windows scheduler tasks are scheduled on the...

I'll test it

Thank you ALZDBA 🙂

this is the view:

WITH Tree(PageId, ParentId, PageTitle, strPath, strPathName, [Level]) AS (SELECT PageID, ParentID, PageTitle, CAST(PageID AS varchar(MAX)) AS strPath,

...