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
    Optimize for Ad Hoc Workloads
     

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