Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

Feature Database Articles

MS SQL

CONCAT and STUFF Functions in SQL Server 2012 04/20/2015

The difference between the CONCAT function and the STUFF function lies in the fact that CONCAT allows you to append a string value at the end of another string value whereas STUFF allows you insert or replace a string value into or in between another string value. Read on to learn more about these functions and their real life usage.

Automating Image-Based Deployment of SQL Server on Azure IaaS VMs - Preparing OS Image 04/06/2015

There are several different approaches to automating deployment of SQL Server Infrastructure-as-a-Service (IaaS) virtual machines in Microsoft Azure. Marcin Policht examines an approach that involves uploading or creating a custom operating system image, including a pre-staged SQL Server installation, which is well suited for scenarios where you want to deploy a custom-configured SQL Server instance to multiple virtual machines with minimal effort and maximum consistency.

T-SQL Programming Part 13 - Selecting Data Using the TOP Clause 04/02/2015

There are times when you don’t what to return a complete set of records. When you have this kind of requirement to only select the TOP X number of items Transact SQL (TSQL) has the TOP clause to meet your needs. In this article Greg Larsen explores how to select a subset of data from a record set.

more...

Oracle

More Than Oracle Knows What To Do With 04/13/2015

In Oracle 12c an interesting problem arises with ANSI joins, star expansion and tables with 500 columns or more.  Read on to find out what happens and how you can work around the problem.

Hitting The Oracle Target 03/30/2015

SGA and PGA management can be confusing.  Oracle can make it easier with two views that provide advice on how to set the associated parameters.  Read on to see what those views are and how to read the data.

CBO, Analytic functions and Cardinalities in Oracle 11.2 03/12/2015

In Oracle 11.2 using analytic functions can generate 'interesting' cardinality values that are far larger than they should be.  Read on to see just how far off those values can be.

more...

MS Access

more...

DB2

Disaster Recovery and Big Data 04/16/2015

Big data applications are not usually considered mission-critical: while they support sales and marketing decisions, they do not significantly affect core operations such as customer accounts, orders, inventory, and shipping. Why, then, are major IT organizations moving quickly to incorporating big data in their disaster recovery plans?

Exploding the Myths of Big Data 03/16/2015

As big data application success stories (and failures) have appeared in the news and technical publications, several myths have emerged about big data. This article explores a few of the more significant myths, and how they may negatively affect your own big data implementation.

Another Look at Tuning Big Data Queries 02/16/2015

Most large organizations have implemented one or more big data applications. As more data accumulates internal users and analysts execute more reports and forecasts, which leads to additional queries and analysis, and more reporting. The cycle continues: data growth leads to better analysis, which generates more reporting. Eventually the big data application swells with so much data and querying that performance suffers. How to avoid this?

more...




Latest Forum Threads
DB2 Forum
Topic By Replies Updated
tables get lock during backup in db2 v9.5 Hamsoo 0 May 8th, 01:03 AM
Query to Pull Last 7 days records from a table vgoushik 0 March 20th, 06:05 PM
DB2 Visual studio addin: ANSI/Unicode problem 10Pints 0 October 5th, 02:08 AM
Things that are everbodys labor day ideas? Lipsett197 0 September 1st, 09:42 AM













Thanks for your registration, follow us on our social networks to keep up-to-date