Database Management Articles for MS SQL. Oracle, DB2, Access, MySQL, PostgreSQL & PHP

Snippets are a great way to jump start creating TSQL code for common tasks, like …

With snippet, you can insert a block of code into an existing query window to help jump …

Every mouse click or menu choice takes your hands away from the keyboard, and slows …

Here's how to turn off those distracting results when you're simply testing a query.

Does it ever make sense to delay database recovery from your Standby? With the right DB …

As a DBA you need to check periodically to make sure you have backups. I would …

To improve the performance of your code that uses numerous table variables, consider …

Oracle 21c now offers the possibility of using some PL/SQL data types in …

You've got a number of options open to you to perform backups of SAP HANA running in …

Anytime the optimizer calculates a plan that exceeds a given threshold, the optimizer …

It is believed that count(*) expands to all columns and that count(rowid) is …

There is a huge number of databases available. How many could you name? Create our list …

Discover how to estimate the cost of a query. Read on to see an example of how to …

Learn about the concept of views in SQL, and how they work. Read on to see clear …

Learn about Azure SQL Database Instance Pools and how they they set to provide more …

Feature Database Articles