DECLARE @T VARCHAR(300) = 'A_Table_Name' ; DECLARE @C NVARCHAR(4000) = '''--''' SELECT @C = @C + '
,'+COLUMN_NAME FROM information_schema.COLUMNS where TABLE_NAME =...

Not a complete anwser/solution yet, but for readers of this thread and me this might help :

The OUTPUT Clause:
The OUTPUT Clause for UPDATE Statements

See :

https://xkcd.com/327/

This does explain fairly well some of the riscs with your solution.
Ben

SELECT * FROM A
WHERE
EXISTS (SELECT * FROM B)
AND
EXISTS (SELECT * FROM C)

Selects all rows from table...

I was just asked for a job. And was asked if I could help with an overview of some info. Told how I would solve the problem with a simple...

Thanks all, I'll give this a go tomorrow.
I used an auxiliary calendar and picked up all combinations of days of the 28 of February and the 1st of march.
This would...

Is 2014 similar to 1990 because Germany won the FIFA World Cup both years?
Yeah that is ok, your choice.

More obvious would be: Dates fall om the same...

What is the size of the index ?
How many rows are in each index page ? (Average).

For Clustered indexes there are some 'methods' to obtain the position...

--
-- Convert dd/mm/yyyy to a datetime format independend of regional and language settings.
--
declare @datestring varchar(200) = '24/01/2019'
select      substring(@datestring,7,4)+substring(@datestring,4,2)+substring(@datestring,1,2)
select CONVERT(datetime,substring(@datestring,7,4)+substring(@datestring,4,2)+substring(@datestring,1,2))


When sure that...

This looks like the same problem :

https://social.technet.microsoft.com/Forums/WINDOWS/en-US/b4420367-381f-45e5-a5cb-8fd1fb29cbc0/ssms-2016-1641-slow-response-on-object-explorer?forum=sqltools

No solutions, but some workarounds are suggested there,
Ben