SQL Server Knowledge Sharing Network (@sqlmaster) : productionhttp://sqlblogcasts.com/blogs/ssqanet/archive/tags/production/default.aspxTags: productionenCommunityServer 2007.1 (Build: 20917.1142)Production version of SQL Server 2005 Service Pack 3 (SP3) is releasedhttp://sqlblogcasts.com/blogs/ssqanet/archive/2008/12/16/production-version-of-sql-server-2005-service-pack-3-sp3-is-released.aspxTue, 16 Dec 2008 11:14:00 GMTfa8c4e8e-46a3-4193-8264-2c1a9cb3475d:11103ssqa.net0http://sqlblogcasts.com/blogs/ssqanet/rsscomments.aspx?PostID=11103http://sqlblogcasts.com/blogs/ssqanet/archive/2008/12/16/production-version-of-sql-server-2005-service-pack-3-sp3-is-released.aspx#commentsOk, you have seen many blog posts out there asking for Service pack 3 for SQL Server 2005 (such as Are you ready for SP3 and SQL2005SP3_WorkStarted , it has been officially announced that the SP3 for SQL Server 2005 (out of CTP) is ready to downlod to...(<a href="http://sqlblogcasts.com/blogs/ssqanet/archive/2008/12/16/production-version-of-sql-server-2005-service-pack-3-sp3-is-released.aspx">read more</a>)<img src="http://sqlblogcasts.com/aggbug.aspx?PostID=11103" width="1" height="1">sql server2005best practicesdownloadservice packproductionsp3SQL Server 2005 Enterprise Edition - make data available while creating indexes on large tables!http://sqlblogcasts.com/blogs/ssqanet/archive/2008/02/25/sql-server-2005-enterprise-edition-make-data-available-while-creating-indexes-on-large-tables.aspxMon, 25 Feb 2008 07:53:00 GMTfa8c4e8e-46a3-4193-8264-2c1a9cb3475d:7788ssqa.net0http://sqlblogcasts.com/blogs/ssqanet/rsscomments.aspx?PostID=7788http://sqlblogcasts.com/blogs/ssqanet/archive/2008/02/25/sql-server-2005-enterprise-edition-make-data-available-while-creating-indexes-on-large-tables.aspx#commentsThough it is not a best practice to perform a CREATE INDEX on large tables during the online hours where you have number of users accessing the metadata of SQL Server database. Within SQL Server 2005 Enterprise Edition you can perform ONLINE indexes operation...(<a href="http://sqlblogcasts.com/blogs/ssqanet/archive/2008/02/25/sql-server-2005-enterprise-edition-make-data-available-while-creating-indexes-on-large-tables.aspx">read more</a>)<img src="http://sqlblogcasts.com/aggbug.aspx?PostID=7788" width="1" height="1">sql server2005serverperformancebest practicesindexclusteredonlineproduction