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.
- 216
sql_handle for a Stored Proc does not exist in dm_exec_query_stats
ddanda 42 minutes ago - 778
Access issues in SQL Server 2008 R2
Shanoof Basheer 20 hours 58 minutes ago - 22217
Disk Performance issue (Transaction/Sec degrade suddenly)
Deepak_Goyal Tuesday, May 28, 2013 12:56 PM - 683
Want to know events selected in Exciting trace
maddy28 22 hours 22 minutes ago - 229
send backup report through dbmail
Bilal Bhat 3 hours 49 minutes ago - 763
tempdb full
Bilal Bhat 8 hours 25 minutes ago - 45768
Undo Changes in Table Help!!
Giber Tuesday, December 05, 2006 11:33 PM - 133
SQL Server 2014 and SharePoint on-line (Office 365)
pscorca 5 hours 56 minutes ago - 32675
TPC-E test on SQL Server 2012 high runnable task count
adam.moericke Monday, April 29, 2013 8:59 PM - 472
SSMS Backup databse
sourises 18 hours 32 minutes ago - 374
recover data
gurram999 20 hours 48 minutes ago - 683
replace a unique clustered index with a clustered PK
JRStern 20 hours 54 minutes ago - 9198
How to clean the clerk "MEMORYCLERK_SQLCLR"
Fabricio França Lima Wednesday, May 29, 2013 12:31 AM - 480
Compare performance between a box with a instance or several instances
lumiga Tuesday, June 04, 2013 1:17 PM - 9179
invalid column name 'xml_index_type'
Red8Rain Thursday, May 30, 2013 4:22 AM - 789
best practices for handlding this database log file growth issue?
wallst360 Tuesday, June 04, 2013 12:10 PM - 9104
Why does a select statement rollback?
Shanoof Basheer Tuesday, June 04, 2013 1:26 PM - 580
System counts in sys.dm_db_index_usage_sats
ChrisAVWood 21 hours 56 minutes ago - 164
Net Stop Start MSSQL$SQLEXPRESS Remotely
Lugalzagesi 23 hours 18 minutes ago - 15176
Typeperf is throwing error message for the SQLServer counters
skan2dan Thursday, May 16, 2013 11:54 AM