Search code examples
asp.netsql-server-2005asp-classicsql-server-7

Migrating From SQL Server Server 7 To 2005, What should I get excited about?

The company I work for has decided to join the 21st century and upgrade our main database cluster from SQL Server 7 to SQL Server 2005. As a web developer what new whiz-bang features of SQL Server 2005 should I get excited about or get to know?

Currently I'm mainly writing CRUD style queries, pretty much exclusively using Stored Procdures for a mixed ASP.net and Classic ASP environment.

Solution
    1. system tables are now inaccessible, you will need use the system catalog views. Yes, some of your code needs to be rewrited.
    2. partitioning. You can split very big table into two.
    3. Try..Catch.
    4. Common table expressions (CTE). It's like temporary tables, but more powerful.
    5. Management server, that helps you to register your server groups and then use these groups from any another client place. (maybe it is in 2008 only? I cannot remember)
    6. I don't know about your needs, but I was excited by mirroring. But I'm DBA :)
    7. Some new types.
    8. Snapshots.
    9. Most of your code will still work :)

    and many another things.