Solve gaps and islands with LEAD, ROW_NUMBER, and GENERATE_SERIES, then apply the same date patterns to missing days and login streaks.
Cost Threshold for Parallelism and MAXDOP: Setting Both Together
Review cost threshold for parallelism with MAXDOP, inspect NUMA layout and settings, then measure plans and waits after changes.
OPENROWSET vs Linked Servers: Querying Another Server Safely
Compare OPENROWSET and linked servers, inspect login mappings, keep filtering remote, and review authentication and encryption before use.
SQL SERVER – Finding Tables Created Last Week – DBA Tip Part II
Part II of finding tables created last week. Readers asked for an easier way, so here is how to do it from the SSMS user interface without writing a script.
Refactoring Old T-SQL One Procedure at a Time
Begin refactoring old T-SQL with one procedure, repeatable inputs, duplicate-aware result checks, measured reads, and a simple change log.
CXSYNC_PORT and CXSYNC_CONSUMER Waits in Parallel Queries
Investigate CXSYNC_PORT with session wait deltas, parallel plan exchanges and thread rows before testing a query-level MAXDOP change.
SQL SERVER – Story of Temporary Objects
Temp tables, table variables and more: the story of Temporary Objects in SQL Server, why you would use them and how they can help performance and scalability.