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
Spread the Love! Be our SS DBE TechNet Guru, this Valentine's
TechNet loves you! We love your contributions at TechNet Wiki sooo much that we give you more than just love in ...3 Replies | 269 Views | Created by XAML guy - Sunday, February 02, 2014 10:33 PM | Last reply by XAML guy - Monday, February 10, 2014 5:36 PM -
Sticky1Votes
New Top Support Solutions blog
Hello As part of our efforts to keep our communities informed about the most relevant content that address the top questions that we are getting in out forums and other support ...
-
Proposed1Votes
Questions on Db Mirroring
Hi All, I have below questions on database mirroring. I am using sql server 2008 sp3 Developer Edition. I am using High ...3 Replies | 106 Views | Created by Manu_vmr - 21 hours 49 minutes ago | Last reply by Shanky_621 - 1 hour 27 minutes ago -
Unanswered0Votes
Communication Failing with Corrupted Chars . Sql Server 2000 and AS400
Hi Experts, I am facing this below error after 9 yrs. sql server 2000 and As400 on prod server. while on dev and stage it's running properly. Here username is ABCD, while it's ...2 Replies | 82 Views | Created by LearnerSql - 13 hours 7 minutes ago | Last reply by Dan Guzman - 3 hours 29 minutes ago -
Answered1Votes
Turning Off my SQL Profiler Trace
I created a trace out of Profiler a coule weeks ago. However I did not think it was still running. However it is slowing process down and I can see ...4 Replies | 1231 Views | Created by 2010 - Thursday, January 03, 2013 10:26 PM | Last reply by Andreas.Wolter - 4 hours 5 minutes ago -
Unanswered0Votes
How do get around the maximum allowed row size of 8060
I have a requirement to display row data in column format. I have the following schema: ID1 | Item1 | Attribute1 | Attribute2 | Attribute3 | Attribute4 | Attribute5 | ...3 Replies | 50 Views | Created by Jim Hewitt - 5 hours 33 minutes ago | Last reply by Jim Hewitt - 5 hours 15 minutes ago -
Proposed0Votes
SQL Server 2012 Undetected Deadlock in a table with only one row
We have migrated our SQL 2000 Enterprise Database to SQL 2012 Enterprise few days ago. This is our main database, so most of the applications ...26 Replies | 242 Views | Created by L100 - Wednesday, February 12, 2014 6:36 PM | Last reply by L100 - 8 hours 51 minutes ago -
Unanswered0Votes
SQL Server 2008 R2 SP2 dbmail won't send alerts, dbmail configured properly, alert system enabled
System.InvalidCastException: Unable to cast object of type 'System.DBNull' to type 'System.Byte[]'. Alerting does not work. sp_send_dbmail works ...1 Replies | 95 Views | Created by BobGriff - 20 hours 20 minutes ago | Last reply by Neha Mahajan DBA - 18 hours 18 minutes ago -
Proposed0Votes
How to DELETE huge record around(2 Lakhs) from a table very fast.
We need to DELETE around 2 lakhs of data from Table which have around 5 lakhs. We are deleting data batch wise . We can't go for the Partition Option ...7 Replies | 122 Views | Created by SubhadipRoy - Friday, February 14, 2014 1:23 PM | Last reply by JRStern - Friday, February 14, 2014 5:15 PM -
Answered0Votes
sql server will not start - Database 'model' cannot be opened. It is in the middle of a restore.
Sql server service will not start after server reboot: 2009-08-13 14:15:43.94 spid7s SQL Trace ID 1 was started by login "sa". ...6 Replies | 11357 Views | Created by FonziSherman - Thursday, August 13, 2009 7:37 PM | Last reply by BhanuSQL - Friday, February 14, 2014 4:29 PM -
Unanswered0Votes
Unable to clear connection
SQL Server 2005 SP4 Windows Server 2003 R2 SP2 Backup of a database failed with the attached error ...3 Replies | 73 Views | Created by Jeelani Kamal - Friday, February 14, 2014 3:20 PM | Last reply by Andrew Bainbridge - Friday, February 14, 2014 3:50 PM -
Answered0Votes
Event Id 326 & 327
I have those event triggered on my log every every few seconds, sometimes as many as 6 per seconds. I know that some here reported that this is related to the SSRS. ...5 Replies | 4132 Views | Created by karlr30 - Wednesday, January 23, 2013 1:40 PM | Last reply by MiataMan - Friday, February 14, 2014 2:21 PM -
Unanswered0Votes
SS2008 Log Shipping Performance Issues on Secondary Server Restore Job
Hi folks, I'm having an issue with log shipping. What has taken 2-5 minutes in the past is now taking 20-40 minutes which is no good really. File sizes have not ...9 Replies | 314 Views | Created by Stuart Saker - Friday, January 24, 2014 1:26 PM | Last reply by Stuart Saker - Friday, February 14, 2014 10:27 AM -
Proposed1Votes
Column Mask support?
Does SQL 2012 or the upcoming SQL 2014 support the mask feature like DB2 provides to protect PII data easily without the need to create VIEWS, change programs, change stored procedures, ...2 Replies | 86 Views | Created by MattOARRT - Thursday, February 13, 2014 7:27 PM | Last reply by Sofiya Li - Friday, February 14, 2014 9:02 AM -
Answered0Votes
Can I shrink Trans log even if doing log-shipping?
I have a 2000 DB which is log-shipping to another server. The log has grown huge and needs to be made smaller. Can I use DBCC SHRINKFILE without damaging the log-shipping? I know that truncating ...5 Replies | 6350 Views | Created by SillyMS - Thursday, May 03, 2007 3:51 PM | Last reply by memin sahin - Friday, February 14, 2014 8:05 AM -
Proposed0Votes
Using linked server between SQL 2005 and SQL 2008R2 becomes very slow
Hello, We use for several years for our application a linked server to transfer data from an SQL Server 2005 Express to SQL Server 2005 Standard. Amount of data can be large. ...2 Replies | 82 Views | Created by adents - Thursday, February 13, 2014 10:15 PM | Last reply by Latheesh NK - Friday, February 14, 2014 5:02 AM -
Proposed0Votes
2 instances at same machine
I created the 2 instances where 1 is default instance and another 1 is named instance. The default instance currently running ok with port no. 1433. but the named ...6 Replies | 119 Views | Created by sqlman2011 - Thursday, February 13, 2014 4:06 AM | Last reply by Sofiya Li - Friday, February 14, 2014 3:04 AM -
Unanswered0Votes
Possible to decrypt DMK with SMK after database restore?
Hello all, Is it possible to decrypt the master key or decrypt the symmetric keys the master key is used to encrypt without knowing the master ...5 Replies | 111 Views | Created by msdown02 - Wednesday, February 12, 2014 5:22 PM | Last reply by Piotr Palka - Thursday, February 13, 2014 10:43 PM -
Answered0Votes
Bulk recovery model and minimal logging
Hi all I was brushing up my fundamentals by reading sql 2008 wrox and i get confused. Book says : Bulk recovery model do minimal logging in case of bulk ...3 Replies | 93 Views | Created by Saurabh Sinha DBA - Thursday, February 13, 2014 8:12 PM | Last reply by Saurabh Sinha DBA - Thursday, February 13, 2014 9:22 PM -
Unanswered0Votes
Change Tracking internals behave differently, SQL Server 2012 vs SQL Server 2008
<original post by Glenn Estrada> Reposting an issue from Stack Overflow that a coworker and I are dealing with. In trouble ...5 Replies | 1016 Views | Created by Kris Cook - Friday, September 13, 2013 5:13 PM | Last reply by ANKIT MAHAJAN - Thursday, February 13, 2014 6:59 PM -
Proposed0Votes
KB2895494 doesn't seem to work in SQL2012 SP1 CU8
KB2895494 was raised as part of SQL2012 SP1 CU7 to stop a memory leak caused by the MEMOBJ_COMPILE_ADHOC memory object not releasing memory. The KB includes a ...4 Replies | 133 Views | Created by ChrisAVWood - Tuesday, February 11, 2014 9:06 PM | Last reply by ChrisAVWood - Thursday, February 13, 2014 2:15 PM -
Proposed0Votes
Logshipping vs Mirroring
hi Team, we have 10 databases each database having min 350 gb, here we are paling to replication the data from production site to DR ...3 Replies | 107 Views | Created by MSDN_12345 - Thursday, February 13, 2014 1:02 PM | Last reply by Shanky_621 - Thursday, February 13, 2014 1:19 PM - Items 1 to 20 of 25559 Next ›