Difference between MSDE server and Sybase SQLAnywhere Databse server?
494528
SQL Server 7.0 vs MSDE 1.0\n\nhttp://www.mssqlcity.com/Articles/Compare/SQLvsMSDE.htm\n\nread it v good
1084809
http://msdn.microsoft.com/vstudio/previous/2003/sysreqs/default.aspx\n\nIf you're using this type of software, why don't you know where to look for this information?
150748
Companies use Oracle more than Microsoft, although it'd be good to get some experience with SQL.  I've used both, and never seen any real huge difference between the two.  The coomands are generally the same, the logic is generally the same.
281205
My experience with MySQL / Sybase / SQL Server when you DON'T have an ODBC complient data source is the create (in the native language of the source information) an output file of SQL insert statements.\n\nFor example, if the data source is three fields (F1, F2, and F3) that have the values 1, "a", and 3 in the first record, I'd create a program that reads from the source and outputs into a text file....\n\nINSERT INTO newfile (F1, F2, F3) VALUES (1, 'a', 3) GO\nINSERT INTO newfile (F1, F2, F3) VALUES (....\n\nThen, I'd just use the batch function of the SQL database to execute that text file as a SQL script.
1141405
I prefer MySQL, but I don't use .net
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)
225602
SqlConnection cnn = new SqlConnection("Data Source=ariesdell; Initial Catalog=Northwind;Integrated Security=SSPI");\nSqlCommand cmd = new SqlCommand("backup database northwind to disk = 'c:&#92;Northwind.bak'");\n\ntry {\ncnn.Open();\ncmd.Connection = cnn;\ncmd.ExecuteNonQuery();\n}\ncatch (Exception ex)\n{\nMessageBox.Show(ex.Message);\n}
309931
Sybase is a database product.  Don't bother learning it.  It's not a significant player in the industry anymore.  Learn Oracle instead.  If you like open source software, learn MySQL.
520840
It would be helpful to know what version of SQL you want.\n\nFor Transact-SQL (Microsoft): http://msdn.microsoft.com\n\nFor MySQL: http://forums.mysql.com/\n\nFor PL/SQL (Oracle): http://education.oracle.com/
1132129
Read this short review:\nhttp://en.wikipedia.org/wiki/DBMS
682045
sql server is an application that runs on a server. It provides to a developer and easy way to implement database functions. Yes, it is faster than doing it with other methods.
1135447
One thing they both have in common is that they are both powerful and excellent SQL database management systems, evolved from years of constant research and improvement. They are both more than capable of handling large amounts of data and heavy workloads on Linux, Unix, and Windows, provided the DBAs and sysadmins are adequately trained. Proof of the capabilities of both Oracle and DB2 can be found at http://tpc.org which publishes the results of strictly regulated database benchmarks that must be independently audited for accuracy in all areas.\n\nAlthough limited editions of many database products, including DB2 and Oracle, are available for production use at no cost, DB2  Express-C edition is far less limited: Express-C allows the use of dual-core CPUs, 64-bit addressing, up to 4GB of system RAM, and no data size limit whatsoever.\n\nOracle stores its tables within schemas of an instance, while DB2 has the concept of a database that sits above the tables but below the instance level.\n\nOracle manages usernames and passwords within the DBMS, while DB2 uses O/S level groups, usernames, and passwords for authenticating connections to DB2. However, DB2's authentication can be adjusted to use LDAP, Active Directory, or third party authentication plugins like Kerberos.\n\nEach DBMS offers a different dialect of proprietary SQL that you may decide to use in your applications. However, it is possible to minimize or even eliminate proprietary SQL in favor of ANSI standard SQL. Some shops will even go as far as to demand that proprietary SQL in the application be kept to a minimum just in case they decide to migrate to a different DBMS someday.\n\nOracle and DB2 offer different types of storage enhancements for their tables. As with most differences between the two, the pros and cons of each difference are hotly debated. \n\nOn the high end, when a database is partitioned across multiple machines for improved scalability, DB2 uses a shared-nothing architecture in its Data Partitioning Feature, while Oracle Real Application Cluster requires a shared disk. \n\nIn about a month, IBM will be releasing version 9 of DB2 for Linux, Unix, and Windows, which will offer many new features, including a hierarchical storage engine (pureXML) that is optimized for truly native handling of XML data, not just shredding it or treating it as a BLOB/CLOB. DB2 9 will also offer a completely new mechanism for compressing data within each table that is arguably superior to Oracle's compression scheme, since patterns within a column can be compressed, as well as patterns of data that span multiple contiguous columns. \n\nAnother new interesting feature unique to DB2 9 is an autonomic performance tuning subsystem called self-tuning memory management, that can be enabled to constantly monitor important configuration settings and adjust them to maximize performance, even as the workload changes. This is a big help for DBAs who would tune for OLTP and get clobbered when the workload switched over to a series of batch jobs each night.
254248
For what you are doing, there is no practical difference.\n\nThere are differences in terms of complex database activities, such as using triggers; changing server variables on the database server; error handling; the nature of the way data is returned, and other very complex, vary narrow semantics.
1080020
Can you install a seperate named instance?  You should be able to run multiple servers under different named instances.  Uninstallations that dont complete are usually pretty hairy but this feature of Sql 2k5 should at least give you some workaround.
724162
for a database system you can use something like windows 2003 or windows NT for distributed systems you can use windows NT or linux
717198
A collection of tables and other objects that support an application is called a schema.\nA database is a collection of system and schema data stored in files.  The files are organized into tablespaces for ease of reference.\nAn instance is the collection of processes that open the database and provide services to other programs and users by communicating with user sessions.\n\n- If you select a tablespace of an existing database for your application, you need to know what other applications are using that database instance.  Your performance will depend on how much resources of that database are already tied up by the other application schemas and sessions.  Your application will also have to shut down when those other applications need downtime for maintenance.  When the other users of that database upgrade to another version of oracle, you will have to upgrade with them.\n- If you select another database, the server that your database will run on needs to have enough resources to support two SGA memory structures.  You would be able to have that database tuned specifically for your database and to keep it running when the other database is down.  However, if the server is not large enough for two databases, your performance will suffer.
195744
SQL Enterprise Manager only comes with full version of SQL Server 2000 not MSDE.\n\nWeb based client - http://www.aspenterprisemanager.com/\n\nSQL Server Management Studio Express (SQL Server 2005) - http://www.microsoft.com/downloads/details.aspx?familyid=57856cdd-da9b-4ad0-9a8a-f193ae8410ad&displaylang=en