Category: Beginner

A Quick Guide to Expanding Database Files and IFI

Post author By Jen McCown
Post date July 26, 2012
Categories In Beginner, sql server, sqlserverpedia-syndication, SSC, TSQL
3 Comments on A Quick Guide to Expanding Database Files and IFI

This is a topic that’s been well covered, but in the interest of spreading good database practices, here’s a very quick note on instant file initialization (IFI) and database files. (As always, you should read the fine print – meaning Microsoft’s documentation – before you do anything on a production system.) Instant File Initialization IFI […]

SQL Server is Smarter Than You

Post author By Jen McCown
Post date December 8, 2011
Categories In Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC
2 Comments on SQL Server is Smarter Than You

I had a brief email discussion recently, which could be effectively be boiled down to: Them: “Are foreign key constraints more performant than referential integrity triggers?” Me: “Yes.” *stomp*stomp*stomp*stomp* “Yes, they are.” Let’s start with a generic statement, and get more specific. Generally speaking: Don’t try to circumvent SQL Server’s primary features. This means that […]

Applied SQL: Demonstrate Simple Backup and Restore

Post author By Jen McCown
Post date October 26, 2011
Categories In Applied SQL, Beginner, sqlserverpedia-syndication, SSC, TSQL
2 Comments on Applied SQL: Demonstrate Simple Backup and Restore

Let’s apply a little backup and restore knowledge, eh wot? I introduce this whole concept in Applied SQL: You Have Homework. Find all assignments on the Applied SQL page. Prerequisites: basic T-SQL, create objects/data, basic understanding of recovery models and backup types. Reading – SQL Server Books Online articles: Backup (Transact-SQL) Restore (Transact-SQL) ALTER DATABASE […]