It's possible the user account had a priorly-issued deny on that right. That would override the group right (if I remember correctly).

If you right-click on the execution plan, you'll have an option to save it. Save it, zip it, upload it to the forum.

Is it possible to add covering indexes to the tables? I see you mention clustered indexes, but I don't know what (if any) other indexes you have.

It would also...

Actually, Chad, knowing that, I would have worded the question to include that data. Minor nitpick, but legit. Not my question, but would have worded it with that...

This site has a link to some job ads. There's always Monster.com, etc. Those and Google will get you all the hiring data you can possibly use and...

Thank you for those links. I hadn't seen that one before. Very useful.

Can you post the table definitions and execution plan?

Actually, now that I think about it, I think overheating can cause random reboots, as can faulty memory modules.

The last time I saw that, it was malware on the computer, but that was a long time ago, and it was a desktop computer, not a server.

When you create or rebuild an index, by setting the SORT_IN_TEMPDB option to ON you can direct the SQL Server 2005 Database Engine to use tempdb to store the intermediate...

I'd go with the 3-table suggestion. It's more standard, and thus will be easier to deal with. Save yourself the agony of having to debug the binary two...

Andras' solution should do it.

The other option would be to modify it to a nested sets hierarchy (Joe Celko style) and query that way.

I'd tend to go with the second one, all other things being equal.

In that case, you're probably getting the best sort speed you're going to.

You can have multiple transaction log files per database.

Backing up the database, by itself, won't usually shrink the log files. You have to do the backup, then issue a...