Categoria: SQL Server

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 …

Leggi tutto “31 days with SQL Server Management Studio”

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 …

Leggi tutto “A SQL Server DBA myth a day”