How to Rename a Table Name in SQL Server
One of the most critical database administrator’s duties is managing database objects. For...
Top 5 Facts to Find and Replace SQL Texts in SQL Server with REPLACE Function
Today’s code editors and word processors come with a search and replace feature. It is helpful when you need to change a word or a...
MySQL Insert Command vs T-SQL Query Syntax with Examples
Developers are lifelong students. Gaining new knowledge as fast as we can is always our gig. If you’re coming from the T-SQL camp,...
SQL Server Delete Statement: How to Remove One or Multiply Rows from the Table
The right application of the DELETE statement for data removal is crucial, and it involves lots of...
Difference Between DELETE and TRUNCATE Table in SQL Server
Many articles have been written to describe the difference between the SQL DELETE and SQL TRUNCATE statements. Moreover, it is one of the...
SQL UNION Cheat Sheet with 10 Easy and Useful Tips
Having a hard time with SQL UNION? It happens if the results you combined put your SQL Server into a standstill. Or a report that’s been...
Create a Database in SQL Server Using SQL Server Management Studio (SSMS)
This article briefly explains creating a new database with the New Database wizard of SQL Server...
Fundamentals of Managing Datafiles in SQL Server
Introduction Datafiles are physical objects that constitute the most important part of the database system since they contain actual data....
Use Cases for SQL Server MERGE Statement: Syncing Online and History Tables
INTRODUCTION The SQL Server MERGE statement is an incredibly useful tool for carrying out DML operations based on comparing two tables or...
Manage MDF Files in SQL Server 2019
An SQL Server database contains primary data files, secondary data files (optional), and...
