I have not read the blog post yet but I have completed the present thread. I'm a bit steamed at the foo-foo-rah caused by this alleged incident.

Now moving on...

I am curious as well about the 5th question ...

I prefer a couple of slightly different methods - both call for complaints though. Method 1: revoke all permissions from the view after scripting themout first of course. Method 2:...

In the past this was presented to me once in an interview. I chose not to even complete the interview and stated the same to the Support Manager. Based on...

Pay a vist to http://www.sql-server-performance.com/

It is a reat site just like this one !

As a failsafe do not remove the login just deny access. Also, if you are using MOM,you will need to explicitly grant the MOM action account sysadmin.

Possibly more fuel for the fire:

http://www.ddj.com/dept/database/197002416?cid=RSSfeed_DDJ_DataBase

A SQL Server is a server dedicated only to SQL Server <period>

A new 'application' server is definitely needed for CLR, XML and anything else that is not SQL <period>

SET RESTATE_PREVIOUS_POST...

Please do not double post: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=346136

Hey, maybe MS will go to 3-part numbering like Sybase, Oracle and DB2 --- wow another 'retro' concept !

Humor aside, that is exactly what they probably need to do. The...

Just in case you do not have the OS patch link:

http://support.microsoft.com/kb/931836

Also, this is one of the 'nicer' Windows patches - it does not need a reboot !

For performance there is no hit either way. 

The MS best practice given to us by a ROSS engineer was to audit failures only. Your SQL server errorlog growth is zero to negligable...

If MS continues to 'stay the course' of introducing new features in SP's I may have to start reccommending to wait until SP3 or SP4 has been out for a...

I love a good discussion, especially when the likes of Colin and Jeff add their knowledge to the banter. I'm always learning something from them. Keep it up guys !

Yelana you are correct. However the point that I was trying to make was that this type of index used for just one query, as opposed to a number of...