I'd expect the restore time to generally be longer; if restoring to a new database, potentially significantly longer.

For a backup, SQL only needs to backup the active portion of the...

You could create a separate "key master" table, containing only an identity column and the four natural key columns, clustered on the natural key columns, NOT the identity.

Then, the first...

Use view "sys.dm_db_index_operational_stats".

Capture the values at the start time, then recapture them at any subsequent time, subtract the two values, and voila, you have the mods that occurred during that...

I'm not sure why you would want to insert all iterations of the list of values into the countryid table, but this should fix a couple of the potential errors...

IIRC == "If I recall correctly" == hedge in case I'm wrong 🙂

For more info on Change Tracking...

CDC could do it too, of course, but it has more overhead and is available only in Enterprise Edition; it's overkill for what you've described you need.

Change Tracking should handle your situation easily and completely. IIRC, CT requires that the table have a PRIMARY KEY defined.

Of course not all CTEs are going to be updateable, it will depend on the specific coding of the CTE ;-).

You don't have to use two ROW_NUMBER() clauses/entries:

;WITH detail AS (

SELECT *, ROW_NUMBER() OVER (ORDER BY id) AS row_num

FROM #test

)

SELECT

...

I don't think that's right. I think SQL uses data...

I don't understand the totaling logic you want.

"TOTAL 700"?? Is...

I think so, but I couldn't swear to it. I think the differential bitmaps are restored as-is with the db, and not reset, but I'm not 100% sure. ...

That shouldn't really be necessary, assuming you still have the backups you used to do the...

MAX(age) seems safe enough -- no one gets any younger :-).

Combining MIN(name) and MAX(name) would allow one name change ... that should handle everyone, right!?

/*

insert into #temp(id,name)

select 2,'Jane Single'

insert into...

No, but I do know that you're never supposed to remove the Guest account from master. Basically SQL requires it. Put it back and try again before making...