yes i am interested.

I am in Denver CO.

please tell me more details.

Vlad

Yes, I found more examples once I spent more time searching.

this is a good one, too:

https://sqlnotesfromtheunderground.wordpress.com/2014/10/02/restore-duration-time-for-database/

I ended up writing this-- Declare variables

DECLARE @DatabaseName VARCHAR(100)

SET @DatabaseName = 'WideWorldImporters' -- Replace with your database name

-- Create a temporary table to store the error log data

CREATE TABLE #ErrorLog...

I ended up writing this

-- Declare variables

DECLARE @DatabaseName VARCHAR(100)

SET @DatabaseName = 'WideWorldImporters' -- Replace with your database name

-- Create a temporary table to store the error log data

CREATE TABLE #ErrorLog...

I ended up writing this

-- Declare variables

DECLARE @DatabaseName VARCHAR(100)

SET @DatabaseName = 'WideWorldImporters' -- Replace with your database name

-- Create a temporary table to store the error log data

CREATE TABLE #ErrorLog...

I ended up writing this

-- Declare variables

DECLARE @DatabaseName VARCHAR(100)

SET @DatabaseName = 'WideWorldImporters' -- Replace with your database name

-- Create a temporary table to store the error log data

CREATE TABLE #ErrorLog...

Never mind :).

My boss just pointed me to the answer here:

Look here for details of that DMV

https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-plan-transact-sql?f1url=%3FappId%3DDev15IDEF1%26l%3DEN-US%26k%3Dk(dm_exec_query_plan_TSQL)%3Bk(sql13.swb.tsqlresults.f1)%3Bk(sql13.swb.tsqlquery.f1)%3Bk(MiscellaneousFilesProject)%3Bk(DevLang-TSQL)%26rd%3Dtrue&view=azuresqldb-current

  under the Remarks section.

Thank you! I'll do just as you advised. Will save the counter value every 1 minute to table.

Thats exactly what my question is :).  Should we consider such change? if yes then WHY. and if we should not , then also WHY?

Neither answer will work, because on one date there may be 1000 records and five on another, etc. The datetime value is different up to milliseconds for each row.  But...

Jeff, why do you think deadlocks could be an issue? in any case, we almost never have them in our environment.

for example, between a month ago and today there are...

I am doing it this way as it seems the only way:

Drop index ci1 on Z1

alter table Z1 Add constraint PK_Z1 primary key clustered (id) on [primary]

thanks. resolved.