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

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

Some guidlines for posting questions...
Clifford Dibble - MSFT Friday, October 28, 2005 4:58 PM - 04

UPdate Trigger
muzzettemm1 34 minutes ago - 11201

Query with Pivot
aslowmo Tuesday, November 03, 2009 10:14 PM - 279

Subordinates of employees
wael.kader 15 hours 38 minutes ago - 384

Error Handling & Transactional Handling in SQL Server 2008.
Priyaa Saxena Friday, November 06, 2009 12:48 PM - 6185

CREATE INDEX WITH DROP EXISTING taking more time than DBCC DBREINDEX
Kasturi Rajesh Monday, November 02, 2009 2:54 PM - 581

SQL import: unknown xml tags
tmacdonaldmpower Friday, November 06, 2009 8:54 PM - 10164

Insert same record many times
JohnGalt Monday, November 02, 2009 2:59 PM - 3169

Any advice regarding my table structure and writing stored procedures to be used by my ADO.Net dataset?
Paul Mackintosh Sunday, November 01, 2009 5:21 AM - 12108

Query help
AznDude Friday, November 06, 2009 11:13 PM - 5108

Insert to temp table
Mathewsept Friday, November 06, 2009 8:15 PM - 24647

Cursor Looking At Next Row Without Moving Cursor Forward
JustinK101 Tuesday, August 04, 2009 8:27 PM - 167

Transactions in Distributed Server Architecture
Nick Bean Friday, November 06, 2009 9:19 PM - 479

How to handle date ranges which cannot overlap?
lesotho_kid Friday, November 06, 2009 7:40 PM - 165

Native Support for PHP in Visual Studio 2010
UCSD Eric Friday, November 06, 2009 10:02 PM - 275

is it possible to add a new column inbetween the existing column instead of at the last using alter script?
kchokkal Friday, November 06, 2009 9:56 PM - 165

Optional innerjoin parameter?
AznDude Friday, November 06, 2009 9:34 PM - 888

Unknown Value in Query Results - Warning Aberration# 102
Vega Discoveries Friday, November 06, 2009 9:10 PM - 260

Using a pointer to a local varaiable in Dynamic SQL
RakuRay Friday, November 06, 2009 7:14 PM


