Everyone no matter how much they complain are learning new things and that is what the QOD is all about. It is hard to complain about a question which is...

SQL Sever does some things which really make me wonder. It is interesting that it will automatically perform a dateadd function in this case. You would think that it should...

Colin makes an excellent point. I have worked with many clients who really start to get worried if their cpu utilization gets between 40 and 50%! I personally would not...

I agree with Tanula. I used the index tuning wizard when first getting into SQL Server and have come to find out that many of the recomendations it comes up...

Another thing I would look at is the estimated query plan prior to executing this again. There may be 1 or more indexes which can be added or improved upon...

If you are part of the system administrator's group then you definitely have rights to execute xp_cmdshell, otherwise you may need to be given permissions to execute. If you are...