Transact-SQL
TSQL challenges? This is the place for advice / discussions
Announcements
SQL Server 2008 SP1 released
Ed LehmanMSFTWednesday, April 08, 2009 6:16 PMService 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.
Filtering and SortingUse these options to narrow down the question and discussion list.
- 010603

New Site: Solutions to Common T-SQL Problems
Arnie RowlandMVPSaturday, April 12, 2008 2:52 PM - 124959

Some guidlines for posting questions...
Clifford Dibble - MSFTMSFTFriday, October 28, 2005 4:58 PM - 5847

How to import data from Access2007 to SQL 2005
Yo__ Tuesday, January 29, 2008 7:53 PM - 571

month/year datetime comparisons
DoorKnobs 7 hours 59 minutes ago - 45256

Exception Error 5123 - Unable to attach database
rupertsland Tuesday, January 29, 2008 8:52 PM - 658

fastest way to copy huge data
dhariwal57 13 hours 2 minutes ago - 1169

I was givin a quiz with 10 questions
chuckdawit 5 hours 53 minutes ago - 462

Test Post for Moderators
Arnie RowlandMVP5 hours 31 minutes ago - 1284

Selecting a float Value
SqlAge 8 hours 19 minutes ago - 19317

T-SQL Solutions: Most Intuitive vs. Best Performing
SQLUSA Tuesday, November 10, 2009 10:27 PM - 374

using where clause with Freetexttable, partition table
sseerraajj Monday, November 23, 2009 2:37 PM - 477

how to implement procedure for end-day batch processing ?
Andrew Goodnight Tuesday, November 24, 2009 2:56 AM - 441

help with joining two query
kvanithurai 6 hours 57 minutes ago - 473

select from two tables and add a category
Jassim Rahma Monday, November 23, 2009 9:49 PM - 667

2 versions of case, 1 works, 1 doesn't, why???
MattChandler 7 hours 6 minutes ago - 446

non-ANSI compliant join operators
Altawan 7 hours 11 minutes ago - 1188

Problem With OPENROWSET
lorifajose 9 hours 35 minutes ago - 7172

Run index fragmentation on all databases
MrFlinstone Thursday, November 12, 2009 12:51 PM - 20117

Clusterd index
Abdshall 10 hours 22 minutes ago - 8135

PIVOT question
douglasehowell Thursday, November 12, 2009 2:02 PM


