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

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

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

Dynamic stored procedure execution form in SQL Server 2005 Management Studio is missing.
Rudy68 22 hours 30 minutes ago - 269

Trigger to Handle CASCADES on Update and Delete - SET NULL
JaedenRuiner Monday, November 23, 2009 9:29 PM - 394

What is the best way to design a table for keeping a schedule?
new to sql server Tuesday, November 24, 2009 11:55 AM - 881

How to enter an image to table through the SMSE?
code_warrior Tuesday, November 24, 2009 1:09 PM - 15197

Could not find stored procedure 'dbo.EditAuthors'
StevenPKent Sunday, November 15, 2009 5:37 PM - 7125

Trigger or inside same store procedure ?
Serge Calderara Thursday, November 19, 2009 2:05 PM - 140

A single stored procedure that runs against two (or more) identical databases
CougarDave7309 4 hours 21 minutes ago - 140

Datetime Parameter set to Null works or what's wrong?
sqlserverdotnet 4 hours 7 minutes ago - 195

making 3 rows out of 1 row, an elegant solution
Craig G Tuesday, November 17, 2009 3:18 PM - 6104

Problem - PIVOTING with CASE Statement & Grouping Values
AvenueStuart Tuesday, November 17, 2009 5:11 PM - 386

Temp table vs Query builder in SP
AshokTeli Wednesday, November 18, 2009 6:19 AM - 179

Insert dynamic array/list of parameters in XML datatype column using XQUERY?
Saad Khan Wednesday, November 18, 2009 8:25 AM - 258

bcp with .csv file
dreamweaver547 9 hours 25 minutes ago - 10119

how to find the common part of two or more rows and truncate the common part
Archan Mukherjee Monday, November 16, 2009 8:36 AM - 6111

cursor help needed!
DoorKnobs Tuesday, November 17, 2009 10:22 PM - 2968

Error using a distributed query - Cannot obtain the schema rowset "DBSCHEMA_INDEXES"
AndyCutler Monday, September 08, 2008 9:53 AM - 167

Change DEFAULT_SCHEMA of a remote DBs user.
Brian Tkatch Thursday, November 19, 2009 4:57 PM - 26165

Problem With OPENROWSET
lorifajose Tuesday, November 24, 2009 6:52 PM

