https://learn.microsoft.com/en-us/sql/ssma/sql-server-migration-assistant?view=sql-server-ver15

Migrate to SQL Server 2022 (16.x)

You can migrate databases from older versions of SQL Server to SQL Server 2022 (16.x), as long as the source database compatibility level is 90 or higher....

Thanks, it is very useful!

this system table may give diff. date time.

SELECT DATEADD(SECOND, -sample_ms/1000, GETDATE()), *

FROM sys.dm_io_virtual_file_stats ( 1,1)

or

SELECT DATEADD(mi, -sample_ms/1000000, GETDATE()), *

FROM sys.dm_io_virtual_file_stats ( 1,1)

• This reply was modified 2 years ago by  chgn01.

https://docs.microsoft.com/en-us/sql/relational-databases/logs/open-log-file-viewer?view=sql-server-ver16

didn't show Maintenance Plans & Remote Maintenance Plans

Right, very interesting!

numpy.zeros(shape=(0,0)) also works

<p id="ULjlONK"></p>

<p id="ULjlONK"></p>

PARSENAME system functions is deterministic per http://www.informit.com/articles/article.aspx?p=21329&seqNum=6 link

what SQLServer[1][1:5] will return?

if you are using the SQL module you can use $db.RecoveryModel = "Full", right?

run the script in sql2012 or sql2016, first time it return 2; run 2nd time it return 10.
but if you run this:

SET LANGUAGE British
DECLARE @RunDate...

!