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.
- 010581

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

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

convert access IIF into sql
Izmzusa 3 hours 8 minutes ago - 1074

SQL Query, Group By?
Westside2008 2 hours 1 minutes ago - 254

Handling Multiple Constraints - Beating SQL Server into Submission
JaedenRuiner 4 hours 49 minutes ago - 137

Trigger to Handle CASCADES on Update and Delete - SET NULL
JaedenRuiner 1 hour 41 minutes ago - 228

select from two tables and add a category
Jassim Rahma 1 hour 21 minutes ago - 7144

Determine Windows registry default backup path for any version of SQL Server
Ivo ComputerDoc Friday, November 20, 2009 6:03 PM - 235

Update x number records at a time
Rudy68 1 hour 26 minutes ago - 10107

Group date field together
SQL_1980 7 hours 42 minutes ago - 131

How to display a date based on user input from a php form
bmblack 1 hour 23 minutes ago - 233

How to Update "linked" values in two tables at once?
Robert Werner 2 hours 1 minutes ago - 248

MailMessages() (system.net.mail) - Save
Sallyhere 3 hours 58 minutes ago - 297

Get the last 3 working date from a given date
Prashanth Kumar Saturday, November 21, 2009 5:08 PM - 637

Shred string into word segments
Roger Binny 3 hours 47 minutes ago - 573

Looping through a Field..??
Roger Binny 6 hours 34 minutes ago - 455

Stop "Use" of Database in order to drop
JaedenRuiner 5 hours 11 minutes ago - 452

SQL Insert to prevent duplicates
Ronald-L 5 hours 0 minutes ago - 772

Can CREATE but not GRANT EXECUTE
Brian Tkatch 6 hours 45 minutes ago - 342

convert datetime to nvarchar(50), How?
Kumar03 6 hours 8 minutes ago


