Database Journal

Daily Database News, Information and Tutorials for the Database Professional

[Database Journal @DatabaseJournal]

Is COUNT(rowid) Faster Than COUNT(*)?: It is believed that count(*) expands to all columns and that count(rowid) is faster.  Read on to see why the opposite might be true. https://t.co/JKXVDYxoEc

[Database Journal @DatabaseJournal]

How Many Databases Can You Name?: There is a huge number of databases available. How many could you name? Create our list and then compare to our list of well over 100 databases! https://t.co/frofkHOBQr

[Database Journal @DatabaseJournal]

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 extract the Estimated Cost for execution plans stored in the procedure cache.   https://t.co/LuZEGeAXt0

[Database Journal @DatabaseJournal]

Understanding Views in SQL: Learn about the concept of views in SQL, and how they work. Read on to see clear examples of how to implement views. https://t.co/p8ObZwTba4

[Database Journal @DatabaseJournal]

Introduction to Azure SQL Database Instance Pools: Learn about Azure SQL Database Instance Pools and how they they set to provide more flexibility and agility than other Platform-as-a Service SQL Server-based offerings in Azure. https://t.co/ecRAfD5ji3

[Database Journal @DatabaseJournal]

A Look at the Oracle Group-by Bug: In Oracle 12.2 and later a group-by elimination enhancement can produce wrong results. Read on to see what can be returned and how to work around it. https://t.co/91vrzE3ceo

[Database Journal @DatabaseJournal]

Creating or Altering an Objects with a Single Statement: Do you get tired of having your CREATE PROCEDURE statement failing if the stored procedure already exists? Read on to learn a better solution for avoiding this.  https://t.co/clk0WGD3Cy

[Database Journal @DatabaseJournal]

Considerations for Deploying Azure SQL Database Managed Instances: Microsoft provides a number of different deployment options for its Azure SQL Database offerings. While most of them share the same characteristics, one in particular warrants special… https://t.co/vnTj6HJgxi

[Database Journal @DatabaseJournal]

Working with SQL Cursors: In SQL cursors serve as a pointer that enables application programming language to deal with query results one row at a time. Read on to explores the concept behind and learn how to declare cursors, open, retrieve data from… https://t.co/oLZM61P0o7

[Database Journal @DatabaseJournal]

Connecting to a MySQL Database in .NET: Learn how to connect to a MySQL database from a .NET application. https://t.co/yWQ7KS2YJ3

[Database Journal @DatabaseJournal]

Adding Data to a Cloud Firestore Database: Learn how to add data to a NoSQL Cloud-based database (Firebase Firestore) from a simple web application. https://t.co/1nlgYnOarB

[Database Journal @DatabaseJournal]

Introduction to Firebase: If you are doing a mobile or web-based app that need scalable access to a scalable, multi-user Cloud-based database that includes analytics and other features, then Firebase is worth taking a look. Read on to learn about the… https://t.co/1J4rzBL4Cd

[Database Journal @DatabaseJournal]

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 exists and drop the object. https://t.co/SdNeBYSNsR

[Database Journal @DatabaseJournal]

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 then dropped. Learn about this issue and how to address it. https://t.co/g7kKjp0BOL

[Database Journal @DatabaseJournal]

Introduction to Azure SQL Database Auto-Failover Groups: Auto-Failover Groups addresses several limitations that were in the Azure SQL Database. Read on to learn more! https://t.co/UqIssxddmk

[Database Journal @DatabaseJournal]

How do OODBMS and ORDBMS Differ from RDBMS?: Get a high-level understanding of how object-relational and object-oriented database management systems differ from traditional relational database management systems. https://t.co/9FvuqLc7Ng

[Database Journal @DatabaseJournal]

The New SQL Server Approximate Count Distinct Function: With the introduction of SQL Server 2019, Microsoft introduced a new method to count distinct values that can be faster and uses less resources. Read on to learn more! https://t.co/cEOALxcqxE

[Database Journal @DatabaseJournal]

Understanding Query Execution in Relational Database System Architecture: What happens behind the scene in a modern relational database management system when a user submits a query until the result is obtained from the database? Read on to learn more! https://t.co/oT3edAbsun

[Database Journal @DatabaseJournal]

Running Database Console Commands (DBCCs) on Azure SQL Database: Discover the primary characteristics of Database Console Commands (DBCCs) on Azure SQL Database and explore their role in Database-as-a-Service scenarios. https://t.co/NnmFMq0FfQ

[Database Journal @DatabaseJournal]

Using Oracle EXPAND_SQL_TEXT: Database tables are not static entities and sometimes changes can wreak havoc on packages and procedures.  Read on to see how Oracle's expand_sql_text can help solve such issues. https://t.co/5foYGsFhUp