Staging, warehouse and mart give data loads, trusted history, and focused reporting separate jobs; learn when each layer earns its place.
SQL SERVER – Fillfactor, Index and In-depth Look at Effect on Performance
Where in SQL Server does 100 equal 0? In Fillfactor settings. An in-depth look at how the Fillfactor of an index affects page fill and performance.
SQL SERVER – Difference TempTable and Table Variable – Table Variable in Memory a Myth
Is a table variable in memory while a temp table lives in TempDB? It is a myth: both are created in TempDB, and a simple script proves it.
SQLAuthority News – An Year of Personal Events – A Life Outside SQL
Do I have a life outside SQL? Yes, and it is beautiful. Three photographs from my year of personal events, told with very few words.
SQL SERVER – White Paper – Partitioned Table and Index Strategies Using SQL Server 2008
Ron Talmage’s white paper on partitioned table and index strategies using SQL Server 2008, for loading, removing and maintaining data in very large tables.
SQLAuthority News – Featured on Channel 9
This blog was featured on Channel 9 in This Week on Channel 9, where Scott Hanselman and Jon Galloway talked about my CSV from table column post.
SQL SERVER – ERROR: FIX: Cannot drop server because it is used as a Distributor in replication
Removing replication fails with Cannot drop server because it is used as a Distributor in replication? Two quick commands with sp_dropdistributor fix it.