Tag Archives: Internals

Why NULL Placement Matters

A look at how understanding where to place columns with NULL values can make a difference in I/O requests. Continue reading

Posted in Internals | Tagged | 7 Comments

Database Growth

An experiment to confirm that a SQL Server database will grow in increments specified by the auto growth settings. Continue reading

Posted in Administration, Internals | Tagged | 4 Comments

Detaching a Database – File Security Gotcha

A look at what happens to file permissions when you detach a database with an active directory or machine user account. Continue reading

Posted in Administration, Internals | Tagged , | 5 Comments

Procedure Creation – Correct Syntax, Wrong Database

A brief look at why a procedure is created even with a reference to an object that isn’t valid. Continue reading

Posted in Administration, Internals, T-SQL | Tagged , | Leave a comment

Database Restores – Zeroing Out Log Files

A look at what happens the log file when the database is restored. Continue reading

Posted in Administration, Internals | Tagged , | Leave a comment

Compatibility Level vs Database Version

A look at the difference between compatibility mode and the database version. Continue reading

Posted in Internals | Tagged , | 20 Comments

Query Optimizer Wins Again

A quick look at why the Query Optimizer was correct in stopping me in my tracks. Continue reading

Posted in Internals, T-SQL | Tagged , , | Leave a comment