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

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

/* 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

Star Wars Unlimited Resources

Table of Contents

• Rules clarifications from the dev team
  • Set 1
  • Set 2
  • Set 3
• Rules clarifications from FFG via Jonah
• Links to unofficial clarifications
• Links to official resources

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