Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.

A join combines two or more tables side by side. If you do not specify how to join the tables, you get a Cartesian product. This means that SQL combines each row from the first table with every row ...

How to Reindex SQL Tables. The indexes on a the tables of a large database make a huge difference in its performance and utility. Without an index, locating a single record in a large table can ...

How to Find All Scheduled Jobs in SQL. Microsoft's SQL Server database software includes a job scheduling system which lets you perform routine business activities such as reporting and database ...