Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2002
    Posts
    13

    Red face Unanswered: Sql Server 2000 new Features ?

    Please help ,

    What are the major differences between SQL SERver 7 and 2000 ?
    Looking for a job and found a position where the client prefers the database developer specifically expericenced in SQL 2000.
    What is really so hot and important to know?

    THanks a lot .

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Did you get hired?

    Just Google "what's new sql 2000" or go to the ms site...

    Do you know sql 7?

    Where's the gig?

    Contract or full time?

    Need any contract help?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Feb 2002
    Posts
    13
    Hi,

    Nope, not hired yet. The reqruiter mentioned that client is very specific about SQL Server 2000 . So, SQL Server7 cannot be considered , which sounds weird. But, welcome to new economy . Hiring managers have a big pool begging for a job.

    MS site is helpful, for sure , checked it out already. But , not necessary useful, since most of the features are not in use by the majority.

    Cheers

  4. #4
    Join Date
    Jan 2004
    Location
    Boston
    Posts
    58
    I almost sigh everyday in work when seeing one more reason we should upgrade to SQL 2000. The differences, or in better words advantages, are really countless. Here are a few from top of my head:

    table variable
    user defined function
    better log shipping
    better clustering
    schema change on article without severing replication
    support up to 8 GB memory on SQL 2K ent.
    multiple instances of install
    and even - looping
    DBCC command without multiple annoying lines of "execution complete" messages!

    viola!

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Originally posted by li810
    Hiring managers have a big pool begging for a job.
    REALLY? WHERE?

    What country are you in?

    MS site is helpful, for sure , checked it out already. But , not necessary useful, since most of the features are not in use by the majority.
    Cheers
    Hey lookey what I found...a Brian Knight Demo...If you don't have his Admin 911 book....it's a must have...

    http://www.topxml.com/conference/wro...iank_sql2k.pdf
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  6. #6
    Join Date
    Feb 2002
    Posts
    13

    Smile

    >What country are you in?


    Thanks for presentation, looks informative.

  7. #7
    Join Date
    Feb 2002
    Posts
    13
    What country are you in? same as you
    Garden State

    Thanks for presentation, looks informative.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •