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 LehmanMSFTWednesday, 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.
- 125

WHERE clause
truelyli 1 hour 33 minutes ago - 4130

nvarchar(max) or nvarchar(2048)
Chui Kean Friday, October 30, 2009 4:36 AM - 911542

SQL Server 2005 Workgroup - Performance counter shared memory setup failed
errpop Monday, November 28, 2005 9:00 PM - 162

PUBLIC role is missing in SQL Server 2005
Kiran Kumar Raju 20 hours 7 minutes ago - 362

Help! - sql server service stuck in "stopping" state
Chino2kuk Saturday, November 07, 2009 9:29 AM - 288

index fragmentation and maintenance paln
safddddddddddddddddddddd Friday, November 06, 2009 11:30 PM - 159

I want to lock mdf file.
kunal s jhaveri Saturday, November 07, 2009 6:06 AM - 10150

What happens if we truncate a log file
Karenros Thursday, November 05, 2009 8:42 PM - 1948711

Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path
Souhil Benammour Wednesday, November 30, 2005 5:41 PM - 6142

sql server ...fragmentation after data deletion
neophytenik Wednesday, November 04, 2009 1:47 AM - 589

VAS Memory Fragmented
kaitlyn77 Friday, November 06, 2009 5:46 PM - 121486

TempDB Contention
Glenn Wellington Thursday, December 04, 2008 6:31 PM - 1152

open cursors on server using "dbcc cursorstats" cant figure out whats causing it
MattChandler Tuesday, November 03, 2009 2:28 PM - 7104

foreign key and null values
Francesco Vanin Wednesday, November 04, 2009 5:01 PM - 146

Any way to re-create ##MS_AgentSigningCertificate## user in master database
Ian Miller Friday, November 06, 2009 8:17 PM - 2147

Information From DBAs - For Database Developer (SQL Server 2005)
WPF_Dev Tuesday, October 13, 2009 3:45 PM - 92798

No Description - Modify Backup Maintenance Plan failes to save.
Covi Thursday, April 26, 2007 8:29 PM - 4113

64 bit sql server - out of control
sqlstar Monday, November 02, 2009 4:07 PM - 15183

Prevent SELECT * query
jr81 Thursday, November 05, 2009 2:55 PM - 10199

reset fill factor back to server default
redwwood2771739 Friday, October 23, 2009 2:37 PM


