Viewing 15 posts - 1 through 15 (of 54 total)
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....
March 17, 2023 at 2:04 pm
Thanks, it is very useful!
January 26, 2023 at 3:19 pm
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)
November 21, 2022 at 4:57 pm
didn't show Maintenance Plans & Remote Maintenance Plans
September 12, 2022 at 3:29 pm
PARSENAME system functions is deterministic per http://www.informit.com/articles/article.aspx?p=21329&seqNum=6 link
November 19, 2018 at 9:02 am
if you are using the SQL module you can use $db.RecoveryModel = "Full", right?
January 9, 2018 at 10:05 am
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...
November 14, 2017 at 10:23 am
CREATE TABLE TableTest1 (
ID INT NOT NULL,
CONSTRAINT PK_ID1 PRIMARY KEY(ID)
);
CREATE TABLE #TableTest2 (
ID INT NOT NULL
CONSTRAINT FK_TableTest1_ID FOREIGN KEY (ID) REFERENCES TableTest1(ID)
);
INSERT INTO TableTest1 (ID)
VALUES
(1);
INSERT INTO #TableTest2 (ID)
VALUES
(2);
select * from...
August 16, 2016 at 8:00 am
Viewing 15 posts - 1 through 15 (of 54 total)