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.
-
1 VotesChange Tracking internals behave differently, SQL Server 2012 vs SQL Server 2008
<original post by Glenn Estrada> Reposting an issue from Stack Overflow that a coworker and I are dealing with. In trouble ...Unanswered | 6 Replies | 2309 Views | Created by Kris Cook - Friday, September 13, 2013 5:13 PM | Last reply by Mike1D - Wednesday, November 19, 2014 12:48 AM
-
0 Votes
Performance Monitor SQLExecDirect failed with [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'Pk_CounterD_xx'. Cannot insert duplicate key in object 'dbo.CounterData'. The duplicate key value is (XXX, 16548, 6912)..
Hello, I am using collecting performance counter values from several servers to one sql server, I found sometimes the server reports error ...Unanswered | 4 Replies | 715 Views | Created by AlbertZOZ - Tuesday, November 18, 2014 1:44 AM | Last reply by AlbertZOZ - Tuesday, November 18, 2014 10:44 PM -
0 Votes
Single database Migration steps from sql 2008 to 2012
Hello Experts. This is my first time in production. I have to migrate a single database from sql 2008 to 2012. I need to have proper steps as its my first time in production ...Unanswered | 0 Replies | 504 Views | Created by Prasant Pardesh - Tuesday, November 18, 2014 10:11 PM -
3 Votes
Executing Contents of Stored Procedure Executes Fast than Stored Procedure
Lately, I've come across a few very slow running stored procedures. If I copy the contents of the procedure to another query window then execute it, the script executes almost immediately. ...Answered | 6 Replies | 658 Views | Created by Crazy Adam - Friday, November 14, 2014 6:02 AM | Last reply by Crazy Adam - Tuesday, November 18, 2014 9:51 PM -
0 Votes
sys.dm_os_performance_counters empty
After booting up my instance of SQL Server 2014, SELECT * from sys.dm_os_performance_counters returns no values. All I have to do is restart the SQL Server ...Unanswered | 4 Replies | 675 Views | Created by Appollyon - Tuesday, November 18, 2014 3:33 PM | Last reply by Appollyon - Tuesday, November 18, 2014 7:53 PM -
0 Votes
Need to add a user
I have a list of network sql servers and I need to check each of them to see if login "tom" already exists. If he does, then say so. If he doesn't, then add him to the 'master' ...Unanswered | 2 Replies | 442 Views | Created by SQL Dog - Tuesday, November 18, 2014 4:36 PM | Last reply by Prashanth Jayaram - Tuesday, November 18, 2014 7:04 PM -
0 Votes
Questions on Collection Sets created from Profiler.
= 5 seconds, and it got created as expected. Questions: While I was able to create the collection set, I don't see a table to query that ...Unanswered | 2 Replies | 347 Views | Created by ChrisRDBA - Tuesday, November 18, 2014 4:01 PM | Last reply by ChrisRDBA - Tuesday, November 18, 2014 4:40 PM -
0 Votes
how to disable column store index
hi all, i need a solution for how to disable the column store index created for table in my sp for a table column store index is ...Proposed | 2 Replies | 548 Views | Created by LuckyLucky12 - Tuesday, November 18, 2014 10:38 AM | Last reply by JRStern - Tuesday, November 18, 2014 4:10 PM -
0 Votes
How to restore the Password backup in sql server 2005
How to restore the Password backup in sql server 2005Answered | 26 Replies | 580 Views | Created by Thiruppathi thiru - Tuesday, November 18, 2014 9:08 AM | Last reply by Muthukumar Balu - Tuesday, November 18, 2014 3:46 PM -
0 Votes
How to Add Login in Regsitry
Dear All, I had a problem that login time was varies for some users. For Example for my login, the access fo server is fast but for some other users it is very slow when compare to ...Unanswered | 4 Replies | 539 Views | Created by Rajkumar JGn - Monday, November 17, 2014 5:17 AM | Last reply by jakkampudi - Tuesday, November 18, 2014 3:41 PM -
0 Votes
temp tables, dynamic sql and scope query
Try this: DROP TABLE #t GO SELECT 1 AS 'field1' INTO #t EXEC ('select 1 as field2 into #t select field2 ...Answered | 2 Replies | 1179 Views | Created by mahsjdh12 - Tuesday, November 18, 2014 2:59 PM | Last reply by Kalman Toth - Tuesday, November 18, 2014 3:34 PM -
0 Votes
Unable to connect to SQL Server: 'SQL Server does not exist or access denied.'
Hi All, I have windows service application created in C++. From windows service I am connecting to SQL server and database. When I create new process from windows ...Proposed | 16 Replies | 821 Views | Created by Raman-SGGS - Tuesday, November 4, 2014 4:24 PM | Last reply by jakkampudi - Tuesday, November 18, 2014 2:58 PM -
0 Votes
CTE for Count the Binary Tree nodes
i have the table structure like this : Create table #table(advId int identity(1,1),name nvarchar(100),Mode nvarchar(5),ReferId int ...Unanswered | 4 Replies | 568 Views | Created by King__Fisher - Tuesday, November 18, 2014 7:52 AM | Last reply by King__Fisher - Tuesday, November 18, 2014 10:19 AM -
0 Votes
Need help on restoring database from shared location
Hi Team, I want to restore the data base file from network shared location using script. Please note that in shared location i have read and ...Proposed | 4 Replies | 517 Views | Created by jesel1 - Tuesday, November 18, 2014 5:58 AM | Last reply by Shanky_621 - Tuesday, November 18, 2014 9:38 AM -
0 Votes
Management Studio query size
What's the maximum rows and size in a single query window ?Proposed | 6 Replies | 451 Views | Created by sakurai_db - Monday, November 17, 2014 6:56 AM | Last reply by sakurai_db - Tuesday, November 18, 2014 9:04 AM -
10 Votes
SQL Server 2012 - Cannot Use Network Drive as a Backup Device
Hello Community, I am using SQL Server 2012 and I am trying to add a mapped drive as a backup device, but I am not even to see that drive from SQL Server. Has anyone else had ...Answered | 15 Replies | 7204 Views | Created by Tom Molskow - Tuesday, May 21, 2013 9:51 PM | Last reply by mdrizwan - Tuesday, November 18, 2014 6:43 AM -
0 Votes
thinking about convergence in the area of Big Data
Hi! Assume you already have an Hadoop system using an specialized version of column store. I was told that more or less everything in the Hadoop stack has an InputFormat class ...Unanswered | 1 Replies | 482 Views | Created by Bjorn D. Jensen - Friday, November 14, 2014 10:26 AM | Last reply by Lydia Zhang - Tuesday, November 18, 2014 2:20 AM -
0 Votes
SQL Server 2014 - RESOURCE MONITOR / PREEMPTIVE_XE_CALLBACKEXECUTE high CPU usage
Hello, We have newly installed 3 * Windows Server 2012 R2 Cluster+ SQL Server 2014 instances with latest hotfix installed(http://support2.microsoft.com/kb/2920151) , ...Unanswered | 2 Replies | 550 Views | Created by AlbertZOZ - Friday, November 14, 2014 2:08 AM | Last reply by Lydia Zhang - Tuesday, November 18, 2014 1:35 AM -
0 Votes
Timeout
Hi all, one of application connect to SQL server start report this erro below , the occurnace is very randome and resolve by it self any clue ?? thanks in advance ...Unanswered | 13 Replies | 1237 Views | Created by SQL Kitchen - Friday, November 14, 2014 11:23 AM | Last reply by JRStern - Monday, November 17, 2014 11:56 PM -
0 Votes
MSSQL 2008R2 SP3 will it include all security updates and cumulative patched released before this patch ? Example this security patch KB2977319, KB2977320 ?
If I install MSSQL 2008R2 SP3 will that cover all the security patched released before this patch ? I also want to specifically know about this two Vulnerabilities in SQL Server ...Proposed | 2 Replies | 532 Views | Created by Srinivasan Srisailam - Monday, November 17, 2014 4:42 AM | Last reply by Shanky_621 - Monday, November 17, 2014 11:11 PM - Items 1 to 20 of 27361 Next ›
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.
