SQL Server 2000

It doesnot support as facility like oracle . It is very hard make backup of the database when it is corrupted.it is not working properly on lan when it contain heavy database .it fail in the multiple user eniverorment . Its interface is very complicated .its pris is very high as compare to mysql.it dependency on hardware .it will not work on linux os .hard to manage in web application when any error occur on database side.Bigdata concept is included I this version of sql.this version is less secure.

• 
  • Flag This Review
  • Irrelevant
  • Fake
  • Junk
• Thank You! We appreciate your effort.

Hello All, As per the my opinion I was using SQL Server 2000 but in current market It is a oldest version of Microsoft SQL Server no doubt to SQL 2000 is password protected, Secured to compare others. But we are not survive with this in latest technical market. Because it not have capacity to work with large amount of data that is comes to on law performance and it is a biggest disadvantage of Microsoft SQL Server, but we have the some latest versions of SQL Server which are more power full then SQL 2000, We have latest versions like SQL 2008, SQL 2012, SQL 2014 which have a capacity more then SQL Server 2000. So, all readers I suggest you please choose a latest technology and platform to Improve your performance and make more secure your data.

• 
  • Flag This Review
  • Irrelevant
  • Fake
  • Junk
• Thank You! We appreciate your effort.

This is my new review on Microsoft SQL Server 2000. It is also known as MS SQL. MS SQL is used to store data, and its password protected, and it is having good security.

Ok, now lets start my review on main thing...

Introduction: This is Database server from none-other then Microsoft Corporation. This software is used to store data which user enteres on application or on web site. SQL Server handle all the database files, and also it keeps data protected with encryption.

Installation: This is tuff part of this software.Installation of this software is bit technically and need some information about your web server.. well that is there in all Database server, else the installation of this software is at normal speed, takes about 5-6 minutes.

Resources: This server needs quite a good resources.. Like it takes 300 MB of Hard Disk space. and It needs 256 MB Ram but 128 MB Ram will do work.. but your computer will work slow. Overall Resource taken by this Server is at normal level.

Features: MS SQL comes with great features.. It is now XML Enabled, Multi Database support, and lots of other things.. In its earlier version if you want to delte any field from the table then you have to do lots of coding.. but now in MS SQL 2000 there is no need to do lots of coding, Its now very easy. And also I like one more feature in it that, in past version of MS SQL if you want to create its temporary data while some one is entering data so that database does not get corupt.. we have to do lots of coding.. but now MS SQL 2000 Server is having option we can directly select that or we can do it by very small codes.

Data Handling: MS SQL 2000 Server is now supporint very heavy traffic on database. It can now support more than 1000+ users at one time.. But if your database is having more than 5000 entries than it gets very hard for SQL Server 2000 to support more than 1000 users if you do not care of your Server. So here it has its minus point. Else its performance is very nice. But need to take care.

Ease of Use: MS SQL Server 2000 is very easy to use. If you want to create its database its very easy then previous version and also having lots of options. If you want to open database using Web Pages you have to just pass some queries whereas eariler you need to tell provider and lots of things u need to done. Now its very easy.

Protection: Protection under MS SQL Server 2000 is superb compare to MS Access and IBM's Database but compare to Oracle 9i its nothing. MS SQL 2000 Server has recived one certificate in security, whereas Oracle 9i has recieved total 14 certificates. MS SQL Server 2000's encryption is very nice and its very hard to break.. But there is nothing is not-possible in the world.. people have discovered to break MS SQL 2000 server. But it takes lots of time in breaking security of MS SQL 2000 Server.

Uninstallation: Uninstallation of this software is very easy but it takes some time in uninstalling.. because first it will stop server then some process it takes.. so It takes some time in Uninstalling...

For Whom: I recommed this product to only very big company which company is having largest database, other can go for other databases like MS Access. I prefer MS Access for small database.. But If I have to go for Large Databases then I will choose MS SQL. Because its reliable and very fast. Only thing is we have to take its care.

Overall I will give 4 no. of rating to this product, It has loose one point because to take care and security is not much stonge as Oracle Database Server.

That's all about Microsoft SQL Server 2000. If you think some information is not there please tell I me.. I will enter those informations ASAP.

© 2002 ĎħåvåĻ ƒāŗĭā.

• 
  • Flag This Review
  • Irrelevant
  • Fake
  • Junk
• Thank You! We appreciate your effort.

Note: This review is little bit technical and funny to follow.

Company Profile

If any one has to learn the game of Perfection, it has to be from Microsoft, They observe competitors very closely and the moment they feel there competitor has a product which has future they simply come up with an new product which takes out the life of the rival product.

Here are few instances

•Apple Macintosh introduced GUI(Graphic User Interface) technology and the next moment Microsoft perfected it by releasing Windows.

•Lotus and wordstar came up with an spreadsheet and word processor packages for day to day business needs and the next moment Microsoft perfected it by releasing MS Office in one shot.

•Boroland came up with OOP’s (Object Oriented Programming) based C++ and the next movement Microsoft perfected it by releasing VC++.

•Unix brought an revolution in networking technology and now the famous Windows NT came out from Microsoft.

•Then to my subject of review today database ORACLE Corp became de facto king in database market and Microsoft released SQL SERVER with a bang.

I hope thats enough of the company background, now straight away lets get into the review.

Introduction

In today’s Internet world were e-commerce is the new mantra of IT Managers, database plays a very vital role.

In most simple terms Database is all about the way you store and retrieve information in a relational manner.

New Features in SQL-Server 2000 I like the most

•XML Enabled

you can use XML documents to directly insert and update SQL Server tables.

This will definitely help in sharing of content.

•Triggers

In 7.0 version triggers were ment to fire when an action takes place, but a new flexibility is added in 2000 version were by now users can execute instead of triggering action.

•New DataType

The most interesting aspects regarding 2000 version is the addition of table itself as a data type which permits us to store temporary data in it.

•Cascading Declarative Referential Integrity

Now its very simple to set a relationship between an parent and a child table and then update or delete rows in the parent table automatically cascades to corresponding rows in the child table.

For those of you who are having SQL-Server 7.0 and are thinking of upgrading:

Some of the functions which are present is sql-server 7.0 do not work in 2000 for example following commands do not work

default sortorder id

resource timeout

extended memory size

spin counter

language in cache

time slice

language neutral full-text

unicode comparison style

max async IO

unicode locale id

For those of you who have hardware limitations I will Advice you to stick to 7.0 if you are satisfied with its functionalities.

SQL Server 2000 is very demanding in resources it does not work on Pentium Pro machines, and requires 270 MB HDD(Hard Disk) space instead of 180 MB HDD space for full installation for 7.0 version.

My Final conclusion is that, go for it if you need a feature only present in it and not in 7.0

Thanks for listening to me.

• 
  • Flag This Review
  • Irrelevant
  • Fake
  • Junk
• Thank You! We appreciate your effort.