RSS

[SQL Snacks Video] The What, Why, and How of Instant File Initialization with SQL Server

11 Feb
[SQL Snacks Video] The What, Why, and How of Instant File Initialization with SQL Server

Instant File Initialization (IFI) is an interesting topic with regards to how SQL Server works with storage. It is an easy feature to turn on and can improve the performance of your server; specifically with creation and growth of data files including TempDB rebuilds with SQL Server restarts.  There is a slight security risk where a professional data thief could potentially recover bits of data that have not been over written since IFI was turned on, but the chances of that happening are slim.  Plus, if they have physical access to the hard drives on your server, you will have bigger problems to fix.

So without further ado here is the next delicious SQL Snack for Instant File Initialization:

 

Tags: , , ,

3 responses to “[SQL Snacks Video] The What, Why, and How of Instant File Initialization with SQL Server

  1. stay strong girl quotes tumblr

    June 8, 2015 at 1:09 PM

    Standardized testing has both positive and negative aspects and when used effectively can play a significant
    role in bettering the education of our students.
    Here are some ways by which you will get when you decide
    early garage door repair:. Use these Lord of the Flies important quotes from chapter 1 to enhance your understanding
    of the novel.

    Like

     

Leave a comment