Assuming you want to parse out the data - you could use CHARINDEX to find the start positions of each segment and then use SUBSTRING to get the individual values. ...

One of the first things I would do is try to isolate where the report of 'slow' database is coming from.

• Is it slow in the application, if so -...

I responded to this same question on SQL Team.  There is no need for both DISTINCT and GROUP BY - so remove the DISTINCT as it is just going to...

Jeffrey - if only it was that simple.  The individual fields are stored and then the application combines them all together.  The documents are built in "sections" which is...

That leads us back to the question I asked that hasn't yet been answered... before the OP makes any "plans", the first thing that should be done is an...

One thing I have seen a lot is using the *wrong* join...often times I see code that uses a left outer join when an inner join is appropriate.  This will...

Here are 2 references:

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/failover-clustering-and-always-on-availability-groups-sql-server?view=sql-server-ver15#:~:text=Using%20the%20Failover%20Cluster%20Manager,online%20on%20the%20target%20node.

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/prereqs-restrictions-recommendations-always-on-availability?view=sql-server-ver15

In both documents - they expressly state that you should not use FCM to manipulate availability groups - including such things as:

• Do not add or remove...

You can adjust the embedded CSS style-sheet to change the colors of the HTML table, the borders, padding, fonts, etc...

Here is a general template that can be used to include the data in the email:

    Set Nocount On;

Declare @body nvarchar(max)
   ...

I would recommend reviewing the data being populated - and seeing if that data really should be in VARCHAR(MAX) columns.  For example, SNOMED is a code and generally doesn't exceed...

• This reply was modified 5 years, 12 months ago by Jeffrey Williams.

Failover Cluster Manager *cannot* be used to fail over an availability group.  The only method that can be used is SQL - whether from SSMS or through SQL statements.

The reason...

By using the 'wrong' listener - it is entirely possible that AG group is active on node 1 and the other AG group is active on node 2.  In that...

What is their connection string?

And why are they using the wrong listener to access a database?  If using the correct listener works as expected - then they should use that...

Are they connecting to the listener - or directly to the server?  If connecting to the listener - do you have a secondary in that AG set to read-intent?  And...

Thanks! I can't take it offline. Since users want database to be view only mode for a while. So change the db to ready only mode or rename and...