Although changing the name of the view using the sp_rename command is allowed, it is advised to first delete the current view before creating a
Category: RDBMS
VIEWS vs Materialized Views in SQL
Here are listed the key distinctions between Views and Materialized Views. This material has been gathered throughout time from a variety of sources and books.
MATERIALIZED VIEWS in SQ Server
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
Big Data & SQL 