http://www.dbatodba.com These are the search results for the query, showing results 1 to 10. http://www.dbatodba.com/mysql/how-to/how-to-create-a-mysql-database How to Create a MySQL Database No publisher josana 2009-01-30T20:11:02Z Page http://www.dbatodba.com/mysql/how-to/advanced-mysql-user-variable-techniques MySQL’s user variables have interesting properties that enable the useful techniques. One property is that you can read from and assign to a user variable simultaneously, because an assignment can be an r-value (the result of the assignment is the final value of the variable). Another property, which sometimes causes confusing behavior, is un-intuitive evaluation time. This post show you how to make sure your variables get updated at the time they’re used, instead of potentially reading and updating them at different stages of query execution. This technique enables a whole new range of applications for user variables. As a bonus, it also avoids extra columns of output created by variable manipulations. No publisher josana 2009-01-30T20:13:42Z Page http://www.dbatodba.com/postgresql/problem-resolution/postgresql-naming-rules This chapter covers the basic operation of PostgreSQL, including naming conventions, creating a database, and indexing. No publisher josana 2009-01-30T20:10:14Z Page http://www.dbatodba.com/postgresql/problem-resolution/postgresql-hardware-performance-tuning POSTGRESQL is an object-relational database developed on the Internet by a group of developers spread across the globe. It is an open-source alternative to commercial databases like Oracle and Informix. POSTGRESQL was originally developed at the University of California at Berkeley. In 1996, a group began development of the database on the Internet. They use email to share ideas and file servers to share code. POSTGRESQL is now comparable to commercial databases in terms of features, performance, and reliability. It has transactions, views, stored procedures, and referential integrity constraints. It supports a large number of programming interfaces, including ODBC, Java (JDBC), TCL/TK, PHP, Perl, and Python. POSTGRESQL continues to improve at a tremendous pace thanks to a talented pool of Internet developers. No publisher josana 2009-01-30T20:09:41Z Page http://www.dbatodba.com/mysql/how-to/8-essential-mysql-queries Here's a list of queries used very often and that save a lot of development time. No publisher josana 2009-01-30T11:05:19Z Page http://www.dbatodba.com/db2/how-to-do/how-to-determine-the-owner-of-a-lock Determine which transaction is holding the lock. Display information about the current locks by running the db2pd command with the -locks attribute. No publisher josana 2009-01-30T10:39:52Z Page http://www.dbatodba.com/sql-server/how-tos/moving-sql-server-database-files Over time the requirements of a SQL Server system can change. Sometimes this will necessitate the relocation of databases from one disk or server to another. This can be easily achieved using the standard SQL functions to detach and attach databases. No publisher josana 2009-01-29T19:53:24Z Page http://www.dbatodba.com/sql-server/how-tos/dynamic-xml-from-sql-server In this article you have seen how to generate XML from a relational table using SQL server 2005 and with the introduction of the xml datatype in SQL we are able to store and retrieve XML data easily. While the FOR XML clause gives us the power to tailor the XML to our needs. No publisher josana 2009-01-29T19:53:59Z Page http://www.dbatodba.com/oracle/how-to/modifying-oracle9i-object-tables-and-object-types When you make an object table, you identify what object type is to be used for each row in the object table. The attributes that you see when you look at the table in Schema Manager are actually the attributes of the object type. You can modify a few characteristics of the object table, as shown in the following section. Adding or removing attributes in an object table, however, must be performed by modifying the underlying object type, which is discussed in the second section. No publisher josana 2009-01-29T19:54:36Z Page http://www.dbatodba.com/db2/db2-eee/efficient-query-processing-for-multidimensionally-clustered-tables-in-db2 Efficient Query Processing for MultiDimensionally Clustered Tables in DB2 No publisher josana 2009-01-28T12:07:13Z Image