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.
MYSQL Custom Field Sorting Revisited
Examples of Using the COUNT and MAX Functions in MySQL
Shows how to use the MAX and COUNT functions in MySQL, both separately and in combination, with detailed examples.
MYSQL Custom Field Sorting
In MYSQL the sorting of recordset data can be easily setup and maintained with a few custom tables and a little thought.
Decision Stream Derivation Expression Operators
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.
How to Write a SQL Update Statement
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.
How to Deduplicate Data from Tables in SQL Server
Need to get rid of duplicate records? You can dedupe a table using SQL queries and temporary tables.
How to Design a Database Table for SQL Server
How to Optimize SQL Select Statements
Without optimization on SQL select statements, the database server can produce poor performance during queries. Here are two ways to optimize SQL select statements.
What is a JOIN in Microsoft SQL?
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 Dictionary and MetaData
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.