ASPState is difficult to deal with. Generally, isolating it as much as possible is the best bet. Better bet, don't use it for state management of your ASP pages. Storing...

SQLRNNR (3/12/2014)

---

Lynn Pettis (3/12/2014)

---

SQLRNNR (3/12/2014)

---

Lynn Pettis (3/12/2014)

---

william.rees.howells (3/12/2014)

---

That is correct. I run it every time I run the query. The query speeds only go back to normal once I drop...

If you're on SQL Server 2012, then the answer is the Distributed Replay tool. With that you can simulate load on the system. You'll have to build the load yourself,...

Try modifying the system database called model to have the security settings you want as outlined above. Then, when you create a new database, what's in model is what gets...

Well, thinking about it some more, you can turn on auditing on the blob stores where the VM files are located. Set that to verbose and see what the heck...

No, statistics aren't modified by backups.

I've been using SQL Server on Azure in VMs a ton. I haven't seen this problem crop up before, so I'm seriously stumped on what...

No argument, but usually, it's relatively rare to change primary keys once a system has been built. It certainly doesn't make the early design and build stages or 1.1 releases...

But a cost of 5 is so cheap that plans that shouldn't be parallel can get set up as parallel, running longer and using more resources than they should.

No, that one was weird.

Do you have database backups? You'll need to go to those to restore your system.

Based on what you're showing, those two queries are identical. There are so few tables the optimizer is going to rearrange the order to suit itself any way. There's no...

Editing and rewriting the query tuning book for 2014 when I came across this:

Queries may be attempting to deal with data in a row-by-row fashion (or to quote Jeff Moden,...

If the memory is available to the OS, SQL Server can also use it.

As for changing from 0 to 4, 0, the default, uses all processors available. You don't need...

Maybe get them a copy of Craig Mullins book, Database Administration. It's an awesome overview of the job. It doesn't get into technologies directly, just responsibilities and concepts. I realize...

First blush, no, I wouldn't say it's a "bad" design.

But, if I see varchar as a primary key, I'm assuming natural keys. There are good reasons for this from both...