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

SQL Server Programming FAQ, Apr 2010
sqlFans Thursday, April 15, 2010 3:15 AM - 06172

POSTING TIPS - source code, screen images, details within...
Phil BrammerMVPTuesday, December 01, 2009 10:19 PM - 018493

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

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

Multiple Values to the Variable, HOW?
Kumar03 6 hours 1 minutes ago - 270

Comparing columns with NULL values--Merge says unmatched when data is matched.
JesseDeveloper 4 hours 23 minutes ago - 11127

(almost) duplicate records returrning
Wes Crockett Thursday, September 02, 2010 7:54 PM - 981

Piviot Function usage
Kajoo 9 hours 28 minutes ago - 156

Highlight Opening and Closing Parenthisis in Query Analyzer 2008
Gannonator 2 hours 35 minutes ago - 470

How to get column value difference of rows in same table
neolim 5 hours 2 minutes ago - 170

SQL query Joins
ione721 4 hours 5 minutes ago - 7347

How does the IN ( ) clause affect performance?
jdyoumans Friday, August 27, 2010 7:02 PM - 28234

Row size error
OLAPWisdom Tuesday, September 07, 2010 11:35 AM - 968

can an alias column be used in a WHERE clause
arsalan khan 6 hours 25 minutes ago - 19110

select distinct best row based on a condition
João Passos 9 hours 39 minutes ago - 7140

Grouping by week, but show day range
JustinK101 Tuesday, September 07, 2010 11:07 PM - 18515

will indexes auto sort?
Pacerier Tuesday, August 17, 2010 2:50 PM - 354

SQL Job does not fail if Targeted drive does not exist
nana123 9 hours 10 minutes ago - 149

Declaring variables with values
NashVegas 5 hours 7 minutes ago - 045

Logon Trigger blocking problem
James12314909 5 hours 11 minutes ago