Transact-SQL
TSQL challenges? This is the place for advice / discussions
公告
SQL Server 2008 SP1 released
Ed LehmanMSFTWednesday, 8 April, 2009 18: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.
篩選及排序使用這些選項可縮小討論清單。
- 010609

New Site: Solutions to Common T-SQL Problems
Arnie RowlandMVPSaturday, 12 April, 2008 14:52 - 124963

Some guidlines for posting questions...
Clifford Dibble - MSFTMSFTFriday, 28 October, 2005 16:58 - 334

Dynamic stored procedure execution form in SQL Server 2005 Management Studio is missing.
Rudy68 2 小時 22 分鐘前 - 20328

T-SQL Solutions: Most Intuitive vs. Best Performing
SQLUSA Tuesday, 10 November, 2009 22:27 - 442

subtracting millisecond from datetime
Asharaf Ali P 1 小時 15 分鐘前 - 684

Test Post for Moderators
Arnie RowlandMVP9 小時 41 分鐘前 - 551

Aggregate errors
LindCums 1 小時 59 分鐘前 - 345

Restore
goms 3 小時 22 分鐘前 - 128

Access Object
goms 2 小時 32 分鐘前 - 1213629

How to delete/drop all the tables from SQL Server Database without using Enterprise Manager?
Nishith Shah Wednesday, 13 September, 2006 8:42 - 349

Temporary Tables inside a procedure
sanoj_av 3 小時 19 分鐘前 - 240

variable in Order By clause will affect output
John_Kong 3 小時 42 分鐘前 - 261

What is the best way to design a table for keeping a schedule?
new to sql server 20 小時 42 分鐘前 - 235

String pattern - TSQL 2005
Superdec 3 小時 40 分鐘前 - 367

Login via Sproc
goms 21 小時 44 分鐘前 - 5860

How to import data from Access2007 to SQL 2005
Yo__ Tuesday, 29 January, 2008 19:53 - 585

month/year datetime comparisons
DoorKnobs 12 小時 9 分鐘前 - 45263

Exception Error 5123 - Unable to attach database
rupertsland Tuesday, 29 January, 2008 20:52 - 665

fastest way to copy huge data
dhariwal57 17 小時 11 分鐘前 - 1181

I was givin a quiz with 10 questions
chuckdawit 10 小時 2 分鐘前

