by Glen Berry Day 1 (Westmere-EP)Day 2 (Westmere-EX)Day 3 (AMD Opteron 6100)Day 4 (AMD Bulldozer)Day 5 (Hardware ID – DMVs)Day 6 (Hardware ID – Built-in)Day 7 (CPU-Z)Day 8 (Recommended Intel Processors)Day 9 (Recommended AMD Processors)Day 10 (Old Intel Processor Numbering)Day 11 (New Intel Processor Numbering)Day 12 (AMD Processor Numbering)Day 13 (Intel Turbo Boost)Day 14 (Intel …
di Jonathan Kehayias (1 of 31) – An Overview of Extended Events(2 of 31) – Querying the Extended Events Metadata(3 of 31) – Managing Event Sessions(4 of 31) – Querying the Session Definition and Active Session DMV’s(5 of 31) – Targets Week – ring_buffer(6 of 31) – Targets Week – asynchronous_file_target(7 of 31) – Targets …
Una interessante panoramica sulle funzionalità del SQL Server Management Studio scritta da Russ Thomas. Day 1: Knowing Options Leads to ShortcutsDay 2: Query Like a ProDay 3: Query Like a BossDay 4: Query Like a GodDay 5: Generating Scripts (pre-written code 1)Day 6: Leveraging Templates (pre-written code 2)Day 7: Leveraging Snippets (pre-written code 3)Day 8: Debugging T-SQL with …
di Paul Randal (1/30) in-flight transactions continue after a failover(2/30) DBCC CHECKDB causes blocking(3/30) instant file initialization can be controlled from within SQL Server(4/30) DDL triggers are INSTEAD OF triggers(5/30) AWE must be enabled on 64-bit servers(6/30) three null bitmap myths(7/30) multiple mirrors and log shipping load delays(8/30) unicorns, rainbows, and online index operations(9/30) data …