what is major difference between windows sql 2005 and 2000 sql?
347204
- sql 2005 supports embedded .Net code\n- sql 2005 is more performant\n- sql 2005 is more expensive\n- 2005 has significantly improved mirroring & failover\n\nCheck out this link \nhttp://www.microsoft.com/sql/prodinfo/overview/whats-new-in-sqlserver2005.mspx
1108221
Hey\nSpecialization in what ??? is it design that you want to get hold of or is it Administration ???...\nfigure it out and let me tell you ...u got to be more quicker...\nI am already working on sqlserver 2005 for more than 6 months now..\nunless you upgrade yourself to that as quick as possible.. u will be obsolete..  i suggest that is what you shud aim at... :))\n\nThe thing is Microsoft Certifications is the one you should target at... you can check the info in this link....\nhttp://www.microsoft.com/learning/mcp/mcdba/requirements.asp\n\nonce you finish this let me also know... i too can ask questions to the DB Specialist  ;>)\n\ncheers\n\nBabu\nCovansys
606482
Normally private software have their own way to store data through proprietary format files.\n\nAn Microsoft Access or Microsoft SQL Server can do the same thing (and often better) than those proprietary format but you need to buy them (and they are expensive).\n\nIn fact, Access and SQL Server is normally used by business to keep their information about their customer. I won't tell you the difference between all those databases but if you really need something to work with, I suggest you SQL Server 2005 Express which is totally free. ( http://go.microsoft.com/fwlink/?LinkId=64064 )
235205
There are quite a few differences between the two. Probably too many to really explain fully. If you are looking to begin programming then you should use VB Express 2005 or C# Express 2005 (if you've never programmed before).\n\nVB6 is still a great programming language and is used daily to make good Windows programs. But the versatility and power of the .Net platform make it a better choice. (That is if you are looking to use Microsoft products)
655785
prgramming SQL Server 2000, Wrox - Rs. 825.
1136543
Windows 2003 is the new version of windows server 2000.  Instead of looking for Differences, you should looks for New Features in Windows 2003. \n\nThe new features of Windows 2003 are available on Microsoft website at:
237961
Windows 2000 is newer.  I believe Windows ME is from 1998.
725368
Both SQL Server and Oracle are Relational Database Management Systems. Microsoft Access is not; it is run by a jet engine instead.\n\nMicrosoft created Access in an attempt to compete with FoxPro (a product similar to Access). When Access failed to do compete with FoxPro, Microsoft bought the FoxPro company.\n\nNow for the Oracle and SQL Server, both are Relational Database Management Systems. A Relational Database Management System is capable of supporting concurrency (concurrent access to data), transactions (ablity to excute queries as an atomic block with rollback capability) so it can handle more concurrent users and it is for sure more reliable in a multiuser environment.\n\nIt is very hard to say which (Oracle or SQL Server) is better because there are so many factors that have to be taken into consideration, however SQL Server enjoyes a remarkable growth rate because it is easier to use and more cost-effective than the competing enterprise Database systems like Oracle and IBM DB2. Of course oracle and IBM DB2 have been entrenched in the enterprise for some time now , unlike SQL Server.\n\nOne last point. You can use any of the above products to handle 1000 records, However since you are still learning about Database programming, I suggest you learn either SQL Server or Oracle so that you learn some Database programming concepts like the use of Database objects such as stored procedures, triggers, transactions and so on.
325354
MySQL is the easiest to install and use which uses a client-server architecture.  It runs on windows and Unix-derivitives such as Linux.  It is also extremely fast and blows the pants off of SQL Server.\n\nMicrosoft SQL Server is a good choice for an enterprise-level windows database.  You will need very good hardware to get good performance from SQL Server.\n\nOracle is overpriced and very complex.  It's powerful, but convoluted and takes a lot of skill to manage properly.\n\nOthers to look at include Postgres (like MySQL but not as widely used),  IBM DB2, Sybase, Interbase (Borland)
481723
Are you running windows Server edition?  If so, you can install SQL Server and then install the clients on your workstations.. But you definately need SQL Server.. \n\nThere are alternatives to SQL Server.. you can use MySQL which is free.. However you need to run a webserver from your computer.. like apache..
235181
1> When a lot of records exist in a single table, indexing is an issue\n2> Procedure compilation is a bit limited than oracle\n3> Works only on Windows platform\n4> No rollback segments as like in Oracle\n5> Archivelog not supported well as in oracle\n6> Not for very large data warehouses
536173
In order to manage a MS SQL 2005 DB you need SQL Management studio, that includes adding/importing data and/or DB objects to an 05 instance.\n\nOne quickie you can try is to detach/and attach the database.  To do this, go into Enterprise Manager, right click on the DB and select "All tasks > Detach ..."  this will disconnect the database from the server.  Now, go into the file system, create a copy of the MDF and LDF files.  Rename both of those files to the new database name (while maintaining the LDF/MDF extensions), and copy the new files to the 05 server's Mssql.x directory (where "x" is the instance number you are attaching to).  Go into the Enterprise Manager and right click on the database server and select the "All Tasks > Attach ..." option.  Browse to the file on the 05 system and select it.  \n\nIf that doesn't work, you're SOL.
573813
difference: they are manufactured by different people, you can use them for the same purpose!!\n"MySQL is a database management system.\nA database is a structured collection of data. It may be anything from a simple shopping list to a picture gallery or the vast amounts of information in a corporate network. To add, access, and process data stored in a computer database, you need a database management system such as MySQL Server. Since computers are very good at handling large amounts of data, database management systems play a central role in computing, as standalone utilities, or as parts of other applications."\n\nWhat Is SQL Server 2005?\n\n"SQL Server 2005 is a comprehensive database platform providing enterprise-class data management with integrated business intelligence (BI) tools. The SQL Server 2005 database engine provides more secure, reliable storage for both relational and structured data, enabling you to build and manage highly available, performant data applications that you and your people can use to take your business to the next level."
373931
in general there is no major difference like Windows 2000 and XP. The only big difference is the speed of the operating system. Windows 95 runs much slower. Also a big differece is software/program compatebilty. I read in the newspaper(SF Chronicle) that a study was conducted and shown that 95% of programs/software that is created and sold today are not compatible with Windows 95.IF you are to choose between geeting a used computer with Windows 95 or 98, get neither. because if you can wait, in fall or winter of this year (2006) a new windows operating system, called windows vista will be released. then the prices of windows XP upgrade CD'S or computers will drammaticaly drop because it will be really cool!!!. good luck.
92683
- There is no difference between Data Access Object 3.5 and Data Access Object 3.6.\n- Only a few patches added which cannot be identificed since its internal handling large database.\n- all the best.\n-------------
103644
there is no 'the' difference.\n\nthey are so dis-similar, one could spend a number of years cateloggin their differences.....\n\nI want a million dollars !      it's good to want.\n\nwe both have a similar chance of getting what we want, via this forum.\n\nluck !\n\n\ndude...those links will just be defining them, not listing their differences....\n\nOMG...Greeney that's wrong.\n\nDOS was around LONG before there was windows.  IT DOES NOT need windows to operate. It CAN run under windows, BUT windows 1,2, and 3 needed DOS under THEM to run.\nLOL
502545
you get different kind. ie external and internal attributes.\n\nit depends on the software that u r trying to use.\n\nu can also view this web page.\n\nhttp://research.microsoft.com/~cszypers/events/WCOP2005/08%20-%20Happe%20Firus.pdf