My USB drive refused to copy a 15 GB file with a not enough free disk space error. The cause was FAT32 and its 4 GB limit; NTFS has no such limit.
SQL SERVER – Reason for SQL Server Agent Starting Before SQL Server Engine Service
Why is SQL Server Agent starting before SQL Server Engine service? A user group member asked me, and here are my quick reasons, from jobs to OS tasks.
SQL SERVER – Backup master Database Interval – master Database Best Practices
How often should you back up master? It holds logins and server settings, so here are my master database best practices for backup timing.
SQL SERVER – Discussion – Effect of Missing Identity on System – Real World Scenario
Is there any real world reason to list a missing identity in a table? Readers had no new script, but a lively discussion on whether gaps matter.
SQLAuthority News – A Quick Guide to Twitter
Why I am a big fan of Twitter, how micro-blogging in 140 characters works, and a short guide to Twitter for readers who want to follow along.
SQLAuthority News – Interview with SQL Server MVP Glenn Berry
My interview with SQL Server MVP Glenn Berry, Database Architect at NewsGator and longtime SQL Server teacher at University of Denver.
SQL Server – Multiple CTE in One SELECT Statement Query
How do you use multiple CTE in one SELECT statement? Two simple examples: independent CTEs joined together, and a second CTE built on the first.