Seven base SQL Servers used for the web application:
3 – Clustered, SQL 2005 SP3 Enterprise edition
2 – Clustered, SQL 2005 SP3 Standard edition
2 – Stand Alone, SQL 2005 SP3 Standard edition
Three Log Shipping SQL servers:
1 – Clustered, SQL 2005 SP3 Enterprise edition
2 – Stand Alone, SQL 2005 SP3 Standard edition
One Utility Clustered Standard edition:
1 – [...]
SET CONCAT_NULL_YIELDS_NULL OFF
SELECT weighted_cost = avg_total_user_cost * avg_user_impact * (user_seeks + user_scans),
s.*,
'CREATE INDEX IX_' +
REPLACE(REPLACE(COALESCE(equality_columns, inequality_columns), '[', ''), ']', '') +
' ON ' + d.statement + '(' + COALESCE(equality_columns, inequality_columns) +
CASE WHEN equality_columns IS NOT NULL
THEN
CASE WHEN inequality_columns IS NOT NULL
THEN ', ' + inequality_columns
END
END + ')' +
CASE WHEN included_columns IS NOT NULL
THEN ' INCLUDE [...]
