Tag: Database

Delete duplicate rows from SQL table

Delete duplicate rows from SQL table. How to delete duplicate rows without a primary key? Select only unique rows using CTE.  For the demonstration purpose, I have created a dummy database with employee table. which has […]

Let’s understand the Transact-SQL

T-SQL or Transact-SQL is a proprietary SQL extension (design query language). Additional features include high performance, maximum functionality, and greater globalization support. Transaction SQL is a Microsoft SQL Server process implemented. It is widely compatible […]

Advantages of NoSQL Database over RDBMS

The NoSQL database is a data loading approach different from the relational database. NoSQL’s differences are considered as an additional chart and document, key-value, column, to name. MongoDB is schematic of less. It is a […]

MongoDB vs MySQL Comparison

Relational databases, and to a degree MySQL, have become the backbone of commercial organizations. Programmers and database developers have been engaged in a tug-of-war, deciding the best place to store and execute the business logic. […]

Alternatives ORM for Entity Framework

Entity Framework has come a long way since version 1. So much that it leapfrogged every other version up to version 7. With EF Core 2 out, I feel this gives us the performance and versatility […]