Transact-SQL
TSQL challenges? This is the place for advice / discussions
공지 사항
SQL Server 2008 SP1 released
Ed LehmanMSFT2009년 4월 8일 수요일 오후 6:16Service 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.
필터링 및 정렬토론 목록의 범위를 좁히려면 이러한 옵션을 사용하십시오.
- 010615

New Site: Solutions to Common T-SQL Problems
Arnie RowlandMVP2008년 4월 12일 토요일 오후 2:52 - 124964

Some guidlines for posting questions...
Clifford Dibble - MSFTMSFT2005년 10월 28일 금요일 오후 4:58 - 14

How does the use of CTE tables affect execution times for stored procedures?
Antoine123 6분 전 - 9139

PIVOT question
douglasehowell 2009년 11월 12일 목요일 오후 2:02 - 331

sort table
snorlaks 1시간 1분 전 - 7101

Test Post for Moderators
Arnie RowlandMVP15시간 3분 전 - 341

Delete the Duplicate records from table without using temp table
Ritesh Handa 1시간 28분 전 - 128

Urgent:Need to update my time dimension using a procedure
Ramakrishnan.lh 1시간 23분 전 - 039

Table Update Help Needed
Sulaman 1시간 15분 전 - 476

How Can excute this SQL Statement
Maged Hany 2009년 11월 24일 화요일 오전 11:19 - 8106

update question
HelenGlez 2009년 11월 23일 월요일 오후 3:31 - 9937

SQL Server 2008 - An invalid floating point operation occurred
Underated 2008년 10월 3일 금요일 오전 8:56 - 9168

Stored Procedure called from the application is slow (Java)
DogTog 2009년 11월 12일 목요일 오후 10:26 - 21347

T-SQL Solutions: Most Intuitive vs. Best Performing
SQLUSA 2009년 11월 10일 화요일 오후 10:27 - 579

subtracting millisecond from datetime
Asharaf Ali P 6시간 38분 전 - 348

Dynamic stored procedure execution form in SQL Server 2005 Management Studio is missing.
Rudy68 7시간 44분 전 - 582

Aggregate errors
LindCums 7시간 21분 전 - 353

Restore
goms 8시간 44분 전 - 138

Access Object
goms 7시간 54분 전 - 248

date comparision and calculating
cnsuman 9시간 18분 전

