Did not have time to fully digest the entire article, but the pieces I managed to read were great. Thanks a lot. Will have to experiment a bit since the...

The way you have it no index is used when this query is executed. You need an index on column Name

The original SQL Server was 2000. At some point it was upgraded to 2008R2. I just did some extra testing and I can see the newer users have the permission...

There are several SPs that link to sysusers. Problem is with all of them.
This is a fragment of the relevant code:
SELECT
name,
CASE
    WHEN pol_type...

Wow,

Now instead of giving me a fish you are trying to send me out to sea with a net... 😉

Thanks.

Now I have to check out and head home before...

Another question about that slot array. I understand this is only on the clustered index pages. Correct?

Thanks for the clarification. That slot array. Is this a fairly new thing or it was like this for a while ( I mean SQL Server versions)?

GLIC DBA (10/28/2009)

---

I didn't realize the working of a cluster index in SQL Server is different from that of a clustered index in Sybase. I erroneously thought that they...

Without diving into the details of your case I will answer one of the questions you had: "Can I use union all instead of OR".

Absolutely. Recently I helped a friend...

I would like to thank everybody who took the time to read the article and all the respondents who provided their input on this forum. I don’t think I can...

shane.vincent (5/12/2010)

---

Just a thought, but I also got a more accurate GETDATE return value than the original article.

(19430 ,3.52769) I think that a lot of this has to do with...

thisisfutile (5/12/2010)

---

thisisfutile (5/12/2010)

---

My XP...