There are a lot of great free sources of information. This website is one of my favorites. Sign up for their daily newsletter and read it every day. Look for...

Well I've figured it out. You have to use the REVOKE SCHEMA command. This is what I ran that deleted the db_accessadmin securable:

revoke delete on SCHEMA::db_accessadmin from \DOMAIN\UTILITYROLL_USERS

revoke EXECUTE on...

Yes, there was a sub-query. I didn't know DTA wouldn't parse that. Thanks!

During this incident I used Idera's SQL Diagnostic Manager and SQL Doctor. SQL DM showed there was a big problem because the wait stats were huge. I could tell that...

SQL Kiwi (5/22/2012)

---

TheSQLGuru (5/22/2012)

---

As always you have a great breakdown of what is going on in the plan Paul! To the OP: Paul makes a great point about helping...

Paul, thanks very much for the good ideas, I'll have to look into those. Two questions - could the differences between the estimated and actual number of rows be due...

Im sure you must have known this, usually whenever i work on a performance tuning task , before each execution i do clean the cache and buffers to evaluate the...

Thanks, Scott! I've learned a lot during this incident and also learned how much I don't know...

Jeff, thanks for your input and ideas. My main concern was to "First do no harm", so in using tools, I didn't implement something if I didn't understand it. Probably...

SQL Kiwi (5/20/2012)

---

This is where I would start, comparing actual plans for...

gil 17845 (5/20/2012)

---

You might want to try the free trial of Qure Optimizer, a workload tuning solution by DBSophic. I have seen quite a few cases where users didn't get...

He's pretty new to SQL Server but has worked with databases some. I'd like to get him a good introductory class. I know he'll have to do a lot of...

Has anyone taken classes from New Horizons? We have money for an instructor led class, so that's what I'm looking for.

Thanks, Kevin, I'll keep it in mind. Due to budget considerations I don't think that's an option. I'm currently trying to do what 4 DBAs used to do. I have...

Right, I had forgotten about full scan for update stats. That would be so much faster than rebuilding the index. Thanks!