You are a god!

Thank you so much this has been tremendously helpful.

Well I found out why I stopped trying before.  Following the instructions on the Backend Pool creation it says I need to pick an availability set.  The servers where setup...

I tried creating a load balancer but I must have done it wrong, there were steps I missed and I wasn't sure if that was it.  I will follow those...

Thanks Scott.  I think that is the default, it is already set to 0 and I never changed it.

Thank you Scott!  If I am understanding you correctly, I will recreate the tables that have legacy data types and use the TEXTIMAGE_ON syntax to put LOB on a different...

Did not let me attach so here is the code...

SELECT  DISTINCT
OBJECT_NAME(p.object_id),
au.type_desc,
au.filegroup_id,
CAST(ROUND((SUM(au.used_pages) / 128.00), 2) AS NUMERIC(36, 2)) AS Used_MB,
CAST(ROUND((SUM(au.total_pages) - SUM(au.used_pages)) / 128.00, 2) AS NUMERIC(36,...