Here is another thread that discusses the topic with additional worthwhile responses to those already made on this thread:

Pros and Cons - Table with loads of uniqe columns VS Row...

Your comment about filtering using the security metadata available for the logged in user (e.g. by using ORIGINAL_LOGIN() or SUSER_SID()) is where I would go with it.

See the section...

Yes, it can. As you have seen a shrink process can destroy performance of your indexes due to fragmentation. If you must perform a shrink routine to reclaim disk space...

Could be lots of things. Some are related to SQL Server, some related to your environment at large, e.g. network issues, slow server in general due to non SQL Server...

I cannot see what you see so cannot really comment on specific tweaks to make to your settings. I would say keep plugging away because it sounds like you're close....

All I can say is look for a workaround because there is no way for us to know what is happening in your environment as there are too many variables.

If...

Did you check the job tables to see what was in them? If you're running replication or log shipping or other subsystems you might be surprised at what is in...

To be complete, that was what I ended up with. What I actually did:

- Added all the perms recommended in the article and got a successful run.

- Removed MyAuthenticatedUser from...

Laerte, the article you linked to had a tip that worked for me. I did not have to grant all the perms noted in the article, specifically I did not...

I am happy you got something working in your environment but changing the Active flag had no effect in my environment, i.e. I still see my computer name listed with...

How new? Log Shipping jobs can fill up the job history in a hurry. So can jobs with very frequent schedules, e.g. run every 15 seconds. Have you checked the...

John Mitchell-245523 (8/23/2012)

---

opc.three (8/22/2012)

---

Is this to say that in a not unique index that SQL Server will attempt to insert new index entries with an existing index key in the...

GilaMonster (8/22/2012)

---

John Mitchell-245523 (8/22/2012)

---

GilaMonster (8/22/2012)

---

The thing is, they're not quite the same indexes. The unique index (for reasons of index architecture) is essentially an index on the key column, include...

sqlcmd is picking up the Shared Memory instance. For whatever reason it is represented without the instance name but it is nothing to worry about. If running sqlcmd -L from...

A "merged cells" is nothing more than a UI trick for us to display data in a specific way. I agree with Craig, when referenced with an OLE DB driver...