View All Posts

 

SSMS

Extended Events

Anatomy of a Select

Change Font XEvent Profiler Processing Order – Part 1
SSMS Options – Part 1   SELECT – Part 2
SSMS Options – Part 2   FROM – Part 3
    JOINS – Part 4
    GROUP BY\HAVING – Part 5

Administration

SQL Agent

Performance

Live Query Execution Plans Missing Job Step Type Get Statistics Info
MDOP vs Cost Threshold for Parallelism   Did the System Create the Stats
Trace Flags: Global vs Session   Optimize for Ad Hoc Workloads
sp_helptext   dm_os_performance_counters and PIVOT
     

TSQL

General Topics

Errors

I am waiting…… Lessons Learned about Blogging Operand Type Clash: Error 206
Table Variable and ROLLBACK    
UNION vs UNION ALL    
DISTINCT and XML    
Pivot and Column Names