If you can't guarantee, 100%, that most (read that as 98% or more) of the queries will be able to filter on the partitioning column(s), then whatever you do, don't...

You want to look up the WITH MOVE syntax. You can restore to a new database name, but only if you also move the storage location for the database.

First things first, just so you know, despite the name, Profiler in Azure Data Studio isn't Profiler. It's a wrapper around Extended Events. You can expand and extend what gets...

And here's another area of trust that worries me.  I regularly reconcile all my financial accounts monthly.  Why?  Because they are all on computer systems that can cause errors. ...

What is it with double posts on this site? When I submitted my first post I got a 403 error and then when I refreshed the page I didn't...

Truly appreciate everyone's feedback on this one. I find it a fascinating topic. I like the various approaches we all take, based on a combination of our own experiences and...

Grant, and anyone else who may not be aware, the USPS offers Informed Delivery on their web site which provides pictures of most mail being delivered.  It's a simple...

The thing is, since there is no real nested transaction, you can't "deescelate". Just as the outer commit will always being the point at which the commit happens, the outer...

The output will tell you if it has eliminated pages and how many were eliminated. It won't tell you specifically where they are or what was on them.. This is...

The Query Store information should survive the upgrade.

Not really. More memory. Parameterization so that queries aren't ad hoc. Optimize for ad hoc so plan stubs are used for the one-off queries, reducing memory use, increasing the chances...

That's a sysallocations error. You should restore from a good, tested, backup. Or, you can run repair allow data loss, but I'm not sure it'll work. Here's a bit...

Your choices are pretty limited. Plans that are negatively affected by the 2014 Cardinality Estimation engine are generally marginal in terms of performance and behavior, prior to getting the new...

For the feedback to work, there has to more than one execution. No other possibility exists. There's not a switch or a setting that will affect this. You could look...

What you're looking for are the INSERTED and DELETED tables that are available within a trigger. For an INSERT operation, you'll only see detail in the INSERTED table. For...