Tutorial on SQL (DDL, DML) on the example of MS SQL Server dialect
Introduction This tutorial includes information about SQL (DDL, DML) that I have gathered during my...
Basic and Complex Uses of Not Equal Comparison Operator in T-SQL
This article is focused on the T-SQL Not Equal comparison operator (<>) and its uses in basic to slightly complicated SQL scripting...
T-SQL SET Operators Part 1: UNION and UNION ALL
In SQL Server, we can combine the same type of data from multiple tables using SET operators. After combining multiple SQL statements, it...
Automatic gathering of SQL Server configuration by using PowerShell
At present, the gathering of SQL Server configuration information is no longer a problem— the...
Using Trace Flag 3226 to Suppress Log Backup Logging
Introduction Every backup operation in SQL Server is written to the SQL Server Error log. This includes Transaction Log Backups even when...
Column-level and row-level tracking in merge replication
In this article, let us review row-level and column-level tracking options in merge replication and how these are used in detecting...
Overview of DBCC SHRINKFILE Command
Running DBCC Shrink commands is quite a controversial issue across the SQL Server community. In...
The Difference Between Primary Key And Unique Key
“What is the difference between a primary key constraint and a unique key constraint?” This is probably the most frequently-asked job...
How to Export Data to Flat File with BCP Utility and Import data with Bulk Insert
The BCP (Bulk Copy Program) utility in SQL Server allows database administrators to import data into a table and export data from a table...
Overview of DBCC CheckDB Function
Introduction Regular database maintenance is an important part of a Database Administrator’s job...
