Just remember, the first column is the column used to create the histogram in statistics. The histogram is one of the leading drivers for the optimizer to make determinations on...

The only way you can tell this is if you have a monitoring system set up. Either one you build yourself using Perfmon counters, or a 3rd party tool. There's...

Personally, I'd got the third party route. It's going to be a lot easier. However, yeah, there are tools. First, get PerfMon. Capture the appropriate counters there. You can program...

It's completely dependent on the indexes. I know Minion lets you pick lists of indexes & break up the process. I suppose Ola's script must too. Do that. Do the...

There's a lot to unpack here, but I'll try to answer some of it.

First question, can you identify which tables have been changed between two dates? Yes. The key to...

It's a parallelism deadlock. So, whichever query was involved, it was the only query involved. If you can't see the query from Profiler, you're stuck. Profiler doesn't have a correlation...

1. Generally, yes. If the index is in active use, it's probably needed.
2. The rule I follow is pretty simple. Unless I can absolutely prove otherwise, through very thorough testing,...

I appreciate all the feedback. No arguments from me on any of it. This all really is a balancing act. Getting it to "just right" is hard.

Each restart, yes, but also failovers, detach/attach, all sorts of variation on that data. It is the one place to try to determine if indexes are in use, but, it's...

The best way to get detailed information about the behavior of SQL Server is through the use of Extended Events. They are not zero cost, but they are the...

Yeah, the XML is the easiest way for all involved.

It's two steps. One, gather the info. Two, based on that info, send an alert. So, a rough outline of psuedo-code would be something like:

SELECT COUNT(*)

FROM dbo.mact_data

WHERE dtstamp > (GETDATE()-60);

Then...

Yes. Just grant them read access to the view. Here's the documentation and examples.

I'm not sure what you're looking for in terms of help. Write a query that satisfies the criteria you outlined. Schedule that query to run using SQL Agent. Put an...

Ain't gonna lie, I'm shocked as heck that the optimizer didn't timeout on this query.

The good news, lots of index seeks. The bad news, scattered all over the place, all...