SQL Server Database Engine
Any questions or discussions relating to the SQL Server Database Engine, performance, features, Full-text Search, linked servers, etc.
Announcements
- Link
SQL Server 2008 SP1 released
Service 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.
- 1183

Attach adventureworks 2008 to SQL server via SSMS
Sam_bai3 Sunday, June 16, 2013 9:48 PM - 324

SQL server 2008 database engine
indidba 1 hour 42 minutes ago - 137

SQL Server 2008 and 2012 instances with in the same windows 2008 failover cluster
Robb123 3 hours 25 minutes ago - 236

Can I use performance_dashboard reports with MDW?
Ajay.G 10 hours 21 minutes ago - 47128

Attach database failed for Server
ravirajmahal Thursday, November 04, 2010 4:52 PM - 22294

Reclaiming space available
anaylor01 Friday, June 14, 2013 7:17 PM - 030

Anyone know of a way to access the properties of an object with the WMI() macro token in a SQL Agent job step?
BitEngineer 8 hours 18 minutes ago - 82782

How to reduce the available space on the db
AChaitu Tuesday, November 04, 2008 12:00 PM - 46252

in consistent information reported in SQL Management Studio - msdb datafile shows 58GB in size, but Disk Usage by Top Tables report only show 23MB in use
GLEN T_ Friday, June 07, 2013 2:05 PM - 1053

altering a populated column from int to bigint
db042188 11 hours 15 minutes ago - 564828

Large MSDB
AmandaJayne Monday, April 16, 2012 10:33 AM - 251

How to get the package of SQL Diag?
Ajay.G 14 hours 39 minutes ago - 157

SQL2012 linked server to SQL2000 slow to insert
Jomrie 14 hours 26 minutes ago - 144

How to enable Histogram?
Ajay.G 14 hours 40 minutes ago - 2110

Commit_Table WaitType
DarthSooner Thursday, June 13, 2013 3:18 PM - 354

associating a table with its partition functions and schemes
ChrisAdkin 18 hours 37 minutes ago - 22419

SQL server is lazy, how do I motivate it ?
Jens Bylehn Tuesday, May 28, 2013 11:04 AM - 379

Restored master not restored msdb now have error
MikeFox Friday, June 14, 2013 2:06 PM - 9128

clear trunsaction log
biltzdba Tuesday, June 11, 2013 6:03 PM - 365

Partitioning Master Tables for Faster Load (Switch In).
S Kumar Dubey Monday, June 17, 2013 3:50 AM

