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.
-
Unanswered0Votes
except shrinking how can I release those space from database.
My drive size is 550 GB in which data file exists. I have 500 GB database and I can see that internally 85 GB free space in data files still we receive alerts. except shrinking how ...3 Replies | 67 Views | Ajay.G - 5 hours 26 minutes ago | Last Reply Uri Dimant - 2 hours 36 minutes ago -
Unanswered0Votes
Can I know which table exists in which data file of database?
I have 12 data files in one database,can I know which table exists in which data file of database? Thanks3 Replies | 65 Views | Ajay.G - 5 hours 4 minutes ago | Last Reply Uri Dimant - 2 hours 37 minutes ago -
Unanswered0Votes
Attempted to read or write protected memory
Hello, I'm getting the following error message intermittently when trying to execute SSIS packages. The SSIS packages are hosted on SQL server 2008,10.0.2531, X64 and ...0 Replies | 56 Views | sqluser786 - 5 hours 15 minutes ago -
Answered27Votes
Database diagram support objects cannot be installed...
I can't make a diagram on our server(Win2003 x64,SQL 2005 Enterprise x64 sp2 3054). I have tried to login as an admin and create a new db, but get the same message - ...36 Replies | 59293 Views | Olof - Thursday, May 24, 2007 7:37 AM | Last Reply salwa.mirza - 14 hours 21 minutes ago -
Answered1Votes
SQL Server 2005 table loses primary key
Hi All, I'm using SQL Server 2005 Standard with SP3 and today I discovered that our system send a exception saying that cannot insert null values into one table, so I went to ...19 Replies | 241 Views | George Waters - Sunday, June 30, 2013 6:37 AM | Last Reply TiborK - 16 hours 59 minutes ago -
Unanswered1Votes
How can I write to job step output?
Can I do this in a job step? BEGIN TRY exec my_stored_procedure END TRY BEGIN ...3 Replies | 110 Views | shiftbit - Friday, July 05, 2013 12:22 PM | Last Reply TiborK - 19 hours 31 minutes ago -
Unanswered1Votes
resource databae
Hi all, i red many articles Resource database makes upgrading to a new version of SQL Server an easier and faster procedure How the Resource ...3 Replies | 103 Views | SLNSH - Friday, July 05, 2013 9:10 AM | Last Reply Rama Udaya - 21 hours 9 minutes ago -
Unanswered1Votes
SQL performing bad only in after noon
In one of our database, there is a stat about the whole day : SQL CPU Usage spikes b/w 8AM & 6PM is 5 spikes - highest is 30% @ 3:52PM; longest b/w 29 ...6 Replies | 146 Views | '''HuuM''' - Friday, July 05, 2013 1:22 PM | Last Reply Shanky_621 - 21 hours 48 minutes ago -
Unanswered1Votes
Update Statistics on failed
Hi, I have received below in logs of update stats: ========================= Update Statistics on Failed:(-1073548784) ...4 Replies | 120 Views | Ajay.G - Friday, July 05, 2013 8:09 AM | Last Reply Ajay.G - 23 hours 30 minutes ago -
Answered9Votes
SQL Server 2008 R2 { An Error occured when attaching database(s) }
Hello Guys! I just installed SQL Server 2008 R2 a couple of days ago, on the first day use i can attach database(.mdf) with out any problem. on the day 2, i keep ...21 Replies | 29349 Views | Jhules - Thursday, January 13, 2011 9:05 AM | Last Reply RichMNY - Saturday, July 06, 2013 4:05 AM -
Unanswered0Votes
understanding plan cache values
the environment - Windows Server 2008 R2 Ent. 64 bit - SQL Server 2008 R2 Ent. 64 bit - 8 cores - 32 GB RAM - Database size ...10 Replies | 149 Views | sqlfrenzy - Thursday, July 04, 2013 2:12 PM | Last Reply Devashish_Salgaonkar - Friday, July 05, 2013 6:32 PM -
Answered17Votes
Problem attaching a database
Hello, I have made a database in SQL Server 2005 Developer edition. I tried to attach it to a SQL Server 2005 Express Edition but I coundn't. I can attach and dettach it to the ...62 Replies | 106700 Views | ekekakos - Sunday, October 30, 2005 6:04 AM | Last Reply Derek Brouwer - Friday, July 05, 2013 4:29 PM -
Unanswered0Votes
Cluster and service crash
I have a 2 part question that is somewhat related to each other. 1. We have a 2012 SQL cluster set up on decent amouth of servers. They are all connected to the same switch. They ...5 Replies | 100 Views | Toolshed - Friday, July 05, 2013 1:40 AM | Last Reply Sean Gallardy - Friday, July 05, 2013 12:30 PM -
Answered0Votes
There is insufficient system memory in resource pool 'internal' to run this query.
Hi Friends, I'm experiencing a very annoying and hard to fix problem with my SQL2008, housed on Windows Server 2003 R3 Enterprise. Every couple of days my ...40 Replies | 21995 Views | MrJ999 - Monday, July 04, 2011 3:48 AM | Last Reply Rakendra - Friday, July 05, 2013 11:36 AM -
Unanswered0Votes
recovery
hi all, how can i recovery the data when user delete table?5 Replies | 143 Views | SLNSH - Thursday, July 04, 2013 3:57 AM | Last Reply TiborK - Friday, July 05, 2013 10:11 AM -
Answered1Votes
Buffer pool
Hi all, some questions of understanding about cache and buffer. So i know that there is the plan cache containing plans for procedures, ...4 Replies | 90 Views | F. Peters - Friday, July 05, 2013 6:50 AM | Last Reply TiborK - Friday, July 05, 2013 10:06 AM -
Unanswered0Votes
Need help with Errors while creating linked server
Hi, I am trying to create a linked server. Server1 is the server through which I am trying to connect to Server2. I am using "Be made using the login's current security ...1 Replies | 94 Views | Pulkit Gulati - Friday, July 05, 2013 7:24 AM | Last Reply Shanky_621 - Friday, July 05, 2013 8:29 AM -
Unanswered0Votes
SQL server data transfer scenario
Hi All, Here is the scenario. Site 1 - Primary DB - A -- this is a transactional OLTP Db Site 2 - Staging ...2 Replies | 100 Views | MandarAlawani - Wednesday, July 03, 2013 10:43 AM | Last Reply MandarAlawani - Friday, July 05, 2013 8:05 AM -
Unanswered0Votes
cluster
when building the cluster how does the cluster identifies what is the private network for heartbeat and what is public lan communication3 Replies | 89 Views | Toolshed - Friday, July 05, 2013 5:01 AM | Last Reply Shanky_621 - Friday, July 05, 2013 6:05 AM -
Proposed0Votes
Performance tuning
I am new Hire in an IT company, i am asked to improve the performance of one of the databses . i am not too sure where to ...3 Replies | 123 Views | '''HuuM''' - Thursday, July 04, 2013 7:04 PM | Last Reply Jack Vamvas - sqlserver-dba.com - Friday, July 05, 2013 5:44 AM - Items 1 to 20 of 23855 Next ›