Thanks guys, I will try not to disappoint... 🙂

Grant Fritchey (9/3/2008)

---

Now that I've taken the time to actually think about the answer to the question, yes, you'd need to recreate the script inside a monitor. Seems a bit...

ALZDBA (9/2/2008)

---

Indeed, this guideline to enhance IO still goes for sql2005 and 2008.

However, if you're going for partitioned objects, you should keep in mind there is a huge advantage in...

Lynn Pettis (9/2/2008)

---

I wish I had a server configured where I could test it out. I'm just going on what I have read about databases and physical design. ...

Thanks for the input!

In the TextData column add a filter that reads like this:

Like '%yourSprocName%'

I recall trying this once and not being able to get it to work. Test it out first.

I now see the issue,...

Ours is a pretty simple requirement - just be able to...

If you are dealing with a small db with low activity and/or are using it in a dev/test environment, it is *OK* to put both on same drive. The previous...

Restore your master db backup as another name, say master_bk, and check the sys.server_principals view. It will give you all server logins. It won't give you their mappings onto...

Are you local admin on the machine?

sudhakara (8/31/2008)

---

when check the error log i had seen the msg

"A significant part of sql server process memory has been paged out. This may result in a performance degradation.

...

Was there any reason for this? DB mail...

The sample project is ready. How can I send you the zip file?

I think it's easier if I create a sample report project and send it to you.

Pls stay posted.

Anyone know how to add attachments to a thread?