dcsimg
Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
SQL Scripts & Samples
Tips
» Database Forum
» Slideshows
Free Newsletters:



Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Database Management & Programming News, Articles & Tutorials for Database Administrators

Featured Database Articles Rss Feed

Become More Efficient at Writing TSQL by Creating Code Snippets 06/30/2021

Snippets are a great way to jump start creating TSQL code for common tasks, like creating a table, a stored procedure, a trigger, an index, and more.

What Is a TSQL Code Snippet, How Would You It, and Why? 06/29/2021

With snippet, you can insert a block of code into an existing query window to help jump start your TSQL script writing.

Ten Favorite Keyboard Shortcuts in SQL Server Management Studio 06/28/2021

Every mouse click or menu choice takes your hands away from the keyboard, and slows down your work.  Use these 10 keyboard shortcuts to make your workflow fly.

Discarding Results of a Query Execution in SQL Server Management Studio 06/28/2021

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

Delaying Standby Database Recovery 06/10/2021

Does it ever make sense to delay database recovery from your Standby? With the right DB recovery strategy in place, delays might be your best move.

What Backups Do I Have? 05/12/2021

As a DBA you need to check periodically to make sure you have backups.  I would recommend you do this daily.

Improving the Performance of a Table Variable using Optimizer Hint RECOMPILE 04/01/2021

To improve the performance of your code that uses numerous table variables, consider adding the optimizer hint RECOMPILE.

TYPE Definition Change in Oracle 21c 03/04/2021

Oracle 21c now offers the possibility of using some PL/SQL data types in SQL*PLus, with some restrictions.  Read on to see what types are available and how to use them.

Overview: Six Backup Options for SAP HANA on Azure VMs 02/25/2021

You've got a number of options open to you to perform backups of SAP HANA running in Azure virtual machines (VMs).

Tip 74 – Changing Cost Threshold for Parallelism 02/24/2021

Anytime the optimizer calculates a plan that exceeds a given threshold, the optimizer will consider using plans that will go parallel.

Database Tips

Overview: Six Backup Options for SAP HANA on Azure VMs 02/25/2021

You've got a number of options open to you to perform backups of SAP HANA running in Azure virtual machines (VMs).







Recent Headlines
Oracle
TYPE Definition Change in Oracle 21c 03/04
more...
MS SQL
Tip 74 – Changing Cost Threshold for Parallelism 02/24
more...
MS Access
more...
DB2
more...