I have 2. One has 'geek' written in L33t.

Messages from the SQL error log please.

Exact errors you got when querying the DB please.

I'm not able (or willing) to help without both. I don't want paraphrased descriptions. Exact messages.

As...

Jack Corbett (2/23/2010)

---

3. Using an 'OR' also limits the usefulness of indexes. The Optimizer has to choose to access 2 indexes and merge those results (requires ordering) or...

Check in Books online what the minimum permissions are for each of the things he'll need (ask him for a list) and then evaluate how you're going to do it....

If you check in books Online, it lists the permissions needed to query each DMV in the page on that DMV

Because the columns are in the select clause...

Not on SQL 2005/2008. It may...

Take a look through this article - http://www.sqlservercentral.com/articles/64582/

I would strongly suggest, if you don't have the skills in-house to fix this, call MS's customer support people. They will charge you, but it's better than depending on people...

Please don't cross post. It just wastes people's time and in general multiple posts in multiple forums is more likely to irritate people than cause them to help you.

No replies...

Please don't cross post. It just wastes people's time and in general multiple posts in multiple forums is more likely to irritate people than cause them to help you.

No replies...

Are we geeks or not?

Currently sitting with colleague who I don't see often discussing disk performance issues over supper.

Please post all messages in the error log and exactly what you've done until this point. Also the output of SELECT @@Version

I suggest you don't make any more attempts to...

You'd have to wait until Thursday afternoon if you want to...