But use of memory for the recursive solution is not a problem until someone uses that code 40,000 times in an hour!!!!!!

But the first solution can fail, the second...

One of the big problems when we are writing SELECT statement is, that there is not only one solution. And we should choose the right solution to  a given problem....

Why do it in such a complex way. Use recursion, which also is faster in this situation! Tally is only the fastes way if there are MANY, MANY days - not...

It is more easy to use the Sort-task. Use the Check-box 'Remove rows with duplicate sort values'. It is a blocking task, but works fast even with millions of rows! It...

The same rules as for other tables!!! If it is possible - and it will always be possible to alter from VARCHAR(50) to NVARCHAR(100) - then it's also allowed for...

It is not a problem to change datatype from length 50 to 100. But it can be a problem to change from 100 to 50 if a row has a...

Hi,

when you drop a column, the column is also droped in the history table. So you must save the columns data from the history table in another table before you...

It is possible to add a new column, to modify a column and drop a column, while system_versioning is ON!!!

USE master;

GO

DROP DATABASE IF EXISTS TemporalDB;

GO

CREATE DATABASE TemporalDB;

GO

USE TemporalDB;

GO

CREATE TABLE dbo.Person

(

...

It could turn into a big problem at a later date, if a production DB's recovery model is set to SIMPLE. Simple for test and Full for production. Are...

It is wrong to say that the answer is - nothing. It is also wrong to say, that a table is blank. It is - an empty table! Every select-statement...

I agree, that this is poor article. And the article should be removed.

If someone read this article without reading the comments from RK they will have a bad solution after...