This is an interesting post I came across by Saleem Hakani. I have not tested it yet.
It promises to reduce the time for
Creating a database
Expand data files for additional growth
Automatic data file growth due to auto-grow settings
Restoring a database, etc.
http://sqlcommunity.com/SQL-ARTICLES/Post/1514/SQL-Server-File-Operations-on-Steroid”

Advertisements

About parag waghmare

I am working on the Windows technologies for a long time now. Primarily working as a Service Engineer on System Center products. Right now on System Center 2012 and Windows Server 2012. I have worked extensively on MOM 2005 to SCOM 2007 migrations and SCOM 2007 to SCOM 2012 migrations.
Link | This entry was posted in Microsoft SQL Server and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s