They are asking about your experiences and what you faced and how you addressed it. The best thing to do is give that more thought about different challenges you had...

Those are all part of SQL Server and related to how the scheduling of tasks across the CPUs is managed. SQL Server is multithreaded with multiple task assigned to schedulers....

You do change the RSServerconfig file to fix this issue with the rendering extensions when you need to leave the execution account alone. You set the "EXCELOPENXML" visible to false...

That's what I thought as well. I think it works if you still have the synonym StagingSongs from a previous...

Keep in mind you can also create a role for the developers and grant whatever permissions to that role. Deadlocks depends on what it means to troubleshoot - it doesn't...

It really depends and we can only guess without knowing all the details of the archiving process and how the archive database is going to be used. Often, lookup tables...

The following link has a comparison:

SolarWinds Database Performance Analyzer vs SQL Sentry

Sue

Correct. And it doesn't always work as expected so that is something to consider when using readable yes. You can end up connected to the primary depending on where in...

Read-Only Intent requires you to connect with a read only connection by specifying the connection with ApplicationIntent = ReadOnly. When you set the Readable Secondary to Yes, you still connect...

That would be expected behavior when not owning the schema. There are several posts up here with the same type of issue, it's one of those that stumps people fairly...

Another possibility is using xml to work around that issue. It has some "gotchas" - some of the methods you can find in this post:

How do I view the...

I hate that error...it's from when the driver can't figure out what the shape of result set is going to be. Often you can bypass that by including SET FMTONLY...

Anyone with server access isn't able to use DecryptByKey. They need to open the symmetric key to execute DecryptByKey and additional permissions are required to open the symmetric key as...

Also another thought may be memory is probably covering up for other sins? Since the CPU usage is less than 5% could be the memory is more on the...

You would want to look at memory, disk and ram together as changes to one can impact the others. And if you are going to change all of these then...