It depends!

It would be more helpfull if you posted DDL for all involved objects.

... convert( desired_date_type, DATABASEPROPERTYEX(DB_NAME(), "LastGoodCheckDbTime")) ...

I've modified your script a little bit to be more informative :

CREATE TABLE #lastcheckdb 
  (
  DbName sysname,
  Updateability...

• This reply was modified 1 year, 12 months ago by Johan Bijnens.

Maybe not the most performant solution but as a next step import the full file and process it

$FullfileData = import-csv -Path $fullfile ;

$RecCounter = 0;
$TargetFileNo = 1;
$TargetFiletemplate...

As stated by the previous repliers, you must size your tempdb file(s) to be able to cope with your systems consumptions!

Things that may help out :

- grant your service account...

There are some red fags over here, especially with "just implementing partitioning in production"!

• 24/7
• 1h downtime / year

You need to prepare for this all !! As jeff statted, it...

Have a look at Grants page on the topic: Why You Should Change the Cost Threshold for Parallelism

• This reply was modified 2 years ago by Johan Bijnens.

Add the use of your database to your script. Chances are you are working in context of master database !

CREATE DATABASE dbsubjects;

USE dbsubjects;

CREATE TABLE tblstudent(...

Don't start your partitioning adventure in production !

Read this thoroughly : https://www.sqlservercentral.com/forums/topic/partition-large-tables-needed#post-4292250

ref Partitioned tables and indexes

ref Create partitioned tables and indexes

ref SQL Server Partitioning: Getting Started

You can create different filegroups and different files on AzureSQLMI, you just cannot provide it with a filename !

Read Jeff's advice thoroughly!

Then decide...

Server side trace will have the least impact.

Have  look at the included sql file.

It needs a table in your DBA database. ( see script )

It creates 3 SQLAgent job:

1. DBA_SQLTrace_7Zip...

• You have not mentioned the version of the original SQL Server instance.
• For instances that do not support extended events, we used a (random) sampling methode to get a...

Have you tested that ?

CREATE DATABASE [MyPtDbOnSQLMI]
 CONTAINMENT = NONE

GO

ALTER DATABASE [MyPtDbOnSQLMI]...

Have you taken a look at this: Configure backups on secondary replicas of an Always On availability group

or this ( and the following ): Understanding backups on AlwaysOn...

Did we mention that autogrow should never be in percentages !  ( as the size of the growth gets larger every time it is executed )

If want to enable autogrowth,...

Yes !

ref: Database instant file initialization