Ashlin Ferguson macfergusson

SQL Community Discord Resource List

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

Update dates: 03/06/2025 03/05/2025 10/31/2024 07/22/2024 07/16/2024 03/01/2024

These dates are the dates that a batch of updates have been made. Use Ctrl + F to search for updates made on that date.

03/06/2025 - If the defender is defeated during an attack before combat damage is dealt, all combat damage is considered excess damage for Overwhelm.
03/06/2025 - Shields prevent all damage from a unit with Overwhelm. There is no excess damage since the defender is not defeated.

	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.

	/* 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 + ' ( ' +

	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