We have a process to identify the changes, but I am more curious about how to process incrementally if the data is altered was 2 weeks old data or older(cloud...

You can check it by looking at the execution plan property of the index that is used in your query. If expand the Actual Number of Rows, it will display...

There is a few syntax errors on your code.

Below is missing @ in front of Port_nbr.

OPEN ServerList

-- get very first record

FETCH NEXT FROM ServerList

INTO @id

, @ServerName

, Port_nbr

, @isLinked

In addition,...

If you want to filter duplicate, just use group by clause to filter duplicate row.

select column_name, min(PK_Column_name) PrimaryKeyColumn from tablename group by column_name having count(*)>1

The above script will identify duplicate...

If you think the issue is related to memeory, you might want to flush data cache(dbcc dropcleanbuffers) before you start your insert. Of course this may slow down performance of...

Here is the modified script for your purpose. (type S= system and type P= store procedure)

select state_desc+' '+b.permission_name+' on '+d.name+'.'+c.name+' to ['+a.name+']' COLLATE DATABASE_DEFAULT

from sys.database_principals a join...

You can configure the log shipping to be stand by(Read only) to use as reporting environment. Of course during the log restore the database will be in restore/recovery mode.

Here is the altered script.

SET NOCOUNT ON

DECLARE @crdate DATETIME, @hr VARCHAR(50), @min-2 VARCHAR(5)

SELECT @crdate=crdate FROM sysdatabases WHERE NAME='tempdb'

SELECT @hr=(DATEDIFF ( mi, @crdate,GETDATE()))/60

IF ((DATEDIFF ( mi, @crdate,GETDATE()))/60)=0

SELECT

You can use the following script to extract all user object permission in a database.

select a.name, d.name+'.'+c.name, b.permission_name, b.state_desc, c.type from sys.database_principals a join

sys.database_permissions b on a.principal_id=b.grantee_principal_id join

sys.objects c...

It is not permission issue since I am running a service account which has local admin permission.

You may want to look at the task manager to dertermine which process is driving the CPU usage on the server.

If it is SQL server that is driving high...