Sign In
SQL Server Premier Field Engineer Blog
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Options
About
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Search
Advanced search options...
Search In:
Everything
Blogs
Forums
People
Groups
Places
Pages
Date range:
All Time
Last Year
Last 6 Months
Last 3 Months
Last Month
Last Week
Last Two Days
Tags
Analysis Services
Database Engine
Replication
Reporting Services
SSIS
Archive
Archives
April 2011
(1)
August 2010
(1)
February 2010
(2)
December 2009
(2)
August 2009
(3)
July 2009
(4)
June 2009
(4)
May 2009
(2)
December, 2009
MSDN Blogs
>
SQL Server Premier Field Engineer Blog
>
December, 2009
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
SQL Server Premier Field Engineer Blog
SQL Server memory models (Part II)
Posted
over 3 years ago
by
sqlpfebl
0
Comments
So what is part II about? It is about a change in Standard 64 bit Editions of SQL Server 2005 and 2008. This change implements the support of AWE APIs and “Lock Pages in Memory” privilege by these editions. It has been already advertised by Bob...
SQL Server Premier Field Engineer Blog
How and Why to Enable Instant File Initialization
Posted
over 3 years ago
by
sqlpfebl
2
Comments
You may want to consider enabling Instant File Initialization (via SE_MANAGE_VOLUME_NAME a.k.a. "Perform volume maintenance tasks") for your SQL Server startup/service account. This option allows for much faster data file allocations (CREATE...
Page 1 of 1 (2 items)