Skip to content

sqlsunday.com

  • About
  • Structured Concepts
    • Master data tool
    • OAuth wizard
    • Send passwords
  • Presentations
  • Downloads
  • Checklists
    • Installing SQL Server 2014
    • Installing SQL Server 2016
    • Installing SQL Server 2017
    • Installing SQL Server 2019
    • Installing SQL Server 2022
    • Conference organizer tools
    • Conference organizer checklist

Tag: perform volume maintenance tasks

Instant file initialization

When you create (or grow) the size of a database file, SQL Server will initialize the allocated space on the disk, i.e. fill it with zeroes. If you’re adding a large amount of space to your database file, this operation can take quite some time to complete. But just like there’s a “quick format” in most operating systems, you can allocate large chunks of database file space without initializing it. This is called “Instant file initialization” in the world of SQL Server.

Continue reading Instant file initialization
Published 2013-10-13
Categorized as Intermediate, SQL Server concepts, Tips Tagged disk, file initialization, instant, perform volume maintenance tasks, performance, permission, policy, security, service account
sqlsunday.com
Proudly powered by WordPress.