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?
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.
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:
user defined function
better log shipping
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!