When you have a process that reads a lot of data, like your ETL, this will flush pages out of memory to hold the reads. As ETL ends, and "normal"...

I'd agree with John.

Fill Factor 0 is the same as 100. If you see lots of page splits, or an increasing amount, then I might lower this, but...

Roads  mostly ok here, though there's a turn on an uphill that constantly gets drifting snow. After I got home, my wife called to say she was stuck there. Towed...

Edit the article, attach the new script. I think you can remove the old one in the editor, but if not, ping the webmaster with the title of the article...

Not sure. I know the release was slow and staggered for patches.

Whacked. And for the record. I still like Python. Glad it's in SQL Server.

I am removing these scripts from the site. There do appear to be a couple instances of plagiarism, though in others there is very little choice in how to gather...

Re: TDE/FDE, and AE. They use different paradigms. They aren't intended to be related.

TDE/FDE are protecting the server, and  loss of the physical assets. In this case, you...

Are all these dbs on the same instance? Or really, do they all use the same certificate to protect the DEK (databsae encryption key)? The DEK is in each TDE...

Hmmm, this is tricky. How did you set this up? I suspect that you really needed to restore the SMK from the primary onto the secondaries and then setup the...

Did you manually recreate them?

the error looks like you have a DMK in Azure without a password, which isn't allowed in an on-premise instance. I exported a DTA from Azure and imported into SQL...