Well, after a long while, I have an answer to this, thanks to Microsoft.

To remind everyone of the issue, I had the following query (just the scheleton shown for simplicity):

CREATE...

Michael Valentine Jones (8/25/2008)

---

You need to look at the type of paging to know if there is a problem.

Running backups can cause paging as the OS allocates file system cache,...

TheSQLGuru (8/25/2008)

---

1) >> We are using AWE: we have locked the working set to 11.5 GB (we should probably increase that).

NO you shouldn't, not if you are...

Sean Kohler (8/24/2008)

---

What are the box specifics? Mem, CPU, Page File size, OS

SQL 2005? 64bit?

Any other applications running outside of normal Windows processes?

Are you limiting memory to SQL?...

charshman (8/22/2008)

---

I noticed in the second half of your OR condition, you check:

[font="Courier New"]R.blocking_session_id = 0 AND R.session_id IN ...[/font]

It looks like your query will show the blocked processes, but...

Abhijit (8/22/2008)

---

yes we can implement column level encryption using the ASYMMETRIC KEY and SYMMETRIC KEY to encrypt & decrypt the column data.

check msdn for brief help on ASYMMETRIC KEY and...

I don't know if this was mentioned already...

What version are you on?

Maquis (8/18/2008)

---

If I get a "1" as a result from the query

SELECT is_broker_enabled

FROM sys.databases

WHERE name = N'msdb';

then I don't even need to stop the SQL Server Agent, is...

Thank you!

Maquis (8/14/2008)

---

We've been using sp_SQLSMTPMail for months, and today it decided to die with this error:

Error setting Message configuraton field "smtpserver".

CDO.Configuration.1

A dynamic link library (DLL) initialization routine failed.

I've read this...

Grant Fritchey (8/13/2008)

---

Good to know. Unfortunately, with the division of labor where I work, I don't have the ability to do that. But if I really need it, I know...

Grant Fritchey (8/12/2008)

---

Sorry I haven't been taking part in the discussion. Rhode Island celebrates VJ Day so I had the day off... Whatever.

Adding in reporting or views would be a...

Grant Fritchey (8/12/2008)

---

Thanks.

I've been remiss in my writing just lately (Tom, who I'm supposed to be working with, is going to kick my butt). There will be another OpsMgr article...

Maybe that's the recipe of success with SCOM, I'll keep it...

Grant Fritchey (8/12/2008)

---

Here's the bad news, the amount of good information in a single source on writing custom reports in OpsMgr is even less than that for programming against it.

Have...