macfergusson

Rules clarifications from the starwarsunlimited.com card database:

Update dates: 10/31/2025 07/14/2025 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.

Set 6 - Secrets of Power

Academy Disciplinarian

• 10/31/2025 - Abilities that refer to a card’s power include temporary modifiers.

Accelerate Our Plans

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

Star Wars Unlimited Resources

Table of Contents

• Rules clarifications from Ryan Serrano, SWU Rules Admiral
• Rules clarifications from the dev team collected from social media
  • Set 5
  • Set 4
  • Set 3
  • Set 2
• Set 1

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