paulhunter, I can see your point about OV instead of VO and if the consensus is that most people prefer OV then that's fine. Personally I've never considered it difficult...

I'm not certain of the validity of this, but from what I've heard: when a call is made to a stored procedure named with the prefix 'sp_', Sql will look...

My gripe is always with inherited code. I believe I have a good, consistent way of laying out my SQL but often I'm working on legacy code which has been...

If you want to return the top(n) records, you should use the TopCount function. I'm not an MDX expert, so I'm not going to attempt to explain the syntax but...

Are you familiar with using Impersonation with forms authentication? If you are then this is the answer. Simply authenticate the users through your application as users who have been assigned...

This may help:

http://support.microsoft.com/default.aspx?scid=kb;en-us;825019