SQLPASS Day 2- Optimization Timeouts and All about TLogs
Category:
query-performance
SQLPass unfortunately can’t last forever, but happily it’s still going strong. Here’s some highlights from my Day #2.
Tag: optimizer
How Stale are my Statistics?
Category:
performance-tuning
Update: improved/more recent version of queries for this are here.
It can be pretty difficult to manage statistics in data warehouses, or even OLTP databases that have very large tables.