macfergusson

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

macfergusson

Rules clarifications from the dev team:

• Regional Governor applies to multiple versions of units with the same name...
• ...but a partial name is insufficent to cover multiple names
• Overwhelm has no excess damage against Chirrut
• Strafing Gunship opposing a space Sentinel can only attack Sentinels on Ground or Space arena
• Friendly refers to controller, not ownership
• Ambush and Sneak Attack do not stack
• Controller of upgrades
• Spark of Hope does not work with units that were defeated as resources
• [Pre Visla stealing Entrenched while attacking a ba

macfergusson

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

macfergusson

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.

macfergusson

SQL Community Discord Resource List

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

Table of Contents

• Share Code
• SQL Tutorials and Study Courses
• SQL Challenges
• Other Coding Challenges
• Diagramming and Normalization