SQL Server Database Engine announcement
-
Link
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.
-
Proposed0Votesin 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
msdb properties shows database size 58GB, but when ran report 'Disk Usage by Top Tables' the largest table showed on 11MB and only 7 tables has 3MB in size and rest of are les that ... -
Unanswered0VotesLatest update
Is there anyway to be notified by Microsoft when SQL Server gets a new update? Also I am finding it hard to find what the latest update to SS2012 is. Is it SP1? Is there a page someone can point me to ... -
Proposed0VotesAttach adventureworks 2008 to SQL server via SSMS
Hi : I need help to attach adventureworks database 2008 to the SQL via SSMS, because every time I try to do it this is what I get : TITLE: Microsoft SQL ... -
Unanswered0VotesToo many parallel nested transactions
Just recentally we have started to get dump files with the following description: Description: Too many parallel nested transactions ... -
Unanswered0VotesP2P Replication and Update Stats
I had P2P Replication configured between 2 servers. The replication from Server 1 to Server 2 was working fine but the Replication from Server 2 to Server 1 was broken. I removed Replication ... -
Answered0VotesSQL 2008 - Huge, But Empty MDF File
I have a database that imports records, 'fixes', then sends the records to a differnet server/db. I remove the imported records and wait to do the same the next day. 50-20k records per ... -
Answered0Votesdelete transaction log file
Hi, I added a logfile in my SQL Server database for some long running transactions. But now I want delete the transaction logfile which i ... -
Answered7VotesMessage Error: 18210, Severity: 16, State: 1. and Message Error: 3041, Severity: 16, State: 1.
i have back failure errors in the sql server logs when i check maintenance plans history it shows back up ran successfully.I also see the backup files at the destination disk drive ... -
Unanswered0VotesSQL2012 linked server to SQL2000 slow to insert
An insert statement run on SQL2012 server to a linked server (SQL2000 destination) is slow. Test script is below. -- Run on destination server (SQL2000) CREATE ... -
Answered0VotesSql backups apparently happening but how?
I have a sql 2008 r2 server and have not setup any maintenance plans. According to the logs it is showing entries like the backups are happening, but why and where are they? It appears to ... -
Unanswered0VotesSQL Server 2012
Hi All, I'm hoping I am posting this to the right group and if not, then please excuse me :0)... I just had someone ask me about certification material for 2012 ... -
Unanswered0VotesThis is the code I can't identify where the error is located I reve unhandle exception
Imports System.Data.SqlClient Public Class Form1 Dim cn As New SqlConnection("Data ... -
Unanswered0VotesPerformance counters into SQL Server
SQL Server 2008 R2 Enterprise/standard Hi guys. Performance counters. Windows provides PerfMon to monitor server ... -
Answered3VotesDatabase corruption issue
We are facing problems on production server with SQL Server 2005 enterprise edition, where one of user DB are having many allocation errors and backups are not successfull even for msdb. We find some ... -
Unanswered0VotesSQL Cache dependency and deadlock - T1222 deadlock-list - dbo.AspNet_SqlCacheTablesForChangeNotification
Hi, We are maintaining cache tables in SQL Server where tables required for cache are marked for caching using ... -
Answered0VotesMinimally logged operations in Standard edition
Hi, I am using SQL Server 2008 Standard edition. I want to have couple of databases with minimal logging enabled. Is that possible on Standard edition ... -
Unanswered0VotesACTIVE_BACKUP_OR_RESTORE
Hi, I started backup to clear the transaction log (with Full RM). After the backup was completed, I checked the vlf status with "select ... -
Unanswered0VotesHow to enable Histogram?
How to enable Histogram? Thanks -
Unanswered1VotesSQL ERROR Msg 845 Time-out occurred while waiting for buffer latch type 3 for page (6:401831), database ID 8.
I am getting below error while accessing the database.we are not able perform any backup ,shrinkfile, detach operation on database.also same error occured while accessing database front ... -
Proposed0VotesSQL server 2008 database engine
We found in one of our SQL server machines drive was disconnected. The drive contained all data and log file. Even after that we were able to login to SQL server and service was up. We could see all ... - Items 1 to 20 of 23695 Next ›


