How to migrate SQL Database to Azure SQL Database using SSMS deploy
Migrating SQL Database to Azure SQL Database using SSMS Deploy In the previous articles, we had introduction about the Azure…
Azure Pricing Models and Service Tiers
Azure Service Tiers Contents Introduction DTU Based Pricing model What is DTU? Example Different Service Tiers in DTUs base pricing…
Interview question – Is Clustered index on column with duplicate values possible?
Through this article, we are going to discuss three important interview questions of SQL which are given below:- 1) Can…
While loop in SQL server
While loop in SQL server Introduction In While loop, we set a condition for the repeated execution of a Code…
Ranking Functions in SQL Server
Ranking Function:- Sometimes we need to provide a Row number to the rows in a table or within a partition.…
Case Statement/ Expression in SQL Server
Case Statement/ Expression in SQL server Sometimes we need to get one result output from multiple possible outcomes based on…
Isolation levels in SQL Server
Isolation levels :- Isolation level is required to isolate a resource and protect it from other transactions. This is achieved…
SQL Server Functions- An Introduction
SQL FUNCTION: – Function in a database can be defined as the code segment consisting of a logical group of…
Cursor in SQL server
Sometimes our application required a database object which allows manipulation of data from a set of rows on row by…
How to find duplicate values in a table
Sometimes duplicate values in tables can create a major problem when we do not make a primary key or a…