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.
-
Proposed0VotesDifferent Execute Plan for same query
10 Seconds to execute 1st query while it only takes -
Unanswered0VotesA significant part of SQL Server process memory has been paged out
Gurus, I see a stack dump error too in addititon to error in the subject line. I have configured the setting for Max and Min memory and both have the same values. i.e 6400. My ... -
Answered0VotesSQL2012 linked server to SQL2000 slow to insert
An insert statement run on SQL2012 server to a linked server (SQL2000 destination) is slow. Test script is below. -- Run on destination server (SQL2000) CREATE ... -
Proposed0VotesHow to investigate on SQL server using high memory
Hello All, I am having a Server of 64 GB RAM and 58 GB is allocated to SQL server, SQL server is utilizing all Memory, How to investigate on this issues. Which ... -
Unanswered0VotesSP duration is longer from .Net as compare to running directly from SSMS. Unknow dynamic sql after sp_start
Hi, One of SP is taking thrice the time from .Net as compare to running SP directly in SSMS. One strange thing I have notice is the following dynamic SQL call 2-3 ... -
Unanswered0VotesDbcc checkdb command
Dear Sir, Here i am having a doubt When we run DBCC CHECKDB command if we found any ... -
Answered3VotesDatabase corruption issue
We are facing problems on production server with SQL Server 2005 enterprise edition, where one of user DB are having many allocation errors and backups are not successfull even for msdb. We find some ... -
Unanswered0VotesCurrected Index
dbcc checked given the below error message , i tried to repair the database with allow data loss, when i ran the command instead ... -
Proposed0VotesI installed SQL Server 2008 in Windows Cluster environment, but can not find Local Server in Management Studio!
In a SQL Server 2008 cluster environment, local database engine server can not be found that installation process of SQL Server 2008 is normal, when I open SQL Server Management ... -
Answered2VotesIBMDASQL OLEDB linked server "access denied" using Windows Authentication
I have a linked server defined on a SQL Server 2005 SP2 standard edition server using the IBMDASQL OLEDB driver. The linked server has been defined and working for months when used from a SQL Server ... -
Unanswered0VotesLinked Server Strange issue
Hi All, I setup a linked server to IBM Iseries from SQL Server but the strange thing is when I use open query to retrieve data, some of the columns are showing up in hexadecimal ... -
Unanswered0VotesToo many parallel nested transactions
Just recentally we have started to get dump files with the following description: Description: Too many parallel nested transactions ... -
Unanswered0Votescpu usage information
hi , one of my production sever cpu spiking 100%,constant 90% what we can do? how to resolve the this ... -
Proposed0VotesAttach adventureworks 2008 to SQL server via SSMS
Hi : I need help to attach adventureworks database 2008 to the SQL via SSMS, because every time I try to do it this is what I get : TITLE: Microsoft SQL ... -
Unanswered1Votesbuffer size
Hi all, how much size contain buffer in ms sql server? -
Unanswered0VotesThere is any way to change partition scheme from left to right without dropping Table in production.
Hi All, There is any way to change partition scheme from left to right without dropping Table in production. I am doing testing on Table Partitioning & ... -
Unanswered0VotesHow to enable Histogram?
How to enable Histogram? Thanks -
Answered1VotesOPENQUERY over Oracle Linked Server crashes instance with c0000005 EXCEPTION_ACCESS_VIOLATION
Hi there, Our applications query over linked servers to Oracle. We started upgrading our database servers to SQL 2008 R2 from SQL 2005. After one server upgrade, we ... -
Answered0Votesdelete transaction log file
Hi, I added a logfile in my SQL Server database for some long running transactions. But now I want delete the transaction logfile which i ... -
Unanswered0VotesThis is the code I can't identify where the error is located I reve unhandle exception
Imports System.Data.SqlClient Public Class Form1 Dim cn As New SqlConnection("Data ... - Items 1 to 20 of 23711 Next ›


