SQL Server Database Engine
Any questions or discussions relating to the SQL Server Database Engine, performance, features, Full-text Search, linked servers, etc.
Announcements
SQL Server 2008 SP1 released
Ed Lehman Wednesday, April 08, 2009 6:18 PMService Pack 1 for SQL Server 2008 is now available for customers. The Service pack is available via download at http://www.microsoft.com/downloads/en/default.aspx and is primarily a roll-up of previous cumulative updates, quick fix engineering updates and minor fixes made in response to requests reported through the SQL Server community. While there are no new features in this service pack, customers running SQL Server 2008 should download and install SP1 to take advantage of the fixes which increase supportability and stability of SQL Server 2008.
Customers have no reason to wait to upgrade to SQL Server 2008 and many are already taking advantage of SQL Server 2008 as a smart IT investment. In fact, there have been over 3 million downloads of SQL Server 2008 since the RTM in August. With this Service pack, Microsoft is introducing 80% fewer changes to customer configurations compared to previous SQL Server Service Pack releases. This remarkable decrease is a testament to a revised product development process and updated servicing strategy that is focused on ease of deployment while keeping customer environments stable.
With this service pack, Microsoft has made investments to ease deployment and make management of service packs more efficient. Key improvements in SP1 include Slipstream, Service Pack Uninstall and Report Builder 2.0 click-once deployment.
· Slipstream allows administrators to install SQL Server 2008 and Service Pack 1 in a single instance. This decreases the total time for an installation, including a fewer number of reboots thereby increasing productivity and deployment availability.
· Service Pack Uninstall allows administrators to uninstall the service pack separately from the database release. This feature also improves DBA productivity, reduces the cost of deployment and improves overall supportability
· Report Builder 2.0 Click Once improves the existing SQL Server end-user report authoring application by easing deployment to business users
To download the SQL Server 2008 Service Pack 1, please click here.
For more information on SQL Server 2008, please click here.
Filtering and SortingUse these options to narrow down the question and discussion list.
- 46146

"how to ask a question" guideline to our forums
Stephanie LvMicrosoft Contingent StaffTuesday, October 18, 2011 5:49 AM - 241

Same SELECT Statement Running on Two SQL Server Instances Yields Significantly Different Performance
SQLServerSam 5 hours 17 minutes ago - 7121

Fragmentation 8kb to 16 kb
subu999 12 hours 35 minutes ago - 3144

encryption at database level for TFS
asksome Wednesday, May 23, 2012 9:23 PM - 266

memory use drops on SQL Svr 2005 Windows 2003 SP2 (64bit)
rick_806 7 hours 44 minutes ago - 5109

Network Latency in sql server
SQLmaddy 10 hours 49 minutes ago - 056

The execution of a full-text query failed. "The device is not ready."
Rubens Arandas 7 hours 40 minutes ago - 2227

Is there a way through the system tables or through the internal stats to calculate the growth expectancy of a table?
lcerni Friday, May 18, 2012 1:21 PM - 6131

SQL Server 2005
butter17 17 hours 13 minutes ago - 391

DBCC LOGINFo and Backup Log
ManishKumar1980 11 hours 43 minutes ago - 174665

SQL 2008 R2 - constantly crashing!
LaszloPuskas Wednesday, October 06, 2010 8:20 PM - 283

System Databases Management
AmirBabazadeh 12 hours 27 minutes ago - 8135

MDF files grew after running MSSCOMPRESS page compression on SAP Database
Kal Saeed Wednesday, May 23, 2012 6:46 PM - 23471

SEEKING BASIC INFO ON SQLAgent - TSQL Jobstep type program_name(s)
randyvol Friday, May 16, 2008 12:49 PM - 1111

Why Snapshot isolation level selected When my DB has Read committed
Shamas Saeed 20 hours 4 minutes ago - 5137

SQL Svr 2005 sp_spaceused invalid data returned
rick_806 Tuesday, May 22, 2012 6:37 PM - 32432

Problem in Scripting of Tables and Indexes through Object Explorer
gayathri.varadarajan Wednesday, February 25, 2009 6:47 AM - 11263

multiple step ole db operation generated errors MDT2012
Roel_85 Monday, May 21, 2012 7:17 AM - 14268

SQL Server Performance Investigation
runnerpaul Tuesday, May 22, 2012 8:11 AM - 3122

"A time-out occurred while waiting for buffer latch" error
Juantana Wednesday, May 23, 2012 1:27 PM

