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
Are you very knowledgeable about SQL Server Database Engine? Win love and recognition! Become a TechNet Guru for July 2013
TechNet Wiki is looking for and celebrating the best of the best! Is that you? Do you consider yourself an expert, authority, or just pretty good at this ...4 Replies | 321 Views | Created by Ed Price - MSFT - Friday, July 12, 2013 11:46 PM | Last reply Ed Price - MSFT - Thursday, July 25, 2013 9:43 PM
-
Unanswered0Votes
PowerShell script to delete BAKs from mulitple child folders on a UNC share
Afternoon, I have been trying to roll my own ps script to accomplish a cleanup task but I am rather new to ps and am not getting the results ...1 Replies | 68 Views | Created by JJKusch - 5 hours 42 minutes ago | Last reply bass_player - 2 hours 10 minutes ago -
Unanswered0Votes
SQL server 2005 x64
Hello everybody. I need iso file of SQL server 2005 x64 trial version. In my company, we have 3 instances of sql server 2005 x64, but no install media. ... -
Unanswered0Votes
SQL Server 2008 R2 - JOB has been scheduled but not running on time
I have 3 jobs scheduled to run on SQL Server at 10:00PM , 10:05PM and 10:10PM daily. They are scheduled with service account [sa] and the password has not been ...8 Replies | 87 Views | Created by Raja Boddapati - 7 hours 55 minutes ago | Last reply Pradeep_DBA - 6 hours 11 minutes ago -
Unanswered0Votes
find Currently session that is costing high cpu
when sql server is 100% sqlserv service, what is the easy way to find what session/query is contributing the high cpu usage. There are a few queries on msdn for top cpu usage, but it is for last a few ...3 Replies | 81 Views | Created by George Zhou - 8 hours 16 minutes ago | Last reply Shanky_621 - 7 hours 21 minutes ago -
Answered0Votes
BCP exporting from SQL to CSV
Steps in BCP exporting DATA from SQL to CSV. I want to just export selecting and filtering the selection..... like I want to export ...3 Replies | 59 Views | Created by ebrolove - 9 hours 52 minutes ago | Last reply ebrolove - 9 hours 24 minutes ago -
Unanswered0Votes
how to move database with snapshot?
i have a database for which i have created a database snapshot. how can i move the database files (and the snapshot file) to a different disk location? i cannot detach / attach because ...5 Replies | 96 Views | Created by almaplayera - Thursday, July 25, 2013 3:55 PM | Last reply davidbaxterbrowne - 9 hours 35 minutes ago -
Unanswered0Votes
What is elapsed time in return from Set Statistics Time
I have the following message when I run a simple query "Select Distinct Orderids from tblOrders" CPU time = 47 ms, elapsed time = 1692 ms. Other ...14 Replies | 120 Views | Created by joeller - Thursday, July 25, 2013 3:51 PM | Last reply JRStern - 9 hours 39 minutes ago -
Unanswered0Votes
Cannot log in to SQL server/database problems
The story goes like this. Our website offers online account applications. The captured, sensitive data is written to a separate database on a secure server (separate from the main DotNetNuke DB). I ...4 Replies | 111 Views | Created by Kyle_1999 - Thursday, July 25, 2013 1:18 PM | Last reply Praneeth Kumar Charla Gorla - 9 hours 48 minutes ago -
Unanswered0Votes
SQL Server quit unexpectantly after system date on server was changed to a past date
We have a .NET application that stopped working. After investigation, we discovered that the system date on the server had been changeed to 2003 instead of the current 2013. After correcting the date, ...6 Replies | 118 Views | Created by JoLee - Wednesday, July 24, 2013 6:59 PM | Last reply Praneeth Kumar Charla Gorla - 9 hours 51 minutes ago -
Answered0Votes
CPUs, parallelism, and threads
I am using SQL Server 2008 hosted on Windows Server 2008R2 – 64bit. Our system has four CPUs. I have the following questions about CPUS in relation to parallelism and ...11 Replies | 124 Views | Created by Mpumelelo S - 12 hours 27 minutes ago | Last reply JRStern - 9 hours 54 minutes ago -
Answered0Votes
Unable to kill SPID 76!!
I run a KILL 76 command and the SPID 76 is still there!! Any ideas on this? Immediate answer needed!! ebro9 Replies | 108 Views | Created by ebrolove - Thursday, July 25, 2013 7:45 PM | Last reply Praneeth Kumar Charla Gorla - 9 hours 55 minutes ago -
Answered5Votes
suggestions on fragmentation stats?
k13 Replies | 186 Views | Created by '''HuuM''' - Tuesday, July 23, 2013 1:15 PM | Last reply Shanky_621 - 11 hours 44 minutes ago -
Unanswered0Votes
he OLE DB provider "SQLNCLI10" for linked server "ServerName" reported a change in schema version
When i execute a select query on a SQL view, which has few nested views which internally uses linked server, sometimes randomly I get this ...1 Replies | 69 Views | Created by Prakash_Samiyappan - 23 hours 3 minutes ago | Last reply Shanky_621 - 14 hours 48 minutes ago -
Unanswered0Votes
Wait Statistics - PREEMPTIVE_XE_DISPATCHER
Hi All I am analyzing wait statistics on my SQL Server. The top wait with 60% of all waits is for wait type PREEMPTIVE_XE_DISPATCHER Has anyone dealt with the ...2 Replies | 58 Views | Created by SQL24 - 16 hours 16 minutes ago | Last reply SQL24 - 14 hours 55 minutes ago -
Unanswered0Votes
What to install to read sql server 2012 online books on windows 7 pc
I want to read sql server 2012 online books on my windows 7 laptop 32 bit. What should I install from below link so that I can able to read sql server 2012 online ...2 Replies | 79 Views | Created by Ajay.G - 15 hours 46 minutes ago | Last reply Ajay.G - 15 hours 10 minutes ago -
Unanswered0Votes
2012 sql cluster / maintenance job - update statis is slow
2012 sql cluster when using maintenance plan for update stats, it takes about 10 minutes. When using script from the plan, it takes a second. No error. Any checking that we should do? Thanks,3 Replies | 86 Views | Created by cluster006c - 22 hours 39 minutes ago | Last reply SQL24 - 16 hours 48 minutes ago -
Unanswered0Votes
Error: 18456, Severity: 14, State: 5.
Hi We are on SQL SErver 2012 which was recently migrated on. I am seeing lots of errors like " Error: 18456, Severity: 14, State: ...5 Replies | 95 Views | Created by Orbitdba - Thursday, July 25, 2013 11:00 AM | Last reply vr.babu - 17 hours 6 minutes ago -
Unanswered0Votes
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (p
Hi all, we moved the services from one node(1) to another node say (2) in sql cluster setup we are facing the time out errors in webpage. but on node1 its ...2 Replies | 77 Views | Created by MSSQLLOVER - 18 hours 39 minutes ago | Last reply MSSQLLOVER - 17 hours 59 minutes ago -
Proposed0Votes
CPU hungry SPs or queries
Is it possible to identify most expensive queries(SPs) against a given DB between 6 AM and 7 AM today? ebro5 Replies | 110 Views | Created by ebrolove - Thursday, July 25, 2013 8:45 PM | Last reply Latheesh NK - 18 hours 48 minutes ago -
Answered0Votes
Why restore of database.bak fails?
I have clean SQL Server 2012 and restored database from bak file created in another server. Restore was succesful. Now I made new restore for the just created database from same bak ...5 Replies | 298 Views | Created by Kenny_I - Thursday, March 28, 2013 2:13 PM | Last reply [paradox] - Thursday, July 25, 2013 11:12 PM - Items 1 to 20 of 24016 Next ›