You're welcome. There really isn't any other way and no "super" DBCC since those are separated out as database level commands.

It sounds like your application is not connecting to SQL Server. You would need to determine how Primavera is configured to connect to SQL Server and be sure there is...

securing a cluster can have multiple meanings, and encryption would be a valid one. So I think the question was misleading and have corrected that.

I'm not sure of the benefits of INCLUDE here. Why wouldn't you put all the columns in the index? This has puzzled me from day one. The index size is...

The IIS website properies has a security tab. That should allow you to use Windows Auth, or anonymous connections that go through a windows account you specify.

Those should be what...

No real issues, though be careful that some things, like SSIS, aren't multi-instance. There's one copy for all instances. If you use that, could be an issue.

Memory is your real...

There's an ms_foreachDB, which is essentially a cursor that executes a command, you could easily write your own script to do this as well.

Here's a thread with it being used:...

As Nicholas mentioned, this is handled at the hardware level. The software usually has no idea there is RAID. It just sees a disk. Unless the hardware vendor installs some...

Properly cut? Since when do those in MI know meat? Aren't you more the cheese and beer crowd with your neighbors?

If you're a small shop, I'd stick with SSRS. It comes in the box and it's fairly open. The addition of some of the components in 2008 means that it's...

Brnbngls, exactly. That's why I say comment and document enough to get by, but don't get too caught up in it!

Do more of what works, less of what doesn't. It's...

I see most everyone saying the documentation from the code point of view is critical. And that does make some sense, make notes in the code as you go.

However the...

It doesn't make sense to move fact tables out. As mentioned above, compression works at the table level, and also at the index level. You can compress a table and...

You are correct, clustering should be a valid answer. I shall correct this.

That's a little scary, Lynn, and I have no idea.

Have you called PSS on this?