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.
- 46130

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

How to find the last time a database was used?
Matthew_DBA 4 hours 29 minutes ago - 213

what kind of constructs make optimizer not estimate cardinality?
George Zhou 56 minutes ago - 253

Problems installing WebMatrix Apps
ladydee123 21 hours 28 minutes ago - 011

Error when checking the back up file corrupted or not
srisql 41 minutes ago - 13154

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

Bulk Insert from a filestream
Foleide. _ 3 hours 29 minutes ago - 537

log can be backed up while database in process of being restored?
George Zhou 2 hours 54 minutes ago - 117

why and what are the memoryclerk, memory broker, query memory objects logs?
George Zhou 2 hours 3 minutes ago - 10107

About sys.dm_os_memory_nodes
Gokhan Varol Tuesday, May 22, 2012 3:15 AM - 427

restore database with norecovery, move full and differential, move required for differential too?
George Zhou 3 hours 8 minutes ago - 223

Difference between SET PARAMETERIZATION FORCED and sp_configure 'optimize for adhoc workloads'
abczxxxxx 4 hours 28 minutes ago - 115

when open job properties get Timeout error, tried a minute later, opened fine, what are possible reason
George Zhou 2 hours 1 minutes ago - 259

Error converting data type varchar to numeric. -sql`
kiranshiva 21 hours 4 minutes ago - 259

how to use SQL Server Profiler to determine which SET option changed
George Zhou Tuesday, May 22, 2012 3:25 PM - 8172

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

"A time-out occurred while waiting for buffer latch" error
Juantana 4 hours 15 minutes ago - 324

Disable Allow Inprocess option of Linked server provider
geertDCOD 4 hours 12 minutes ago - 121

SQL 2005 blocking report
rick_806 3 hours 53 minutes ago - 8138

Performance difference with separate explicit transactions
Stephen Archbold Tuesday, May 22, 2012 7:51 AM

