Advanced SQL Server (RDBMS) Blog

23

SQL Server Statistics

About Statistics: Statistics is nothing but just like data about data and containing information about the column values of table or index. Many factors are important for Sql server performance like types of locking,...

3

Data Partitioning

Partitioning is a techniques where we can divided any database object into multiple parts like Table, Index etc. What is a table partitioning? Table Partitioning is a way where very large table divided into...

2

Table Variables

What is Table Variables Table variables like variable, its creating as variable like DECLARE statement. Table variable table’s schema create in tempdb database and data store in Memory and its name start with hash...

5

Common table Expression (CTE)

What is Common table Expression Common table expression (CTE) is a temporary result set and store the result set like normal view that can be use within a SELECT, INSERT, UPDATE, or DELETE statement....

6

Correlated and Subqueries

What is SQL Query SQL is a Standard Query Language for storing, manipulating and retrieving data in databases. SQL is a programming language(Query programing language) like PHP, Java, .net etc language use for application...

2

Derived Tables – Sql server

Derived Tables are similar to table variables it’s exist in memory only many deferent is table variable need to declare and derived table always create within a select statements, its also called to Subsquery....

3

Merge Statement

MERGE statement generally used in warehouse ETL process where we need to perform multiple operations like insert, update and delete data in target table based source table. MERGE statement joins target to source by...

23

What is DBMS

DBMS(database Management System) is System for manage data in database system. Types of database Management System: Mainly 4 types of database management system(DBMS) available but 1 more NoSQL can considered in DBMS 1.Hierarchical DBMS...