Ashlin Ferguson macfergusson

Star Wars Unlimited Resources

This content collected and curated for the SQL Discord, join us!

	USE ReportServerDB

	IF OBJECT_ID('tempdb..#ResultsTable') IS NOT NULL
	DROP TABLE #ResultsTable;

	CREATE TABLE #ResultsTable (
	ReportID UNIQUEIDENTIFIER NOT NULL
	,ReportName NVARCHAR(425) COLLATE Latin1_General_CI_AS_KS_WS NOT NULL
	,ReportPath NVARCHAR(425) COLLATE Latin1_General_CI_AS_KS_WS NOT NULL
	,SubreportName NVARCHAR(256) COLLATE Latin1_General_CI_AS_KS_WS NOT NULL

	/* script out indexing */

	SELECT ' CREATE ' +
	CASE
	WHEN I.is_unique = 1 THEN ' UNIQUE '
	ELSE ''
	END +
	I.type_desc COLLATE DATABASE_DEFAULT + ' INDEX ' +
	I.name + ' ON ' +
	SCHEMA_NAME(T.schema_id) + '.' + T.name + ' ( ' +

	My impressions, these should be taken with a grain of salt, and some of it may be outdated since I haven't played everything in the current patch.

	For high end mythic raid comps, there is more space for ranged DPS than melee DPS due to the need for very specific roles to be filled, leaving a lot less flexibility in who they bring.
	If you're not in the Race to World First happening right now, this doesn't really apply to you.
	If you're focusing on normal or heroic, or maybe lightly approaching mythic raiding, being good at any DPS spec is the real requirement.

	ST: Single Target
	AOE: Area of Effect/multi target/cleave.
	HoT: Heal over Time
	DoT: Damage over Time AKA bleed/disease/damage dealing debuff.