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...
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...
Your Ultimate Guide to SQL Join: CROSS JOIN – Part 3
CROSS JOIN is in the spotlight. This article finishes our small series of SQL JOIN-related publications. If you missed the previous two...
Add Columns to an Existing Table in SQL Server Database
Introduction A table is a two-dimensional logical structure and the fundamental means of storing...
Your Ultimate Guide to SQL Joins: OUTER JOIN – Part 2
Outer join is at the center stage today. And this is part 2 of your ultimate guide to SQL joins. If you missed part 1, here’s the...
The Easy Guide on How to Use Subqueries in SQL Server
Do you use SQL subqueries or avoid using them? Let’s say the chief credit and collections officer asks you to list down the names of...
Filtering Data in T-SQL
Introduction In most scenarios when working with data, users do not require all the data in each...
Auto Create Statistics and Auto Update Statistics
Statistics comprises lightweight objects that are used by SQL Server Query optimizer to determine the optimal way to retrieve data from the...
Advanced SQL: Variations and Different Use cases of T-SQL Insert Statement
In my previous article, I demonstrated: Insert the output of the table-valued function in the SQL table. Insert the output of the...
SQL Server Bulk Insert – Part 2
In the previous part of this article, we discussed how to import CSV files to SQL Server with the...
