How to Document Your SQL Server Database
The process of documenting a SQL Server database is a complete and continuous process that should...
Parameter Sniffing Primer
Introduction Developers are often told to use stored procedures in order to avoid the so-called ad hoc queries which can result in...
Several Ways to Insert Split Delimited Strings in a Column
In this article, I will demonstrate several ways to split the delimited string and insert it in into a column of a table in SQL Server. You...
T-SQL SET Operators Part 2: INTERSECT and EXCEPT
In my previous article, I explained the basics of set operators, their types, and prerequisites for...
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 Database Tables Export and Import Methods
When working as a SQL Server database administrator or developer, you cannot live in your isolated SQL Server world without communicating...
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...
Advanced SQL: CROSS APPLY and OUTER APPLY
In this article, we’ll look into the “APPLY” operator and its variations – CROSS APPLY and OUTER APPLY along with examples of...
Concatenation in Transact-SQL
Introduction Assuming you maintain a table containing customer data, and your boss asks you to send...
