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.
-
Proposed0Votes
INSERT statement conflicted with the FOREIGN KEY constraint. The statement has been terminated.
Hi all, I get this error when inserting data... The INSERT statement conflicted with the FOREIGN KEY constraint ...3 Replies | 33 Views | Created by ShyamReddy - 2 hours 13 minutes ago | Last reply by Stan210 - 9 minutes ago -
Answered0Votes
SQL Agent Job is failing due to job has been suspended
Hi All, I am working on Migration Project, so after installed sql server i restored msdb database and edited maintatince plans with new connection string ...3 Replies | 1262 Views | Created by maddy28 - Wednesday, October 17, 2012 9:15 PM | Last reply by KevYo - 1 hour 54 minutes ago -
Proposed1Votes
Multiple Partitioned Indexed Views
Hi, I have a peculiar problem for which I can't seem to find any info. In a DW scenario I have a fact table which is partitioned. To insert/update the table we switch ...4 Replies | 79 Views | Created by Boyan Penev - Monday, December 02, 2013 6:33 PM | Last reply by wBob - 4 hours 36 minutes ago -
Unanswered0Votes
Sequence restarted at restart server???
I've created a sequence for a logging table: CREATE SEQUENCE [dbo].[LoggingSequence] AS [bigint] START WITH 110356 INCREMENT BY 1 MINVALUE ...4 Replies | 77 Views | Created by HeSitated - 15 hours 59 minutes ago | Last reply by Uri Dimant - 5 hours 51 minutes ago -
Proposed0Votes
SQL Restore error
Dear all, I'm trying to restore an SQL Server database from one server to another but I get the following error: The media ...1 Replies | 41 Views | Created by ti2 - 7 hours 3 minutes ago | Last reply by Shanky_621 - 7 hours 0 minutes ago -
Unanswered0Votes
A scalar function removes rows
Hello, I have a complex scalar function which requires 2 integers and returns 1 integer. Now if I add that function to my query I loose two rows. Is ...7 Replies | 68 Views | Created by Constantijn Enders - 14 hours 45 minutes ago | Last reply by Olaf Helper - 8 hours 6 minutes ago -
Unanswered0Votes
Perfmon Versus DMVs
I am looking at Perfmon and I can see that for the following counters SQLServer:Buffer Manager ...1 Replies | 43 Views | Created by lcerni - 8 hours 35 minutes ago | Last reply by Shanky_621 - 8 hours 14 minutes ago -
Answered0Votes
SQL 2012 statistics issue
= '2013-11-15T00:00:00' AND StartTime6 Replies | 191 Views | Created by SQL greenhorn - Sunday, November 24, 2013 1:11 AM | Last reply by SQL greenhorn - 9 hours 19 minutes ago -
Unanswered0Votes
Any script to add multiple agent jobs in new agent category?
I have created new agent category and now I want to add jobs under that category. Any script which can fulfill above requirement? Rahul5 Replies | 94 Views | Created by TwoR - 18 hours 50 minutes ago | Last reply by TwoR - 15 hours 19 minutes ago -
Unanswered0Votes
Not Getting Old image in CDC tables
I have enabled CDC on my table but after updating I am getting only operation 4 but not getting 3. Regards Vikas Pathak2 Replies | 82 Views | Created by vikas kumar pathak - Monday, December 02, 2013 9:41 AM | Last reply by Sofiya Li - 15 hours 35 minutes ago -
Unanswered0Votes
SQL server CLR creation error "Failed to create AppDomain"
We have a CLR stored procedure registered on all different SQL environment which was working perfectly. But one SQL server 2008R2 instance throw an exception while creating CLR ...4 Replies | 215 Views | Created by PraviN_PandiT - Friday, November 15, 2013 6:26 AM | Last reply by PraviN_PandiT - 18 hours 36 minutes ago -
Unanswered1Votes
Login failed message via SQL server account....
Hi, everyone. An error message as follow has come to me when I logged in SQL server via web server. The message; Server: Msg 18456, Level 14, ...8 Replies | 148 Views | Created by OlegSmirnov - Friday, November 29, 2013 12:34 PM | Last reply by Katherine Xiong - 21 hours 40 minutes ago -
Unanswered0Votes
Performance Issue Using T4199 or T4126
Hi, we migrated a database from a SQL Server 2008 server (production) to a SQL Server 2008 R2 server (test - version 10.50.4000). The test server has the trace flag 4199 enabled. ... -
Proposed0Votes
Database backup got failed because of below error.
Hi All, PFSS, we are taking the backup of the database through maintenance plan wizard. is there any other way ...2 Replies | 104 Views | Created by rupc - Monday, December 02, 2013 9:25 PM | Last reply by Neha Mahajan DBA - 22 hours 21 minutes ago -
Discussion0Votes
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 ... -
Unanswered0Votes
Is there a way through a Central Management Server to collect information on Memory Utilization?
We are using SQL Utility to collect CPU information. Unfortunately it does not collect memory information. Is there a way through a Central Management Server to collect ...5 Replies | 212 Views | Created by lcerni - Wednesday, November 27, 2013 3:25 PM | Last reply by lcerni - Monday, December 02, 2013 9:08 PM -
Proposed0Votes
SNAPSHOT ISOLATION and sys.dm_tran_version_store
I've been playing around with the scripts bellow trying to better understand the snapshot isolation internals, but the behaviour is some times unexpected. I was expecting that every ...5 Replies | 145 Views | Created by ruibastos - Friday, November 29, 2013 10:42 PM | Last reply by ruibastos - Monday, December 02, 2013 6:39 PM -
Answered0Votes
Login failed to sql server after changing domain account
Dear all I have joined the server running sql server 2012 to another domain because my previous DC demoted, created domain account then used the account to start sql server service ...1 Replies | 59 Views | Created by Sadock Obeth - Monday, December 02, 2013 4:45 PM | Last reply by Vinay Valeti - Monday, December 02, 2013 5:11 PM -
Proposed0Votes
Avoid or Remove Deadlock
Hi, I have two process running parallel. One process(process1) is deleting rows in table 1. But in another process(process2) table2 is getting inserted with ...4 Replies | 81 Views | Created by Dineshkumarm1 - Monday, December 02, 2013 2:21 PM | Last reply by davidbaxterbrowne - Monday, December 02, 2013 3:52 PM -
Proposed0Votes
logshipping wrong database alert
We have a wrong database configured for alert, JKUINMHYU1.JOLRsty should only be a primary database JKUINMHYU2.JOLRsty should be secondary. In the mgmt studio, ...3 Replies | 81 Views | Created by HumayunM - Monday, December 02, 2013 2:29 AM | Last reply by Shanky_621 - Monday, December 02, 2013 2:46 PM - Items 1 to 20 of 24999 Next ›