There's a good article on it here. Be sure to read Paul Randals [/url]work on the subject.

Koen Verbeeck (3/22/2016)

---

Grant Fritchey (3/22/2016)

---

Thanks for sharing this....

Nothing is ever free. However, in most cases, the load is light enough that it only marginally interferes with normal operations. If you use backups to offload it, do some...

Thanks for sharing this. You were on my...

In Standard Edition, while the index is being rebuilt, it is offline and user access is blocked.

Why are you updating the indexes so frequently? Unless your queries are doing lots...

Sachin Nandanwar (3/21/2016)

---

It sounds that there are to many plans in your plan cache memory.10% of buffer pool memory from 4gb-64gb + 5%>64gb is allocated to plan cache.

Can you post...

It's possible you're seeing bad parameter sniffing. First, identify the individual query that is running slow (you have to attack these one at a time, there aren't batch solutions for...

This blog post [/url]has the one question I always ask and a link to the phone screening questions that weed out most people.

I hate trivia questions: "Which traceflag do I...

sys.dm_exec_query_stats or sys.dm_exec_procedure_stats are the two DMVs that will at least give you a ballpark figure on how many queries are coming during the last 24 hours. They are cache...

Testing locally with your system is the only way to be sure. It really depends on if the process is loading the temp tables/table variables once or updating them constantly....

There's no good way to know that at all. It's why I'm not that crazy about the missing index report as anything other than some suggestions, and not necessarily good...

That suggests it's not running. The easiest way I know to check is to look at your Services. You should see one for SQL Server. It'll even provide the instance...

Lynn Pettis (3/21/2016)

---

Okay, my daughter and I are in Providence, RI. We were scheduled to do campus visit at Johnson & Wales University this morning but they called yesterday...

And, worth mentioning, Redgate tools can connect to Amazon RDS. I don't know the full level of support there, but the fundamentals work. So you could use our tools to...

SQL Server Management Studio (SSMS) is just a tool for manipulating SQL Server server instances. In order for you to have a copy of Adventureworks locally, you'll need to install...