Read committed doesn’t guarantee much…

Posted on: April 17, 2018 12:05 pm

SQLskills SQL101: Running out of ints and bigints

Posted on: October 3, 2017 8:39 am

SQLskills SQL101: How can a SELECT cause a database to change?

Posted on: May 31, 2017 12:28 pm

Leaving the Land of Confusion…

Posted on: February 17, 2011 7:56 am

Myths and misconceptions: 60-page PDF of blog posts

Posted on: October 19, 2010 5:39 am

T-SQL Tuesday #11: Misconceptions about…. EVERYTHING!!

Posted on: October 12, 2010 11:34 am

Benchmarking: Introducing SSDs (Part 1: not overloaded log file array)

Posted on: May 6, 2010 3:01 pm

A SQL Server DBA myth a day: (30/30) backup myths

Posted on: April 30, 2010 9:19 am

A SQL Server DBA myth a day: (29/30) fixing heap fragmentation

Posted on: April 29, 2010 8:22 am

A SQL Server DBA myth a day: (28/30) BULK_LOGGED recovery model

Posted on: April 28, 2010 2:28 am

A SQL Server DBA myth a day: (27/30) use BACKUP WITH CHECKSUM to replace DBCC CHECKDB

Posted on: April 27, 2010 3:23 pm

A SQL Server DBA myth a day: (26/30) nested transactions are real

Posted on: April 26, 2010 11:03 am

A SQL Server DBA myth a day: (25/30) fill factor

Posted on: April 25, 2010 9:51 am

A SQL Server DBA myth a day: (24/30) twenty six restore myths

Posted on: April 24, 2010 8:42 am

A SQL Server DBA myth a day: (23/30) lock escalation

Posted on: April 23, 2010 12:14 pm

A SQL Server DBA myth a day: (22/30) resource governor allows IO governing

Posted on: April 22, 2010 4:37 pm

A SQL Server DBA myth a day: (21/30) corruption can be fixed by restarting SQL Server

Posted on: April 21, 2010 5:44 pm

A SQL Server DBA myth a day: (20/30) restarting a log backup chain requires a full database backup

Posted on: April 20, 2010 1:24 pm

A SQL Server DBA myth a day: (19/30) TRUNCATE TABLE is non-logged

Posted on: April 19, 2010 11:57 am

A SQL Server DBA myth a day: (18/30) FILESTREAM storage, garbage collection, and more

Posted on: April 18, 2010 10:22 am

A SQL Server DBA myth a day: (17/30) page checksums

Posted on: April 17, 2010 2:01 pm

A SQL Server DBA myth a day: (16/30) corruptions and repairs

Posted on: April 16, 2010 1:55 pm

A SQL Server DBA myth a day: (15/30) checkpoint only writes pages from committed transactions

Posted on: April 15, 2010 1:05 pm

A SQL Server DBA myth a day: (14/30) clearing the log zeroes out log records

Posted on: April 14, 2010 6:07 am

A DBA myth a day: (13/30) you cannot run DMVs when in the 80 compat mode (T-SQL Tuesday #005)

Posted on: April 13, 2010 10:40 am

Important things for DBAs to consider

Posted on: April 12, 2010 4:31 pm

A SQL Server DBA myth a day: (12/30) tempdb should always have one data file per processor core

Posted on: April 12, 2010 8:28 am

A SQL Server DBA myth a day: (11/30) database mirroring failover is instantaneous

Posted on: April 11, 2010 7:16 am

A SQL Server DBA myth a day: (10/30) database mirroring detects failures immediately

Posted on: April 10, 2010 5:52 am

A SQL Server DBA myth a day: (9/30) data file shrink does not affect performance

Posted on: April 9, 2010 6:54 am

A SQL Server DBA myth a day: (8/30) unicorns, rainbows, and online index operations

Posted on: April 8, 2010 7:24 am

A SQL Server DBA myth a day: (7/30) multiple mirrors and log shipping load delays

Posted on: April 7, 2010 6:54 am

A SQL Server DBA myth a day: (6/30) three null bitmap myths

Posted on: April 6, 2010 8:28 am

A SQL Server DBA myth a day: (5/30) AWE must be enabled on 64-bit servers

Posted on: April 5, 2010 11:10 am

A SQL Server DBA myth a day: (4/30) DDL triggers are INSTEAD OF triggers

Posted on: April 4, 2010 10:36 am

A SQL Server DBA myth a day: (3/30) instant file initialization can be controlled from within SQL Server

Posted on: April 3, 2010 1:57 am

A SQL Server DBA myth a day: (2/30) DBCC CHECKDB causes blocking

Posted on: April 2, 2010 4:55 am

A SQL Server DBA myth a day: (1/30) in-flight transactions continue after a failover

Posted on: April 1, 2010 10:32 am

Misconceptions around database snapshots and transaction rollbacks

Posted on: January 7, 2010 11:03 am

Why you should not shrink your data files

Posted on: June 24, 2009 10:02 am

Misconceptions about running DMVs on databases with lower compatibility levels

Posted on: June 16, 2009 12:30 pm

Misconceptions around the log and log backups: how to convince yourself

Posted on: May 29, 2009 11:09 am

Misconceptions around database repair

Posted on: May 15, 2009 5:02 pm

Misconceptions around adding columns to a table

Posted on: May 6, 2009 3:38 pm

Misconceptions around FILESTREAM storage

Posted on: May 6, 2009 1:47 pm

Misconceptions around corruptions: can they disappear?

Posted on: May 5, 2009 8:30 am

Misconceptions around null bitmap size

Posted on: May 4, 2009 2:47 pm

Misconceptions around TF 1118

Posted on: April 23, 2009 9:19 pm

Misconceptions around instant file initialization

Posted on: March 10, 2009 11:51 am

Search Engine Q&A #19: Misconceptions around index rebuilds (allocation, BULK_LOGGED mode, locking)

Posted on: June 8, 2008 5:12 pm