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

`question about key-range lock
Jackie Shen 12 hours 4 minutes ago - 8129

fail over cluster
SPFriend Wednesday, May 22, 2013 3:24 AM - 556

complex query resulting in very slow compilation, how to improve it?
Willgart1 13 hours 19 minutes ago - 438

How to create data dictionaries
SR_MCTS 11 hours 28 minutes ago - 996

SQL Memory Clerks - MEMORYCLERK_SQLCONNECTIONPOOL - Using all Memory
SQL24 Friday, May 24, 2013 9:01 AM - 287

paged out
SLNSH Thursday, May 23, 2013 3:33 PM - 271

Could not obtain information about Windows NT group/user
swt1974 Friday, May 24, 2013 5:15 PM - 281

Optimizer memory, memoryclerk_sqloptimizer memory very high and climbing
dragonMoon Friday, May 24, 2013 6:52 PM - 576

Test a single table's performance
anaylor01 Saturday, May 25, 2013 12:50 AM - 392

SQL server service pack and
SPFriend Friday, May 24, 2013 2:22 AM - 8100

SQL server patch for sharepoint db server
SPFriend Thursday, May 23, 2013 11:08 PM - 51257

Run a powershell in sql server
nicofer Saturday, August 04, 2012 3:51 AM - 369

Write conflict
Ray1127 Friday, May 24, 2013 9:39 PM - 372

Statistics on Magic table(Triggers)
LearnerSql Friday, May 24, 2013 7:59 PM - 32547

Management Data Warehouse (MDW) Job failing on Mirrored Server
xs2varun Tuesday, October 04, 2011 2:18 AM - 8109

To many _WA_Sys statistics
jdyoumans Thursday, May 23, 2013 4:17 PM - 376

indexes
SLNSH Friday, May 24, 2013 1:31 PM - 270

Number of Deadlocks/sec reached to 1200
BKR1 Friday, May 24, 2013 5:08 PM - 251294

memoryclerk consumes a lot of memory
AleshaDBA Wednesday, August 22, 2012 8:41 AM - 888

Retrieving info about the columns of a table - SQL Server 2012
pscorca Friday, May 24, 2013 10:14 AM

