Yes, you can export the data to Excel or PDF.

I want tp create a scenario when I perform failover from Node1 to Node2, I want the database to get stuck in Reverting/In Recovery state on Node1 for longer...

Try this:

SELECT 
  A.custnbr, 
  AvgLag = CASE WHEN COUNT(*)-1 <> 0 THEN CONVERT(decimal(7,2), 
          ...

@dennis Jensen: I do not understand what is your problem?

Have you read the OP's original post? OP wants to remove Min(ShipDate).  I answered to him as I understood...

For more accuracy, you can use Record_Add_Dt = DateTime.UTCNow;

Replace Min(ShipDate) with the following LAG function to get the Previous Ship Date.

Lag(ShipDate, 1, '1/1/1900') OVER(Partition by Custnbr ORDER BY ShipDate ASC)

Your final query will be along the following lines:

I would like output to show:

Custnbr ---- (Lastest-Order date) ----(Previous Order Date) ----  Lag

Any Help?

SELECT 
  custnbr, 
  AvgLag = CASE WHEN COUNT(*) >...

Before creating the SP in a...

Did you try extended events?

Try enabling named pipes and shared memory protocols and give it a try.

40 databases, how many physical CPU's or VCPUs on this server?  Looks like querying a huge Contacts table...

If it is SP, as Jeff pointed out, it is a case of...

Sorry, Scott I don't agree with the above. If you check out...

Try this, just as a beginning step, I do not know your requirement. The SP picks the table using a Dynamic SQL statement if you store the newtable name in...

Add a supporting non-clustered index for your DELETE operations. Similarly do it for UPDATE as well. These indexes will be huge in size based on the data and will help...

Try sp_whoisactive, you can search for it. It provides all the current running tasks/sql/jobs etc. It will also provide time in days, hours and mins since a task started.