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
SET ANSI_NULLS ON – SQL Server
The setting for ANSI NULLS should be ON while running distributed queries. When creating or altering indexes on calculated columns or indexed views, ANSI NULLS
SET NO COUNT ON – Stored Procedures
For every statement in a stored procedure, SET NOCOUNT ON stops procedure outcome messages from being sent to the client. In other words, setting NOCOUNT
Stored Procedures in SQL Server
Introduction: A collection of SQL statements is referred to as a stored procedure in SQL and is stored together in a database. It can execute
MySQL RDS – Publish logs in Cloudwatch
You can access the logs that are produced by each RDS database engine for auditing and troubleshooting. Your database engine determines the kind of logs
Usage of ROW Keyword in MySQL
Subqueries that are scalar or column return a single value or a column of values. A subquery variant known as a row subquery returns a
Big Data & SQL 