Reindexing tables is an important part of good database housekeeping, because it reorganizes the indexes and restores speedy access. Microsoft's SQL Server has a handy command that rebuilds all ...

In most implementations of SQL, you pull information from two tables by using a SELECT command in this form: SELECT table1.column1, table1.column2, table2.column1, table2.column2 FROM table1, table2 ...

The ease and ubiquity of SQL have even led the creators of many “ NoSQL ” or non-relational data stores, such as Hadoop, to adopt subsets of SQL or come up with their own SQL-like query languages.

SQL is a programming language designed for working with what are known as relational databases. Those are systems designed to store information in sets of tables that can be related to each other ...

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us.

There a number of pure Java SQL database systems develolpers can embed into applications. In this tip we introduce two open source projects, HSQLDB and Apache Derby.