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.
-
Sticky0Votes
Are you very knowledgeable about SQL Server Database Engine? Win love and recognition! Become a TechNet Guru for July 2013
TechNet Wiki is looking for and celebrating the best of the best! Is that you? Do you consider yourself an expert, authority, or just pretty good at this ...5 Replies | 433 Views | Created by Ed Price - MSFT - Friday, July 12, 2013 11:46 PM | Last reply by Ed Price - MSFT - Saturday, July 27, 2013 7:24 AM
-
Unanswered0Votes
SQL 2K8R2 Start up ... TempDB clears then takes 2 hours to start up and let start up process finish
Evening, Have a strange issue. When we restart SQL Server we are unable to connect for almost 2 hours ...2 Replies | 70 Views | Created by JJKusch - 5 hours 56 minutes ago | Last reply by Shanky_621 - 5 minutes ago -
Proposed2Votes
Can I do my restoration in part or in fix size
WhenI am restoring the 500 GB database on sql server 2008 server of 12 GB ram then the server is getting hang and crashed and unexpected restart are happening. Can I do my ...8 Replies | 75 Views | Created by Ajay.G - 14 hours 58 minutes ago | Last reply by Shanky_621 - 23 minutes ago -
Proposed0Votes
pending vs outstanding io requests
Hi, can somebody explain me what pending IO requests (as shown in the sys.dm_io_pending_io_requests DMV) exactly mean and (if any) their relation to outstanding IO's (as ...2 Replies | 68 Views | Created by Geert Vanhove DCOD - 8 hours 58 minutes ago | Last reply by RohitGarg - 2 hours 9 minutes ago -
Proposed0Votes
oracle odbc SQLAllocHandle SQL_HANDLE_ENV error
I am using a 32bit application on Windows 7 (64bit) to access a 32bit Oracle database via 32bit ODBC. If the user id is in the Local Administrators group, it works ...3 Replies | 72 Views | Created by leungcwk - 22 hours 21 minutes ago | Last reply by Olaf Helper - 2 hours 18 minutes ago -
Unanswered0Votes
429ActiveX component can't create object sql server 2008
recently i have instaled sql server 2008 on my windows server 2008 instead of sql 2005. an application stoped working and started to give me this message " 429ActiveX component can't create ...2 Replies | 74 Views | Created by allattouf - 23 hours 20 minutes ago | Last reply by Sofiya Li - 2 hours 35 minutes ago -
Unanswered0Votes
Deadlocking analysis help needed..
Today I was approached by a developer whose app was deadlocking during testing. To emulate a user load he invoked a webservice in a loop with each loop having 10 invocations (each with ...12 Replies | 127 Views | Created by edm2 - Wednesday, July 31, 2013 3:29 AM | Last reply by JRStern - 3 hours 8 minutes ago -
Answered0Votes
DB file Shrinking
I tried to shrink the log file and it is not shrinking..... ebro5 Replies | 76 Views | Created by ebrolove - 14 hours 52 minutes ago | Last reply by Jeff Moden - 4 hours 27 minutes ago -
Answered0Votes
Linked server Issue between sqlserver 2008 R2 and Mas90 server
Hello, I have setup a linked server between SQL Server 2008 R2 and MAS90 server and I am able to select data and see the list ...14 Replies | 390 Views | Created by Sapen2 - Friday, June 07, 2013 2:23 PM | Last reply by RLeGrand - 8 hours 43 minutes ago -
Unanswered0Votes
SQL Server crashes on Cluster
In the last two weeks, a problem appeared on my 3 node SQL Server 2012 (SP1 CU2) on Windows 2008 R2 Cluster: The database engine intermittently crashes with the following error ...3 Replies | 96 Views | Created by tom3411 - 17 hours 33 minutes ago | Last reply by Andrew Bainbridge - 10 hours 37 minutes ago -
Answered0Votes
Remote Procedure call failed in SQL Server Configuration Manager
I have installed SQL Server 2008R2 on my Windows7 laptop successfully. However, when I open the configuration manager, the "SQL Server Services" entry shows an error message saying "The ...4 Replies | 3099 Views | Created by Chris D Jones - Saturday, December 08, 2012 4:46 PM | Last reply by Jesus Aranda - 12 hours 43 minutes ago -
Proposed0Votes
How to estimate the impact (overhead) of Change Tracking over a single Database
Dear All, I'm going to implement the Change Tracking to keep track of changes over a set of Databases. Before going "productive" we'd like to estimate ...3 Replies | 71 Views | Created by Igor Antonacci - 19 hours 51 minutes ago | Last reply by JRStern - 13 hours 23 minutes ago -
Unanswered0Votes
SQL Server 2012 TempDB ballooning to more than 75 GB
Hi, In one of our database while executing a procedure serving an important business logic, which has 11 joins, then a filtering on a specific column, sorting using order by on a ...9 Replies | 112 Views | Created by MrinalK - Tuesday, July 30, 2013 10:40 PM | Last reply by MrinalK - 15 hours 21 minutes ago -
Unanswered0Votes
Cannot log in to SQL server/database problems
The story goes like this. Our website offers online account applications. The captured, sensitive data is written to a separate database on a secure server (separate from the main DotNetNuke DB). I ...6 Replies | 195 Views | Created by Kyle_1999 - Thursday, July 25, 2013 1:18 PM | Last reply by Praneeth Kumar Charla Gorla - 15 hours 45 minutes ago -
Answered0Votes
how to move database with snapshot?
i have a database for which i have created a database snapshot. how can i move the database files (and the snapshot file) to a different disk location? i cannot detach / attach because ...6 Replies | 178 Views | Created by almaplayera - Thursday, July 25, 2013 3:55 PM | Last reply by Praneeth Kumar Charla Gorla - 16 hours 3 minutes ago -
Proposed0Votes
AWE memory high in RamMAP tool for Windows 64-Bit version?
I am trying to debug memory pressure on SQL Server 2008 Enterprise Edition running on Windows 2008 Standard 64-Bit. 1. AWE is not enabled. 2. SQL Server ...8 Replies | 124 Views | Created by Venugopal Saride - Tuesday, July 30, 2013 8:52 PM | Last reply by Tom Phillips - 16 hours 27 minutes ago -
Answered0Votes
SQL 2012 filetable fileshare, cannot open Outlook msg file
I have mapped a filetable fileshare to a local drive. I am able to open most file types except an Outlook msg file. I get the standard "Cannot open file T:\etc..etc.msg. The ...5 Replies | 126 Views | Created by Fox4 - Monday, July 29, 2013 9:50 AM | Last reply by Tom Phillips - 16 hours 36 minutes ago -
Proposed0Votes
Remove File Button has not removed file - help!
Hi. We had some disk space problems last week with our tempdb database - as a fix, we created an additional "Rows Data" file on a seperate drive. I have ...4 Replies | 91 Views | Created by Bobby_Dancemaster - 18 hours 49 minutes ago | Last reply by Bobby_Dancemaster - 17 hours 20 minutes ago -
Unanswered0Votes
Sliding Windows Partition implementation on 2 File Groups. One file group is on Fast Disk & another is on Slow Disk
Hi All, Sliding Windows Partition implementation on 2 File Groups. One file group is on Fast Disk & another is on Slow Disk. Here What I am trying to achieve is suppose I have ...1 Replies | 56 Views | Created by S Kumar Dubey - 22 hours 42 minutes ago | Last reply by S Kumar Dubey - 22 hours 11 minutes ago -
Answered0Votes
MEMORYCLERK_SQLCONNECTIONPOOL consuming memory
Hi, In one of my Server which has 16GB of RAM out of which 12 GB is allocated to buffer pool with lock pages in memory enabled. I am seeing a lots of memory error ...4 Replies | 320 Views | Created by SQLDBA06 - Monday, July 01, 2013 11:14 PM | Last reply by Vashistar - 22 hours 18 minutes ago -
Answered3Votes
Strong SA password
On running the setup file, I got this message when trying to run msde: "A strong SA password is required for security reasons. Please use ...10 Replies | 40953 Views | Created by Mayomano - Saturday, March 25, 2006 7:21 PM | Last reply by advanisons - 23 hours 40 minutes ago - Items 1 to 20 of 24047 Next ›