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.
-
Sticky2Votes
Do you want to be our Guru of the Month for October?
TechNet Wiki needs... YOU! "Don't you know there's a war going on? Between good content... and bad. The Internet is ...1 Replies | 88 Views | Created by XAML guy - Wednesday, October 02, 2013 8:48 PM | Last reply by Shanky_621 - Thursday, October 03, 2013 5:32 AM
-
Proposed1Votes
regarding permisions and data
Hi all, I’ve a database backup file that I need to replace the existing database in SQLCLUSTER01 with. The database is clsdb , and in the new version there are changes to the ...2 Replies | 92 Views | Created by raghu3085 - Tuesday, October 01, 2013 5:42 AM | Last reply by Candy_Zhou - 29 minutes ago -
Proposed0Votes
Partitioning a table
Hi , I need a advise on best partitioning strategies for our environment. We have couple of tables currently partitioned on datetime field. Each partition has a day's worth of data. We keep 50 ...1 Replies | 34 Views | Created by SQLmaddy - 4 hours 57 minutes ago | Last reply by Uri Dimant - 1 hour 1 minutes ago -
Proposed0Votes
miring endpoints
hi, how we can change the miring end points and how we can enable & disable the miring end points. thanks...3 Replies | 79 Views | Created by MSDN_12345 - 11 hours 10 minutes ago | Last reply by Rama Udaya - 2 hours 36 minutes ago -
Unanswered0Votes
Multiple statistics on the same column
I am wondering what happens when more than one statistics exists for the same column of the table? This well can happen if column level statistic was already automatically created and later index was ... -
Answered1Votes
A significant part of sql server process memory has been paged out
On a SQL Server 2005 x64 Standard Edition cluster I get the error listed below and then the SQL server service restarts. The SQL server is unavailable for 5-10 minutes ...7 Replies | 17673 Views | Created by FHJJr - Thursday, July 26, 2007 9:06 PM | Last reply by Preetha7 - 3 hours 31 minutes ago -
Answered0Votes
installation of SQL server
Hi Guys, I have installed SQL Server 2008 to one of my PC. I will use this as our server for SQL training Lab. I've use dafault instance for my instance configuration which its ...9 Replies | 177 Views | Created by Lenoj - Wednesday, October 02, 2013 5:55 AM | Last reply by Sofiya Li - 3 hours 42 minutes ago -
Unanswered0Votes
BACKUP failed to complete the command BACKUP LOG msdb
Hi, I am getting following error message daily into my error log. I am running FULL Backup, Diff Backup an T-Log Backup. This message is every ...6 Replies | 140 Views | Created by poratips - Monday, September 30, 2013 3:25 PM | Last reply by Candy_Zhou - 3 hours 51 minutes ago -
Unanswered0Votes
Insert Permissions On Filetable
I am new to SQL server file table, so I'm trying to get a grasp on how the table permissions affect the file share. What I am looking to do is to allow users to read and create/add files to the ... -
Unanswered0Votes
Selecting the Correct Timeslot
Hi, I have a timeslot and event_data table that I want link together. The output should be, if a part of the event_data time (eventdatafrom and eventdatato) falls into the ... -
Unanswered0Votes
msdb.dbo.syscollector_execution_stats_internal has 3 million records
Hi, the msdb table "dbo.syscollector_execution_stats_internal" has over 3 million records and takes about 400 MB. The data is not much to look at. I think it might have something ...5 Replies | 125 Views | Created by Randy in Marin - Tuesday, October 01, 2013 8:09 PM | Last reply by Randy in Marin - 10 hours 42 minutes ago -
Unanswered0Votes
Jobs created by sql server reporting services.
There are some jobs that created by SSRS where the name is a uniqueidentifier which does not tell me which report the job is running. I ran the script from the link below but it doesn't return ...1 Replies | 46 Views | Created by Frank J Garcia - 12 hours 21 minutes ago | Last reply by Frank J Garcia - 11 hours 56 minutes ago -
Answered1Votes
Multiple TempDB files disappear on restart
1. Added 2 extra tempDB files across 2 logical drives. 2. Restarted SQL Service or the server 3. The 2 extra files disappear from ...13 Replies | 357 Views | Created by dorhammmm - Monday, September 09, 2013 1:12 PM | Last reply by dorhammmm - 12 hours 14 minutes ago -
Unanswered0Votes
Space Occupied by Database in 1 Year is 2835 GB
We have extimated the Space Occupied by Database in 1 Year is 2835 GB. It is going hold data for 24 years. Could you please suggest what should be the Physical memory ...3 Replies | 68 Views | Created by SubhadipRoy - 14 hours 36 minutes ago | Last reply by Dean Savović - 12 hours 27 minutes ago -
Answered1Votes
AWE Using SQL Server 2005 32bit on a 64 bit Operating System
Would activating AWE on a 32 bit SQL Server Standard Edition which is running on a 64 but Windows 2008 Server R2 Standard Edition, work? Or would this be irrelevant since the Operating System is a 64 ...7 Replies | 141 Views | Created by Karm Cash - Tuesday, October 01, 2013 9:06 PM | Last reply by Jeremy D Allen - 14 hours 40 minutes ago -
Unanswered0Votes
Oracle linked server query execution problem
Hi i've got oracle linked server on SQL Server 2008 R2 on Windows server 2008 and have one dynamic query below that throws an error like: OraOLEDB.Oracle" for ...1 Replies | 73 Views | Created by Ilik - Thursday, October 03, 2013 3:45 AM | Last reply by davidbaxterbrowne - 15 hours 17 minutes ago -
Unanswered0Votes
SQL 2000 mdf file
Hi Gurus, I have SQL 2000 where the mdf file is growing 20gb. Is there any option for controlling the size of mdf file. i have low disk size. There is no way i can add the disk. ...2 Replies | 60 Views | Created by venkatESH RAJAM - 15 hours 42 minutes ago | Last reply by Rama Udaya - 15 hours 31 minutes ago -
Unanswered0Votes
Estimated number of rows in Execution plan - aggregated or per execution?
When we see Estimated number of rows in execution plan, does it mean Number of rows per one execution of certain unit or does it mean Aggregated number of rows for the entire query? So far I ...8 Replies | 156 Views | Created by Dmitry Otblesk - Wednesday, October 02, 2013 2:22 AM | Last reply by Shanky_621 - 15 hours 41 minutes ago -
Proposed2Votes
How much time my 1 TB database full backup takes?
Hi all, I have the database of size 1 TB in Virtual environment. How many hours my backup takes with in the same server with below configuration as mentioned in ...13 Replies | 121 Views | Created by MSSQLLOVER - 19 hours 28 minutes ago | Last reply by Andrew Bainbridge - 16 hours 43 minutes ago -
Unanswered0Votes
Where can I get a copy of SQL Server Mgmt Obj (SMO) -
Sql backups have been failing, informed that I need to re install SMO for this ver. of SQL. SELECT@@VERSION : ...1 Replies | 49 Views | Created by PurpleCheese - 18 hours 30 minutes ago | Last reply by Sebastian Sajaroff - 18 hours 12 minutes ago -
Unanswered0Votes
memory usage
Running sql 2008, on server 2003 we have only one database that is 20gb insize. we use this for infotronics, time and attendance infotronics ...9 Replies | 124 Views | Created by rolliemoe - Wednesday, October 02, 2013 2:04 PM | Last reply by Shanky_621 - 22 hours 15 minutes ago - Items 1 to 20 of 24558 Next ›