Are you logging in with a SQL Server login or are you using Windows Authentication? If you are using a SQL Server login (which would throw the error you're seeing...

You've basically hand-coded a DENSE_RANK() ... WHERE MAX(<DENSE_RANK() value>) = 2. The sample data will help roll a query to test, but you'll likely find a similar query plan with...

Just treat the href value as an attribute of the <a/> element, instead of turning the entire element into a string:
DECLARE
@URL varchar(100),
@GetData nvarchar(MAX)
SET @URL...

Because each index in each object may be on a separate filegroup or partition scheme, drive your query off of sys.indexes, and join the data_space_id column to sys.filegroups.data_space_id.
Here's one...

So, you want numeric values greater than (-100) and less than 100:
CREATE TABLE #testr (id int not null primary key, OrigVarchar varchar(7) NOT NULL);
GO

INSERT...

You give yourself far more flexibility by creating a single Windows Failover Cluster out of all four servers, and installing both FCIs on each of them. Are there any security...