Feature Database Articles

Is COUNT(rowid) Faster Than COUNT(*)?

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

How Many Databases Can You Name?

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

How to Find the Estimation Cost for a Query

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

Understanding Views in SQL

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

Introduction to Azure SQL Database Instance Pools

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

A Look at the Oracle Group-by Bug

In Oracle 12.2 and later a group-by elimination enhancement can produce wrong results. …

Creating or Altering an Objects with a Single Statement

Do you get tired of having your CREATE PROCEDURE statement failing if the stored …

Considerations for Deploying Azure SQL Database Managed Instances

Microsoft provides a number of different deployment options for its Azure SQL Database …

Working with SQL Cursors

In SQL cursors serve as a pointer that enables application programming language to deal …

Connecting to a MySQL Database in .NET

Learn how to connect to a MySQL database from a .NET application.

Adding Data to a Cloud Firestore Database

Learn how to add data to a NoSQL Cloud-based database (Firebase Firestore) from a …

Introduction to Firebase

If you are doing a mobile or web-based app that need scalable access to a scalable, …

Verifying Object Exists and Dropping Object with One Statement

Discover how to do both in one SQL Server statement: Verify that a SQL Server object …

Addressing the Drop Column Bug in Oracle 18c and 19c

The latest two versions of Oracle can throw an error when columns are set as unused and …

Introduction to Azure SQL Database Auto-Failover Groups

Auto-Failover Groups addresses several limitations that were in the Azure SQL Database. …