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.
-
Sticky1Votes
Be our December TechNet SQL DBE Guru. Give the gift of code!
It's that time of the year again! It's Giving time! A time to think of those less awesome than you. A time to give ...2 Replies | 247 Views | Created by XAML guy - Tuesday, December 03, 2013 12:47 AM | Last reply by Shanky_621 - Friday, December 13, 2013 6:02 AM
-
Answered0Votes
Resore SQL server 2008 SP3 database to SQL server 2008 R2 SP1
I have a dump from a SQL server 2008 SP3 server and I'm trying to restore it to SQL server 2008 R2 SP1 server but getting the error: Msg 3241, Level 16, State 0, Line ...6 Replies | 59 Views | Created by Leon75 - 3 hours 15 minutes ago | Last reply by TiborK - 1 hour 16 minutes ago -
Unanswered0Votes
SSL Certificate
A 3rd party application requires SSL Encryption enabled in SQL Server - on SQL2008 / SQL2012 Will I need a new instance to host the backend of that ...1 Replies | 46 Views | Created by Ami2013 - 17 hours 4 minutes ago | Last reply by Sofiya Li - 1 hour 51 minutes ago -
Unanswered0Votes
Is it possible?
Hi All, I have an requirement. I have a text file. data will be dump into that file always. Whenever there is an update in that text file . The ...4 Replies | 58 Views | Created by Khushi N - 2 hours 57 minutes ago | Last reply by Khushi N - 2 hours 33 minutes ago -
Unanswered0Votes
Sql Service and Databases won't start on two of my databases SQl 2005
getting the errors below In Event viewer I have Event ID 17120 SQL Server Could not Spawn FRuncm thread check the sql server error log and the windows event logs ...7 Replies | 115 Views | Created by Droidhacker - 21 hours 59 minutes ago | Last reply by Fanny Liu - 2 hours 36 minutes ago -
Unanswered0Votes
The process cannot access the file because it is being used by another process. [SQLSTATE 42000] (Error 22022). The step failed.
In Sql server 2005 dev edition observing the followed error. SQLServerAgent Error: The process cannot access the file because it is being used by another ...1 Replies | 50 Views | Created by mito access - 6 hours 10 minutes ago | Last reply by Shanky_621 - 5 hours 1 minutes ago -
Unanswered0Votes
Multi Server administration error
Hi, I have configured a Master server and when im creating a maintenance plan and while saving it, im getting the following error "This Maintenanace Plan ...1 Replies | 80 Views | Created by winoa - Tuesday, December 17, 2013 9:54 AM | Last reply by Tracy Cai - 5 hours 2 minutes ago -
Proposed2Votes
Needs to configure the sql jobs with SA permission.
Hi team, we have one requirement,that is one db developer asking to me to create a one sql server login with SA permission, we told this is production ...1 Replies | 49 Views | Created by MSDN_12345 - 5 hours 28 minutes ago | Last reply by Shanky_621 - 5 hours 11 minutes ago -
Unanswered0Votes
RUnning sql job under non-winodws account
Hi all, I am pulling data from a source system(non-sql server) using SSIS. I am given a user name and password to connect to this system using ODBC. Can I create a sql server job and run this job ...4 Replies | 77 Views | Created by PeaceOut - 13 hours 16 minutes ago | Last reply by TiborK - 8 hours 9 minutes ago -
Answered1Votes
SQLServerAgent could not be started (reason: Unable to connect to server '<ServerNAme>'; SQLServerAgent cannot start)
Unable to start SQL Agent SQL Server 2008 R2 RTM OS: Windows 2008 R2 Agent Log 2012-04-17 22:17:22 - ! [298] SQLServer Error: 27, Registry information is corrupt ...10 Replies | 7704 Views | Created by Nag'a' - Wednesday, April 18, 2012 6:56 PM | Last reply by jijuac11 - 10 hours 1 minutes ago -
Proposed1Votes
Ready Time out error in application log
Hi All, Recently application are throwing below error when they are connected to databases engine. Application and Databases are two different ...4 Replies | 102 Views | Created by RaghuMohan - Tuesday, December 17, 2013 1:50 AM | Last reply by RaghuMohan - 11 hours 21 minutes ago -
Answered0Votes
Get deadlock statements?
Greetings. I've been using third party tools for monitoring for a very long time. However, I recently switched jobs and need to get up the learning curve with DMV's now. I ...17 Replies | 141 Views | Created by ChrisRDBA - Monday, December 16, 2013 6:08 PM | Last reply by Alister McPherson - 11 hours 28 minutes ago -
Proposed1Votes
AUTO_UPDATE_STATISTICS_ASYNC ON or OFF for OLTP database?
What is the final verdict? I believe Glenn is for enabled (ON) even when statistics updated nightly as a job. NOTE: Auto Update Statistics must be enabled (ON) for the asynch ...2 Replies | 51 Views | Created by Kalman Toth - 16 hours 38 minutes ago | Last reply by JRStern - 11 hours 57 minutes ago -
Answered2Votes
SQL Server 2012 Enterprise, Index fragment & page density issue
Hi guys, We have an index maintenance issue on large tables recently. Basically, there is a job running to do the index maintenance daily: do the index scan via ...12 Replies | 212 Views | Created by Stephanie Lv - Monday, December 16, 2013 8:01 AM | Last reply by Erland Sommarskog - 15 hours 54 minutes ago -
Unanswered0Votes
sys.fn_xe_file_target_read_file performance
Hi, I am working with extended events and the function sys.fn_xe_file_target_read_file. I am using the file_name and file_offset to get new events, since the last time I queried the ...10 Replies | 146 Views | Created by Ola Hallengren - Tuesday, December 17, 2013 10:52 AM | Last reply by Ola Hallengren - 16 hours 55 minutes ago -
Proposed0Votes
Storing Emails in the database
One of my client is storing the emails on Varbinary(max) column, it has to be kept in the database for at least 10 years and as you can imagine, database is becoming huge (with an year's email , its ...2 Replies | 69 Views | Created by Aneesh Ret - 20 hours 51 minutes ago | Last reply by Andreas.Wolter - 17 hours 0 minutes ago -
Answered0Votes
File growth size
Dear All, I wanted to create some databases but I wanted to know how to determine how much file frowth to specify in MB ...10 Replies | 222 Views | Created by ti2 - Friday, November 29, 2013 1:28 PM | Last reply by ti2 - 22 hours 24 minutes ago -
Answered0Votes
len function and nvarchar
Hi we run 2012 enterprise and to be proactive i thought i'd ask the community what the len function will return on our nvarchar(30) col when our foreign partners start populating with chars that ...4 Replies | 94 Views | Created by DB042189 - Tuesday, December 17, 2013 5:27 AM | Last reply by DB042189 - Tuesday, December 17, 2013 2:34 PM -
Proposed0Votes
Not able to access database from a remote machine using SQL Server Management Studio
Hi, I have a DB_BOX with SQL Server 2008 R2 installed. I can access the databases on the local machine using SQL Server Management Studio but it is not accessible from other ...2 Replies | 77 Views | Created by MaximRaven - Tuesday, December 17, 2013 1:25 PM | Last reply by Erland Sommarskog - Tuesday, December 17, 2013 2:24 PM -
Proposed0Votes
How many tempdb mdb files will be created in this case?
How many tempdb mdb files will be created in this case? SQL Server detected 2 sockets with 6 cores per socket and 12 logical processors per socket, 24 total ...4 Replies | 85 Views | Created by Ajay.G - Tuesday, December 17, 2013 12:56 PM | Last reply by RAJU RASAGOUNDER DBA - Tuesday, December 17, 2013 1:19 PM -
Answered4Votes
SQLExpress database file auto-creation error
Hi,I'm not sure this is the right location to post ...I got some issues with VS 2005 BETA 2.I done full install except for SQL Express and full install of the SQL server disc.Now when looking at ...20 Replies | 35416 Views | Created by Nightmare_BE - Monday, May 23, 2005 12:37 PM | Last reply by ShishuR - Tuesday, December 17, 2013 12:30 PM - Items 1 to 20 of 25123 Next ›