• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

SQL 7 v SQL 2000.. the difference?

I work with SQL 7 and SQL 2000 and haven't come across any differences that have affected my developement...

one thing that SQL2000 has that SQL 7 does not is 'ON DELETE CASCADE' which comes in handy. I also find detaching and restoring
databases in SQL2000 to be a tad easier.

I'm sure there are a lot of implementation differences too. I know that SQL2000 has a lot more XML support than SQL7 as well.

Sorry, but that's about all I know 😱
 
its been a long ass time since I used either, but I think the 2000 version allows you to select from a stored procedure. Its pretty damn cool and I wish other dbs allowed that.
 
SQL 2000 has a lot of new features from SQL 7

Some biggies:

Much smarter optimizer
"Table variables" (temp tables made with declare statement rather than create statement are held in RAM rather than disk backed for speed. Unfortunately these tables which are local to your session still use locks though).
Graphical view of query plan showing estimated % of query taken by each step.
Braindead ping functionality so query analyzer & such can automatically find it on a network through a broadcast (used primarily by SQL Slammer).
 
from a development standpoint---the biggest difference I came into was speed (yes it was faster)
and user-defined functions now available (which can be nice---but coming from 6 years of using MS-SQL, it's made me have to think about how to use & design the data layer (not structure, but implementation on the db side))

A minor thing in the overall spec---but the query tool---is light years better, IMO. Bought time you could have a list of your sh!t w/o having to alt-tab back and forth.

Admin---
Clustered Servers are also load balancing now in SQL 2000---so you don't have Server A working for Server B to die---they both respond---and it works especially well if they go off of a shared drive array $$$$.
I could care less about that feature---

That's all I know other then what's been already said
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top