The Metropolitan Museum of Art...

Experiment around with the exevents. I'm pretty sure there's a way to see those, but I could be wrong. I don't have an immediate answer to hand.

Generally, prepared statements are roughly the same as stored procedures, so they're handled very well indeed. The optimizer can create an execution plan that is reusable across multiple iterations of...

Yeah, it should. Just use the published trace that's in the documentation.

Not at all required,...

Most of the time, the queries that are suffering because of the new cardinality estimator have other issues that can be addressed (or the architecture is off). Frequently the best...

Most of SSIS and SSRS management is through Visual Studio, not SSMS. And yeah, you'll probably have to upgrade to the latest database tools for those. SSMS can connect to...

When I've automated restore processes, I've usually had access to msdb to retrieve the data directly. It sure makes things easier. Plus, we usually had standard drive configurations & folders,...

navtec (8/24/2016)

---

Maybe there was a large amount of data in that nvarchar column which caused sql server to treat it as a LOB during online index rebuilding?

I'm using sql server...

It will do the business validations, absolutely. You just have to write the tests. There's not a tool out there that knows your business well enough to automatically generate tests...

Jeff Moden (8/23/2016)

---

Grant Fritchey (8/16/2016)

---

I have an article on how to retrieve information [/url]from your backups that could help. You'll just have to convert that information into what you need...

Yes. See my post above. T-SQLT and SQL Test [/url]from...

For things like this, it's a VM. That means the same...

The biggest driving factor for seeing any kind of performance benefit (and more frequently, for avoiding a performance degradation), is the ability to absolutely ensure that the overwhelming majority of...

Go and read the documentation on the (MAX) setting for...