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.
-
Sticky0Votes
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 ... -
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 ...4 Replies | 418 Views | Created by XAML guy - Tuesday, December 03, 2013 12:47 AM | Last reply by Shanky_621 - Friday, December 20, 2013 4:19 AM
-
Answered5Votes
Meaning of "Index Fragmentation" return for HEAP tables....?
>>>>>> SELECT OBJECT_NAME(ind.OBJECT_ID) AS TableName, ind.name AS IndexName, indexstats.index_type_desc AS IndexType, ...15 Replies | 242 Views | Created by edm2 - Saturday, December 21, 2013 9:25 AM | Last reply by Uri Dimant - 1 hour 3 minutes ago -
Unanswered0Votes
transformation vs business logic
can anyone please tell me the difference between a transformation and business logic in the context of a Data Warehouse? do these terms mean the same thing? thanks for the ...3 Replies | 66 Views | Created by PeaceOut - 6 hours 59 minutes ago | Last reply by JRStern - 2 hours 9 minutes ago -
Answered0Votes
Policy based management - syspolicy_conditions - is_name_condition
Hi , As mentioned here - ...2 Replies | 86 Views | Created by SathyanarrayananS - 20 hours 54 minutes ago | Last reply by SathyanarrayananS - 17 hours 18 minutes ago -
Unanswered0Votes
how to rtroubleshoot hung sql server job?
This is sql server 2005(SQL server 9.0.5000). One sql server job is used to kick windows batch file.It runs hourly every day. These days, this sql server job ...6 Replies | 114 Views | Created by bestrongself - Saturday, December 28, 2013 3:54 PM | Last reply by Uri Dimant - 21 hours 33 minutes ago -
Answered0Votes
BULK INSERT in SQL Server 2012 on Windows 2012 Keepings File Locked for Windows XP clients
Hi, We have a .NET Framework 2.0 app that uses ADO.NET to issue a BULK INSERT command from a text file into SQL Server 2012 database table. After the insert finishes, the app ...7 Replies | 1710 Views | Created by arsenv - Monday, November 05, 2012 4:25 PM | Last reply by softwaregeek786 - 21 hours 36 minutes ago -
Proposed0Votes
Error: Cannot drop schema because it is being referenced by object
My database has a schema with the same name as a user (let's call it 'username'). This schema was not explicitly created. I want to drop the User 'username' but I have to drop the schema ...2 Replies | 100 Views | Created by DarrellDoesData - Sunday, December 29, 2013 2:34 AM | Last reply by Praveen Rayan D'sa - 22 hours 27 minutes ago -
Proposed0Votes
How to attach/restore the sql database/file extension (*.File)
I took backup the database long back ago. Now I am unable to attach/restore the sql database/file extension (*.File). I have the file type called (*.File) which i ...8 Replies | 113 Views | Created by Laxmi_Narayana - Saturday, December 28, 2013 11:19 PM | Last reply by Laxmi_Narayana - Sunday, December 29, 2013 6:27 AM -
Unanswered0Votes
Performance analysis
Hi Experts I was investigating some performance problem. My investigation concluded with IO subsystem+memory issue. But actual problem turned out to be an issue with NIC. ...13 Replies | 154 Views | Created by v.vt - Friday, December 27, 2013 2:22 PM | Last reply by JRStern - Saturday, December 28, 2013 9:42 PM -
Answered0Votes
SQL Server 2005 Agent Logs
Hi, I am getting below erros in SQL Agent: Please help me to solve. 2011-03-24 00:38:38 - ! [298] SQLServer Error: 258, TCP Provider: Timeout ...5 Replies | 4941 Views | Created by S.Vijay Kumar - Friday, March 25, 2011 3:21 PM | Last reply by Nagaraju Dasari - Saturday, December 28, 2013 8:11 PM -
Proposed0Votes
SQL Server Express 2012 Install fails Repeatedly
I have tried to install SQL Server 2012 Express with tools on my Windows 7 Home Premium system. it has failed twice. I then tried to install just the LocalDB version and that installation ...5 Replies | 252 Views | Created by bobm_genpres - Sunday, December 15, 2013 2:02 AM | Last reply by bobm_genpres - Saturday, December 28, 2013 5:48 PM -
Proposed0Votes
Backup and restore full and transaction log in nonrecovery mode failed due to LSN
In SQL 2012 SP1 enterprise, when taking a full backup and followed up a transaction log backup immediately, the transaction log backup starts with an earlier LSN than the ending LSN of the full ...12 Replies | 225 Views | Created by MS_1234567 - Friday, December 27, 2013 1:39 AM | Last reply by Erland Sommarskog - Saturday, December 28, 2013 4:24 PM -
Proposed0Votes
my sql function returm multipal value please solve ?
Hi, All when i execute this function, this showing error :- Error Code : 1242 Subquery returns more than 1 ...3 Replies | 148 Views | Created by Dhiraj10 - Friday, December 27, 2013 11:30 AM | Last reply by durgesh.sharma - Saturday, December 28, 2013 11:57 AM -
Unanswered0Votes
Result Not Showing When Using NOT IN in Query
Hi, Result Not Shown in NOT IN Used Query. The First Query Return 1 Row for the ...2 Replies | 104 Views | Created by Ragu Thangavel - Saturday, December 28, 2013 7:43 AM | Last reply by Mohammad Nizamuddin - Saturday, December 28, 2013 9:02 AM -
Proposed0Votes
SQL2000 - sp_who vs master.dbo.sysprocesses
I am using SSMS2008 connecting to a SQL2000 db instance. Trying to find a test account, that "ran away" during an app test. I was going to kill the ...2 Replies | 92 Views | Created by Ami2013 - Friday, December 27, 2013 9:39 PM | Last reply by Shanky_621 - Saturday, December 28, 2013 5:29 AM -
Answered2Votes
Query "Stuck" in CXPacket wait with no other waits for that session id in the blocking session id of sys.dm_os_waiting_tasks
So I have a query that is running with a large number of CXPacket waits. There are no other tasks in the sys.dm_os_waiting_tasks that are blocking this session id with a wait other than CXPacket ...5 Replies | 86 Views | Created by sfibich - Friday, December 27, 2013 9:52 PM | Last reply by sfibich - Saturday, December 28, 2013 1:00 AM -
Unanswered0Votes
SQL Server 2000 db corruption and tools.
Hi! The databse corruption hit our sql server 2000, 200 Gb database. The dbcc check database never finish the scan, it goes ...10 Replies | 214 Views | Created by lumiga - Saturday, December 21, 2013 2:16 PM | Last reply by Vedran Kesegic - Friday, December 27, 2013 11:49 PM -
Proposed0Votes
Difficulty compressing a huge database - compact command fails
compact /c CE_SecurityLogsArchive_DataSecondary.ndf Compressing files in F:\Database\ CE_SecurityLogsArchive_DataSecondary.ndf ...1 Replies | 80 Views | Created by Tim_Dorenkamp - Friday, December 27, 2013 10:18 PM | Last reply by Erland Sommarskog - Friday, December 27, 2013 10:39 PM -
Unanswered0Votes
How to Change ASP form Layout?
Hi, I am trying to create an Asp.net form. but all the buttons are stuck with each other I cannot move them simple by draging them and put them any where on the form where I want, ...2 Replies | 88 Views | Created by Azwar Shah - Friday, December 27, 2013 8:49 PM | Last reply by Azwar Shah - Friday, December 27, 2013 8:59 PM -
Unanswered1Votes
Addition of additional tempdb files
We can go for additional temp db files , but not more than the number of Logical CPU? Is the above statement true? If yes/no, please ...11 Replies | 175 Views | Created by Vimarsh - Friday, December 27, 2013 3:46 PM | Last reply by Shanky_621 - Friday, December 27, 2013 5:47 PM -
Unanswered0Votes
A process is locking itself, means self lock
One process is locking itself, means self lock so does having additional tempdb will solve this issue? If no then how i can resolve this issue of process locking ...3 Replies | 133 Views | Created by Vimarsh - Friday, December 27, 2013 3:33 PM | Last reply by Tom Phillips - Friday, December 27, 2013 5:40 PM - Items 1 to 20 of 25207 Next ›