If it's not shown in the DETA report?  If you're talking about indexes, you might consult the missing indexes DMVs, one of which I think does show the anticipated percentage...

You can avoid a loop by using a Numbers (or Tally) table.  You can create your own table, or spin it up on the fly as I've done below.  This...

You can't, unless you already had something in place to capture such events.  If you're lucky, you may find something in the default trace.  Do any of your...

What's wrong with the one you posted - performance, wrong results, error messages?  Will this one not work just as well?
Select CustomerNumber, count(CustomerNumber) as Count
From SalesData

Somebody or something has stopped the jobs, either through the GUI or with an sp_stop_job command.  Did this happen just once, or does it happen regularly?

John

Try this.  It's not tested because you didn't supply DDL and INSERT statements.  What do you want to happen if there's more than one xyz?
WITH Ordered AS...

In the first error, you're missing a backslash from your path.  What it's looking for is a file called "sftpto Televox.bat".  Do you have Integration Services installed on the server?...

Is the batch file in the root of the G drive?  Please try moving it to a subfolder - I've seen strange things happen when trying to programatically access files...

Join sys.database_principals to sys.server_principals on sid=sid.

John

Chances are you're going to be supporting it, so you need to document and understand it.  The COALESCE function takes the value of EndedAt, and if it's NULL, changes it...

I'd go into this with a more open mind.  If it's a data load from another server, it doesn't have to be disk IO - it could be network latency,...

Start with a calendar table and then do something like this:

SELECT
    c.MyDate
,   t.ProductType
,   COUNT(t.ProductType)
FROM Calendar c
LEFT JOIN ContractTable t