create | Dataprix TI

Promoted Resources

Today's Top Picks for Our Readers:

Recommended by

Don't you have a chop with useful queries to use in your daily adventures and desventures with the database? I include in this first post a…

A simple way to export data from a query, table, etc.. of an oracle database to a flat file is to use the SPOOL command in SQLPlus. This…

The operator to concatenate in SQL Server is '+', but this operator is also used to add values. Being the same operator for both, the…

A very powerful way to do a table's update in a SQL Server database is to link it with another table with a join, and updating the fields…

Have you ever wondered how to disable the autocommit option in Sql Server Management Studio? The answer is quick. Simply uncheck the option…

Db2look is an utility to extract the definition of database objects.

Slowly changing dimensions or SCD (Slowly Changing Dimensions) are dimensions in which their data tend to change over time, either…

Pentaho was created in 2004 and at this moment, it is the leader of the Open Source BI solutions. It offers a large spectrum of resources…

Looking for a v-gel? Not a problem! Discreet Package Low Prices 24/7/365 Customer Support 100% Satisfaction Guaranteed. >>>…

MySQL, like most database managers, can easily modify the parameters that control memory sizes engaged in certain tasks, resource…