Views with computed and stored contents are known as materialized views. To put it another way, materialized views are stored on disk and updated on
Category: SQL Azure
Sub-Queries in SQL Server
A subquery is a SQL query that runs within another query. They are nested inquiries that offer data to the query that comes before it.
TRUNCATE TABLE in SQL
TRUNCATE TABLE is a Data Definition Language operation in SQL that marks the extent of a table for deallocation. This operation removes all data from
Min vs Least in Azure SQL
In this post, we will discuss the similarities and differences between two Azure SQL functions, MIN and LEAST. Using both functions, we get the least/minimum/lower
Max vs Greatest in Azure SQL
In this post, we will discuss the similarities and differences between two Azure SQL functions, MAX and GREATEST. Using both functions, we get the largest
SQL-92 and SQL-89 Joins
SQL-92 and SQL-89 joins are supported by most RDBMSs, including Apache Impala. This article will explain how the syntax is written in both ways and
Big Data and SQL 