Further to what Scott has stated - the recompile will occur on the *next* use of the procedure/table and will not affect the currently running process.  It will not affect...

Try this:

 Select stuff((Select char(10) + concat(tel_type.Name, ': ', tel.[Phone Number])
                ...

You can start here (https://visualstudio.microsoft.com/vs/older-downloads/) for Visual Studio - you probably want 2017 if you are working with a 2016 database.  Once you have Visual Studio installed - then go...

First - are you trying to install the database engine, analysis services or integration services on your local machine?  Or - are you just trying to be able to connect...

If you need to identify when a value can be converted successfully but is rounded or truncated then you need to check the value returned from try_cast/try_convert against the original...

It sounds like maybe Service Broker would be an option here.  I think with a service broker it can be setup to call a stored procedure - where you can...

Seem pretty clear - you need administrator access to the servers in the cluster to be able to use cluster manager.

The only other things I can thing of would be the Edition of the local instance or the compatibility mode.

Right-click on 'Failover Cluster Manager' in the left-pane and connect to one of the nodes in the cluster.  If you are remoted into the server - connect to that node,...

It really depends on what the server team is doing...if they are rebuilding the servers then you are going to have to install SQL Server on the new server, add...

There is more than just latency - but in general, yes - the latency between the primary and secondary will affect the availability group regardless of asynchronous/synchronous.

If your availability group...

I mentioned that I ended up in rural West Texas, but I probably should have mentioned that there is a tremendous upside. The cost of living here is dirt...

You can review the AG dashboard - there are 2 queues that you want to look at...the send queue and the redo queue.  The send queue is from the primary...

First - you need to validate that each certificate is the same.  To do that - open the certificate and view the details.  In the details you need to look...

If you need everything in a single row - then yes, you can use charindex and substring, along with reverse...and rtrim/ltrim to eliminate unwanted spaces.

Declare @testTable Table...