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...

We are always going to have 'bad data', and we should be helping to set user expectations about its reliability. This could be difficult for some users to cope...

I suggest you use the most recent training material you can find.

There is very little that was in SQL 2012 that is not in SQL 2016, the main...

What kevaburg says works on all versions of SQL Server above SQL 2005 (it probably works on SQL2005 but I have not tested it there).

You can also use this technique...

When I left school in the early 1970s, almost 40% of kids my age struggled to get good grades at the age 16 exams. The UK Government statistics show...