Alerts based on tags. I don't know the specifics of how to do this in Idera. Last time I evaled the product, it's alerts weren't that hot.

After tons and tons of testing with partitioning, I've completely tossed it as a performance enhancement tool. You can, in exceedingly rare circumstances, see actual performance enhancement through partition elimination...

Also, the biggest pain point in upgrades from pre-2014 to post-2014 is the new cardinality estimation engine. Most queries are unaffected. Some queries benefit. A few, suffer greatly. Plan to...

I agree, temporal tables are probably a better approach than CDC. I actually was sitting here trying to remember what they were called. Ha! Old age is fun.

As to history...

Oooh, this is a HUGE topic. Posting into comments in a thread is not going to cover everything. You need to look at a completely different database design. Here's an...

So, Q0: No. The issue is that all plans are estimated plans, so they won't show how many reads they did, just how many they think they might do. You...

So it's official. I've been accepted to Grace Hopper 2019 in Orlando to talk about "Imposter Syndrome: Are You Ready To Mentor". WHEEE... Now I have to overcome my...

Just talking to an AD expert yesterday after I presented a session on SQLi. Evidently there is a "golden ticket" in AD that unlocks the kingdom. Without that, the answer...

Not a problem. Happy to help. Hopefully we hear from a few others as well. There is some degree of disagreement on this topic.

So, I work for Redgate. Take anything else I say with that in mind.

The whole purpose for purchasing a monitoring tool is to buy time. We're literally not doing anything...

Welcome to SQL Server Central.

It looks like the usual has occurred and you have  a couple of good answers to your question. Never hesitate to ask follow-up questions. We like...

Your query is working. I tested it running this:

SELECT *
FROM Sales.SalesOrderDetail AS sod
WHERE sod.SalesOrderDetailID = 432;

And modifying the index to [IX_SalesOrderDetail_ProductID]. It worked fine.

So, the problem must...

Here's the bad news. You need both. If logically the UserName value is the business defined identifying value, you should have a unique constraint on it. This is what is...

The information is captured in system tables. You just have to query those and you're off and running. Take a look at sys.jobhistory. Then, to only get the longest one,...

@Grant: Can you provide me an example on how to do that using Query store or extended events or any article that you can point out that would help...