It doesn't...

It's not always about performance. My company has largely stopped buying servers (I think, one in the last 6-7 years). Instead, we're hosting most things on VMs online, or in...

I'd focus on the queries to see what's causing the pain. Document it for the vendor. Also, maybe a judicious index or a plan guide could fix the issue. Capture...

By secondary I assume you mean a differential? Or maybe you mean a file or filegroup backup. If the first thing, nope. You're stuck without the primary backup. If the...

There's not enough information here to go on. We could be looking at all sorts of things from bad or missing indexes, out of date statistics, blocking and locking, to...

You are in a tough spot. Most organizations, like you, don't have adequate IT experience and knowledge to manage development well, assuming you get a good contractor who isn't out...

Sorry. That was meant as a joke. Apologies.

Both? I mean if we're going for clarity. Although, if I see xxTable as a parameters defined data type, I'm going to assume something custom.

Online trading didn't kill financial advisers, prefab construction didn't kill architects, TV dinners didn't kill professional chefs, blogging didn't kill journalism, NoSQL didn't kill SQL, and DaaS won't kill...

I've been saying this for years. Take CosmosDB. No DBA needed. However, there is an HA/DR aspect to it. There is the need for performance tuning. There is a need...

You're looking a fully customized CRM solution built from scratch? Yeah, a few months, at least, to deliver that. However, weeks to start releasing code to you if they're doing...

Do you have to be able to both read and write in each of these locations? If so, that radically complicates the issue. If all writes are to a single...

Total agreement with Erland & Thom.

Aggregates and analysis queries. That's where it shines. A really simple GROUP BY on a larger data set will immediately show the benefits. Columnstore works well with aggregates and large...

I was told (but have not tested) that Extended Events cannot return the query that is causing an event.  If that's not true, then my apologies and I'll go...