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

How does deleleting all rows and re-inserting updated data affect index fragmentation?
wideboy32 Sunday, November 22, 2009 5:59 PM - 328

Index fragmenation and database performance
Nikesh Kootan 4 hours 14 minutes ago - 9167

Server / Database Perforamance Testing -- Help required
SNIVAS Friday, November 20, 2009 12:58 PM - 546

BUG on SQL Server 2008 with Unique Index
José Guimarães 7 hours 5 minutes ago - 582

Error applying SP1 to SQL Server 2008
kaitlyn77 Monday, November 23, 2009 7:18 PM - 4736309

Problem attaching a database
ekekakos Sunday, October 30, 2005 6:04 AM - 06

Updating distributed databases
waynecod 3 hours 14 minutes ago - 021

Change Data Capture
MNPrstn 3 hours 38 minutes ago - 137

Robo Copy command to transfer sql server logshipping files
Naga1982 4 hours 50 minutes ago - 6118

Best way to backup data warehouse
Robert F Bouillon Sunday, November 22, 2009 10:53 PM - 551

Problem with Standby Mode in Log-Shipping
Zoe.Ohara 8 hours 41 minutes ago - 5102

sql maint fails
DDrabo Sunday, November 22, 2009 4:56 PM - 390

Problem with Log Shipping
Zoe.Ohara Monday, November 23, 2009 1:31 PM - 465

Creating a Linked Server with 64 bit SQL Server 2008 to MS Access
pcrtx 16 hours 28 minutes ago - 71792

Does xp_cmdshell proxy account need admin-level permissions?
sadie2 Thursday, October 04, 2007 3:49 PM - 284

MS SQL Server, Error 233
Prem_UK Sunday, November 22, 2009 1:41 PM - 368

Regular optimisation job doesn't defragment indexes
Zainu Monday, November 23, 2009 1:41 PM - 256

How to Create Index in sql server 2005?
Ramaprasad.R 16 hours 3 minutes ago - 376

DB Designe For Performence In sql server 2005
Ramaprasad.R Monday, November 23, 2009 11:24 AM - 37382

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


