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.
-
Proposed0Votes
Seek predicate not using all columns
Hi, I have a strange query compilation issue which is hard to reproduce. It only happens under high load and cannot be easily repeated. There is a table ...3 Replies | 38 Views | dennis_ff - 8 hours 44 minutes ago | Last Reply Naomi N - 2 hours 39 minutes ago -
Unanswered0Votes
two-second tracewrite waits on VM'd server
I asked this a couple of months ago and didn't get a response, but is there anything about running SQL Server in a VM that should put a huge wait of two seconds on every tracewrite when I use ...5 Replies | 70 Views | JRStern - Tuesday, June 18, 2013 11:41 PM | Last Reply JRStern - 8 hours 45 minutes ago -
Unanswered0Votes
A 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 ...6 Replies | 76 Views | Nitin1353 - Thursday, June 20, 2013 8:41 AM | Last Reply Devashish-MS - 8 hours 47 minutes ago -
Answered0Votes
SQL Server Pagefile Configuaration
hi, i have one server in that server having 8gb RAM AND 2 SQL Server Instances. please suggest me how much minimum Pagefile and maximum Pagefile Space i have to ...6 Replies | 68 Views | LAKSHMI NARAYANA REDDY.L - 16 hours 52 minutes ago | Last Reply Devashish-MS - 8 hours 57 minutes ago -
Unanswered0Votes
SP 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 ...9 Replies | 90 Views | iBar1 - Wednesday, June 19, 2013 2:44 PM | Last Reply Erland Sommarskog - 9 hours 43 minutes ago -
Unanswered0Votes
SCSM 2010 service manager
Hi All, I am looking into SCSM transactional db rather than datawarehouse. I am interested in all tables related to incidents, especially those in which incident created through ...0 Replies | 20 Views | P M-S - 10 hours 24 minutes ago -
Unanswered0Votes
SQL Agent ODBC Message: 0, String data, right truncation [SQLSTATE 01004]
Hi, I'm getting the above error message in the agent log, followed immediately by [298] SQLServer Error: 2601, Cannot insert duplicate key ...1 Replies | 39 Views | Ikeadale - 14 hours 5 minutes ago | Last Reply TiborK - 12 hours 26 minutes ago -
Answered5Votes
Multiple users read / update table at same time
Hi Team, Database: SQL Server 2012 Express Front End: VB .Net application I have got a PoS application which read last Transaction id from a ...8 Replies | 75 Views | SapHelp - 16 hours 18 minutes ago | Last Reply SapHelp - 13 hours 9 minutes ago -
Answered1Votes
Best time to kick off rebuilding indexes on the db
I would like to create a sql job to re-build all indexes on the database. What things do I need to watch out for? The ...11 Replies | 78 Views | Nataliya Alexander - 18 hours 4 minutes ago | Last Reply Nataliya Alexander - 13 hours 40 minutes ago -
Proposed14Votes
Microsoft SQL server error:233
I am getting this error when connecting to sql. I cant get into my databases now- its pretty ugly. "A connection was succesfulyl established with the ...34 Replies | 85487 Views | mat12345 - Sunday, September 30, 2007 10:03 AM | Last Reply RanjitSahani - 15 hours 22 minutes ago -
Proposed0Votes
Date table with Australian date format
I'm using SQL Server 2012, I want to create a date table and I need the format for be dd/mm/yyyy. for some reason no matter what I do, the results in the SQL Server do not show this ...3 Replies | 58 Views | toby_m31 - Friday, June 21, 2013 1:21 AM | Last Reply Olaf Helper - 16 hours 55 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 ...19 Replies | 28375 Views | Jhules - Thursday, January 13, 2011 9:05 AM | Last Reply besinikel - 17 hours 44 minutes ago -
Unanswered0Votes
Hyper-V guest SQL 2012 cluster live migration failure
I have two IBM HX5 nodes connected to IBM DS5300. Hyper-V 2012 cluster was built on blades. In HV cluster was made six virtual machines, connected to DS5300 via HV Virtual SAN. These VMs was ...1 Replies | 54 Views | Anton Plotnikov - Wednesday, June 19, 2013 6:57 AM | Last Reply Anton Plotnikov - 18 hours 6 minutes ago -
Answered0Votes
Performance Issue on Sql server 2008 r2
Hi , There is a performance issue on my Standalone SQL Server there are many concurrences on a database. I found ...13 Replies | 129 Views | Subathra-Subathra - Thursday, June 20, 2013 12:46 PM | Last Reply Shanky_621 - 18 hours 14 minutes ago -
Answered0Votes
SQL Server 2008 - Saving BLOB files - Which is better for 100kb files? - Filestream or in different .mdf files?
Hi All, I am using SQL Server 2008 R2 as a backend tool in one of my application. I want to save 100kb files in database. I found two approaches for ...4 Replies | 51 Views | Ravi Mori - 20 hours 53 minutes ago | Last Reply Ravi Mori - 18 hours 29 minutes ago -
Unanswered0Votes
Can I ignore wait BROKER_TASK_STOP (in Management Data Warehouse)?
84%). And in this category the biggest wait is „BROKER_TASK_STOP“ (>83%). I read some documentation. For ...0 Replies | 28 Views | David KRIZ - 18 hours 46 minutes ago -
Proposed0Votes
SQL 2000 Maintenance Plan
Hi ALL I have created a maintenance plan SQL 2000 to backup all the databases in the DB server, and there is an option to clean up old DB backup after some time. However I found the ...2 Replies | 49 Views | sakurai_db - Thursday, June 20, 2013 4:28 PM | Last Reply sakurai_db - 20 hours 54 minutes ago -
Answered3Votes
Reclaiming space available
I have a database that I ran compression on and if you look at the picture it shows SIZE 401407.04MB and Space Available as 210142.89MB. I am trying to free up that space but nothing has worked yet. I ...34 Replies | 449 Views | anaylor01 - Friday, June 14, 2013 7:17 PM | Last Reply anaylor01 - 22 hours 49 minutes ago -
Proposed0Votes
Dbcc checkdb command
Dear Sir, Here i am having a doubt When we run DBCC CHECKDB command if we found any ...6 Replies | 79 Views | mito access - Thursday, June 20, 2013 7:27 AM | Last Reply Uwe Ricken - 23 hours 7 minutes ago -
Answered0Votes
Use Bcp with Sqlcommand
Hi, I know we use bcp to retrieve Image file from database to the file system. How can we do the same against SqlCommand? Many ...2 Replies | 51 Views | HuaMin Chen - 23 hours 54 minutes ago | Last Reply Manivannan.D.Sekaran - 23 hours 27 minutes ago - Items 1 to 20 of 23728 Next ›