At times in MYSQL an unnatural sort is required. This article presents an easy to maintain set of tables where sorting a table in any order can be easily defined.
Shows how to use the MAX and COUNT functions in MySQL, both separately and in combination, with detailed examples.
In MYSQL the sorting of recordset data can be easily setup and maintained with a few custom tables and a little thought.
The Decision Stream or Data Manager ETL tool has many built in capabilities that assist the data warehouse programmer in generating the data needed by the business.
The SQL update statement provides developers with a way to change data in a table. Learn how to write an update query for your database.
Need to get rid of duplicate records? You can dedupe a table using SQL queries and temporary tables.
Improve SQL Server performance following these five tips for database table design.
Without optimization on SQL select statements, the database server can produce poor performance during queries. Here are two ways to optimize SQL select statements.
Microsoft SQL, as well as other SQL languages, uses JOIN to merge related data from two or more datasets in to one readable result set to perform operations
Data about data is called meta data. Meta data is often housed in a data dictionary. The data dictionary is one of the primary needs of a successful BI team.