Problems with memory use are frequent when working with AWS RDS MySQL. The max connections parameter could be the reason. Instead of relying on the
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
Can we rename a view in SQL Server?
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
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
Big Data & SQL 