• VBScript "save as" example code now productised. Allows packages to be manually put into SourceSafe.
• Parameters may be passed via DTSRun
• DTS specific job in SQL Agent
• New custom tasks for ftp and msmq
• New custom transforms for speed – upper/lower, read/write file, datetime etc.
• ATL templates supplied for users to write their own custom tasks and transforms
• DTS to replace the Web Assistant
• Re-startability – step and package level restart for aggregation.
• Heterogeneous PK/FK/constraints – Oracle/Access etc.
• Disconnected edit mode.
• Test mode support for global variables.
• Support for linked servers.
• UDL bindings done at run-time.
• Easier to move packages between servers
• Parallel data pump – no UI for this though.
• Can write log info to SQL tables as well as flat files now. Tables kept in msdb. Sysdtspackagelog, stsdtssteplog, sysdtstasklog
• More progress info for packages supplied. Requires all package tasks to run on the main thread if using VB.
• Support for MDAC/OLE-DB 2.5/2.6 datatypes. Chaptered rowsets supported. Primary/Foreign Key knowledge for SQL Server, Oracle, Sybase etc.
• OLAP Cube and Data Mining tasks.
• ActiveX script browser.
• Transformation property editor. Rename transforms, add/remove columns.

SQL Profiler

• Time and size based profiles. E.g. start at 15:00.
• High level performance analysis via supplied Excel pivot tables
• New trace events – autogrow, showplan, auditing
• Filters on spid, date/time
• Much better at working on heavily stressed systems
• Connection based like query analyzer.
• Scenario based templates based on deadlock, replay, tuning, stored-procedure etc. Easy to add new templates.
• Support for large traces – 4GB
• SQL Trace integrated into engine.
• Files written out on server side (if you want) for performance, not via profiler – SQL 2000 only.
• File format changed to be self-describing – reduces footprint.
• XP replaced by internal server stored procedures because these scale better and reduce blocking issues.
• File roll-over when file gets to a certain size.
• Addition of C2 auditing events, data/log growth/shrink, showplan.

Index Tuning Wizard

• Able to scale up sizes of tables to production sizes if you don’t have full size tables
• Upgraded to support/recommend indexes on views and computed columns
• Can now be scheduled and applying it’s recommendations also scheduled.
• Displays indexes recommended to be deleted
• Index analysis in QA replaced with full index tuning wizard – works on script file or high-lighted section within script.

SQL Server 2000 Preview 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19