I hope no-one minds me saying this, but 'large disks or many disks' already seems a yesterday question.
If you are in the cloud then you have the option of...

From the OP it sounds like you are uninstalling and reinstalling SQL Server on the same OS.  This just seems a weird thing to do as it is hard to...

We use SoftPerfect RAM drive to host tempdb.  So far we have not seen tempdb filling up but it is a risk whenever you use a ram drive to host...

Old software is going to stay old software for a long time.  A few lucky organisations will be able to move their applications to new software, but most places will...

I can easily see that a SQL Server DBA used to Windows has little interest in looking at SQL Server on Linux. Nothing is broken in Windows so why...

If percussive maintenance doesn't fix the problem, gravitational maintenance is known to work.

In all of this, always be polite and courteous with whoever you deal with. You are a professional and you need to always be seen to act like one.

The...

What type of access are you getting for PatientOrder and TherapyAdmin? This can affect how the optimiser might access AdminObservation. Please post the plan.

As already said, the DDL and plan is really needed to give the best answer.

However, the index suggested by Luis is guaranteed to require a clustered index lookup to satisfy...

Have you looked at what you can do with Windows 2016. The Windows side of hyper-convergence capability has been...

We currently use https://www.softperfect.com/products/ramdisk/ to host the Windows \Temp folder and tempdb. It should also be possible to create a RAM Drive natively within W2012 and above with...

Why do you want to find out this information. What are you planning to do if you have these details?

I would certainly like to see SQL Agent Jobs get a bit more development, and being able to maintain jobs at the DDL level sounds like the best way to...

Yes. If Windows...

There are plenty of people who have shown that in-place upgrade from SQL2005 to SQL2016 is not possible, but even if it was why would you want to do it?

The...