My worst nightmare has come true.  We upgraded to 2022 and stuff is crawling now.  We turned off Query Store and went back to the old cardinality estimator and...

prevent the accounts to connect to the database.

To differentiate these accounts for this action, create a database user role which you "deny connect"

for your maintenance, you add the accounts...

use powershell dbatools ( free ) copy_dbalogin to copy accounts (including sid) from one AG member to another and avoid these issues.

wat's the isolation level the sproc is called with from the application ?

regarding implicite transactions, it all depends when the application will require its first lock and how...

use "restore filelistonly from disk=youdbackupfile" to check if the file contains backup information for different databases !

or "restore headeronly from disk=youdbackupfile"

Are you sure your databases will only have 2...

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

No.

But it all depends if a new version functionally implements a functionallity your application may need or benifits from.

Keep in mind some of the new stuff in databases have been...

If you're curious about transaction log activity for open transactions, Paul Randal has a script at Script: open transactions with text and plans.

did you actually install SMO for SQL2016 ?

that's because you  don't start from the same set of data due to the "not exists" credential. ( which checks for existance in the target table !! )

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, 11 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 1 year, 11 months ago by Johan Bijnens.