the replication snapshot should not be bigger than the database itself; at least it never happened to me.

the snapshot unc path(...\MSSQL\ReplData) may be on a different drive(say C:\) from your...

You should be able to uninstall if you have to. I don't think there is much left after in-place upgrade. SQL server engine, SSAS, SSRS, etc should all be upgraded,...

In my opinion, based on the answer, "an RTO of 15 minutes can be met by log backups every 15 minutes", it's more of an RPO, NOT RTO. log backup...

thank you, Brian, good to know the benefit of using CTE and temp table together. I sometimes convert table variable to temp table due to very bad performance issue.

thank you for sharing, it's a very good starting point. I changed a lot to use CTE only instead of using both CTE and temp table. I also added an...

thank you, Grant and Frederico_fonseca. On cluster is still on virtual, performance on VM is acceptable and it's not the issue. The main reason is the cost: double SQL server...

this model, Proliant DL360 Gen10, supports 2 processors, with up to 28 cores per processor, so, 36 is the # of cores, before hyperthreading.

true, 36 cores x $7,000 = $252,000, a quarter million for one node, plus SA, about 25% of licensing, or $63,000 per year.

Microsoft used to provide drivers to DB2(and Oracle), if that's for older version, IBM should provide recent driver for this since it's IBM's database. Google DB2 OLEDB driver, good luck.

If possible, I suggest using the same version of Oracle Data Access Components (ODAC) on SQL2016 as you did for SQL 2014. ODAC 12.2 release have some very nasty bugs,...

SSRS 2019 is part of SQL 2019, there is no separate licensing for SSRS, bu it requires SQL 2019 license, ie, SSRS 2019 standard requires SQL 2019 standard or enterprise...

thank you for the data. Theoretically, it's slower; based on my software development experience, web application does not fetch 1,000,000 or even 10,000 rows to the front end. I was...

I usually don't accept a method claimed to be "most efficient" without data to support. More importantly, I don't like your tone. Could you please not use words like below?

>>...

sterling3721 wrote:function stuff can achieve this.

You may be right, but it's certainly not obvious how you would use it without hard-coding values.  Would you care to elucidate?

Drew

this is a very...

function stuff can achieve this.