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
Microsoft TechNet Wiki Guru - Winners for July!!
The results for July's TechNet Guru competition have been ...1 Replies | 181 Views | Created by XAML guy - Sunday, August 11, 2013 9:06 PM | Last reply by Ed Price - MSFT - Monday, August 12, 2013 8:41 PM -
Sticky1Votes
Can you teach us anything about SQL Server Database Engine? Win love and recognition! Become a TechNet Guru for August 2013
TechNet Wiki is looking for great new content, from YOU! Show us your forum solutions or nifty knowledge nuggets and become MICROSOFT TECHNOLOGY GURU OF THE ...1 Replies | 285 Views | Created by XAML guy - Thursday, August 01, 2013 12:11 PM | Last reply by Ed Price - MSFT - Friday, August 02, 2013 6:13 PM
-
Unanswered1Votes
Changing column in NOT NULL. Why is there so much transaction log activity on compressed tables?
Hi guys, the setup is as following: SQL Server 2008R2, recovery model FULL in order to better track what's going on in the transaction log. CREATE TABLE ...6 Replies | 176 Views | Created by Andrej Kuklin - Friday, August 16, 2013 9:40 AM | Last reply by Uwe Ricken - 11 minutes ago -
Unanswered0Votes
Azure SQL Server Pre-Login Handshake Error
I'm attempting to connect to a SQL Database instance hosted in Azure via Visual Studio 2012 Ultimate. Everytime I try to connect I get this lovely ...2 Replies | 38 Views | Created by XxHoboRampagexX - 3 hours 30 minutes ago | Last reply by XxHoboRampagexX - 1 hour 54 minutes ago -
Unanswered0Votes
Update PDF file in FileTable
Hi- I'm new to working with FileTables and am wondering if the following code (which saves annotations to a PDF file in the FileTable with changes that are made through the PDF ...2 Replies | 120 Views | Created by BoozooChavis - Saturday, August 17, 2013 8:11 PM | Last reply by BoozooChavis - 3 hours 0 minutes ago -
Answered0Votes
SQL Server 2008 R2 Express service crashes on Windows Server 2012
I am trying to deploy our application that uses SQL Server 2008 R2 Express (SP1 I believe) to a Windows Server 2012 Standard virtual machine (using VMWare Workstation 9.0.2). The SQL Server Express ...5 Replies | 76 Views | Created by ACordner - 23 hours 54 minutes ago | Last reply by ACordner - 3 hours 39 minutes ago -
Proposed2Votes
Recovery of corrupt/lost .ndf file. No backup of database
Hi, Firstly, I am no database expert, no pardon any idiocy... I noticed that my database was no longer working and upon investigation noted that three .ndf files ...4 Replies | 56 Views | Created by Barend_03 - 6 hours 13 minutes ago | Last reply by Olaf Helper - 4 hours 18 minutes ago -
Answered1Votes
Service Broker Manager issued a SQL shutdown
I have SQL 2008 R2 Base (10.50.1600) installed on a server running Windows 2008 R2 (no service pack). SQL log shows the final DB backup completed at ...7 Replies | 44 Views | Created by OSFRKJarvis - 6 hours 45 minutes ago | Last reply by Olaf Helper - 4 hours 25 minutes ago -
Unanswered0Votes
Data copy across Linked Server much slower than expected
I'm trying to retrieve data from a SQL Server at a remote site running SQL2008. There is a query involved, but to isolate the issue I've materialised the data, so all subsequent tests are now doing ... -
Unanswered0Votes
SQL 2012 Update Statistics Maintenance Plan
Hi All Is anyone aware of any issues on SQL 2012 regarding maintenance plans for update statistics. I have migrated a system to SQL 2012 from SQL 2008, I ...12 Replies | 114 Views | Created by SQL24 - Tuesday, August 20, 2013 7:14 AM | Last reply by SQL24 - 5 hours 50 minutes ago -
Proposed0Votes
SQL Agent - UPDATE OPENROWSET not working
Hello, I've deployed an SP to export some data to an Excel sheet (using OPENROWSET and Microsoft ACE provider) which works flawlessly when launched it from a query window using my ...3 Replies | 97 Views | Created by L-C - Monday, August 19, 2013 2:55 PM | Last reply by Tom Phillips - 5 hours 52 minutes ago -
Proposed1Votes
Memory is not cleared when big batch job runs in sql server 2008R2
Hello, We have migrated to sql server 2008R2 and I have set up my MAX Memory 32 GB and MIN left a default 0. When I was watching performance while running ...3 Replies | 82 Views | Created by poratips - 17 hours 51 minutes ago | Last reply by Tom Phillips - 6 hours 7 minutes ago -
Proposed1Votes
RESTORE DATABASE fails, but only if run from within TRY/CATCH block.
Hi everybody, I'm trying to restore a DB using the following script: BEGIN TRY RESTORE DATABASE [20130717_SERVER4_NS_dat] FROM DISK = ...18 Replies | 335 Views | Created by Ivan Radchenko - Sunday, August 11, 2013 9:24 AM | Last reply by Ivan Radchenko - 6 hours 15 minutes ago -
Unanswered0Votes
online index rebuild of a single partition
Why does sql server not allow online rebuild of a single partition of a partitioned table. We have tables with over 3300 partitions and few of those partitions get heavily fragmented and the only ...12 Replies | 2275 Views | Created by Gokhan Varol - Tuesday, January 31, 2012 3:22 AM | Last reply by anuragsh - 6 hours 31 minutes ago -
Answered0Votes
Linked Server error: Login Failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
Good afternoon, I have the following issue that i can't seem to "fix": I have 2 instances: Instance A (primary ...5 Replies | 16317 Views | Created by SuperJB - Friday, February 18, 2011 2:57 PM | Last reply by chuckh1958 - 6 hours 32 minutes ago -
Proposed0Votes
unable to create the user database...
hi team, we are unable to create the user database, we are greeting the bellow error.4 Replies | 78 Views | Created by MSDN_12345 - Tuesday, August 20, 2013 3:52 PM | Last reply by anuragsh - 7 hours 18 minutes ago -
Answered0Votes
Raw Query Performance on Clustered vs Non-Clustered Index
I'm trying to determine what the overall performance difference would be in the following situation. Assuming I have a large table, 500M records that have a non-unique ...7 Replies | 100 Views | Created by WarrickFitzs - Tuesday, August 20, 2013 3:31 PM | Last reply by Uwe Ricken - 8 hours 25 minutes ago -
Proposed0Votes
How to identify the spike in CPU utilization due to concurrency in SQL Server
Hi All, I have a Windows 2012 server which is 2 core processor with 16 logical cores as per sys.dm_os_sys_info and max_workers_count of 704. It has two sql server 2012 ...3 Replies | 82 Views | Created by udhayan - Tuesday, August 20, 2013 7:30 PM | Last reply by anuragsh - 8 hours 47 minutes ago -
Proposed0Votes
Why are DDL changes to a temporary table not allowed within a snapshot transaction?
Why are DDL changes to a temporary table not allowed within a snapshot transaction, especially when the temporary table is created within the snapshot ...4 Replies | 109 Views | Created by David Rueter - Sunday, August 18, 2013 2:41 PM | Last reply by dsmwb - 9 hours 10 minutes ago -
Proposed0Votes
how to resolve "insufficient memory usage" in sql server 2000
I have one sql 2000 server in my environment and now getting an insufifcient memory problem. Please help me how to resolve it. Details: SQL ...6 Replies | 88 Views | Created by Mayur-DEW - Tuesday, August 20, 2013 5:53 PM | Last reply by anuragsh - 9 hours 31 minutes ago -
Answered1Votes
Change the Default backup location in sql server 2005
Hi Guys, i want to change the default location of backup in sql server 2005. do we have any option in 2005 other than to change in the ...6 Replies | 97 Views | Created by Praveenrai - 20 hours 44 minutes ago | Last reply by Praveenrai - 10 hours 12 minutes ago -
Unanswered0Votes
Monthly Partition Implementation for daily Load & Switch IN has to work
Hi All, Any one has Implemented Monthly partition on main table & Load the Temp table daily and switch in this data on daily basis. What I want to ask that How will I switch In ...4 Replies | 109 Views | Created by S Kumar Dubey - Friday, August 16, 2013 8:04 AM | Last reply by S Kumar Dubey - 12 hours 30 minutes ago - Items 1 to 20 of 24233 Next ›