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...

Nonclustered indexes are logically sorted by the index key. What are you trying to do?

In general, the wait statistics before and after the slow time to see what's causing things to run slow during the slow time. If you know the specific queries that...

Since you're updating the table, and the table is the clustered index, no matter what, the cluster is going to be accessed. However, look at the execution plan. If it's...

I suspect you have something else going on there. Those statements are SELECT statements. They're not going to be blocking in this fashion. Instead, there must be something taking out...

Normally to set up a reporting system you'd look to something like Availability Groups (where you can set up a read_only secondary), log shipping, mirroring, or even replication. These are...

helper_10 (3/19/2016)

---

There are couple of ways to do that; First you can download AdventureWorks Database file with .Bak extension and use restore method to restore to your Management Studio. Secondly,...

I've never heard of such a thing, no. Unless you've found some kind of very obscure bug, I can almost 100% guarantee that something is being done on that system....