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.
- 566
Perfmon is reporting very high "waits started per second". What are possible causes and what other stats help find that?
danholmes Tuesday, May 14, 2013 3:47 PM - 281
sysjobactivity cannot insert duplicate
DannyTDBA 22 hours 14 minutes ago - 011
CMS -Store the results in a table
liebesakt 57 minutes ago - 218
Random Error: A network-related or instance-specific error occurred while establishing a connection to SQL Server.
Gus Jones 2 hours 16 minutes ago - 641
SQL Compression performance issue
Ishfaq Ahmed 6 hours 38 minutes ago - 554
SQL Server 2012 - Missing or lost transaction and no errors to show what went wrong
Dina_1818 Tuesday, May 14, 2013 8:11 PM - 8105
Job is not running but activity monitor is showing next schedule time
Mayur-DEW Monday, May 13, 2013 8:02 PM - 1060
Reclaiming 2TB in a SQL Server 2008R2 database ( non-log file) shrinkdb
wtoak001 7 hours 58 minutes ago - 347
SQL Server 2008 Memory Usage details
skan2dan 6 hours 51 minutes ago - 1180
product level vs service pack
db042188 Tuesday, May 14, 2013 6:47 PM - 759
sql server services starting problem..
Chandu1987 7 hours 48 minutes ago - 435
Sharing Jobs
clm2 6 hours 42 minutes ago - 460
Unable to create filegroup for filestream implementation on SQL Server 2008 database
skan2dan Tuesday, May 14, 2013 2:33 PM - 5111
will Partition help if the large table has lot of Inserts and Updates
Kushal_sql Wednesday, May 08, 2013 4:07 PM - 188807
SQL Server 2005 64-bit 100% CPU
Ivy62798 Monday, June 30, 2008 12:06 PM - 485
SQL Server keeps stopping every time I start it.
Bdrap Tuesday, May 14, 2013 6:43 AM - 451
Debugging tips for job/procedure - SQL 2005
shiftbit 21 hours 17 minutes ago - 27430
TPC-E test on SQL Server 2012 high runnable task count
adam.moeicke Monday, April 29, 2013 8:59 PM - 468
How to tell if statistics are causing problems
shiftbit 23 hours 35 minutes ago - 569
How to tell if a job is hung up or being blocked? no blocks seen with sp_who2
shiftbit Tuesday, May 14, 2013 8:47 PM