Search Database Objects

A stored procedure to search database objects (triggers, scalar functions, table valued functions, views and stored procedures) for a user defined string.

SQL Server Monitoring Using Free Tools

You can do essential monitoring of SQL Server instances and databases with a FREE toolkit!

Performance Tuning Using Free Tools, Part 2

You can do essential performance tuning on your SQL Server databases using a FREE toolkit!

Executing a TSQL batch multiple times using GO

Learn how to execute the same batch of SQL Server commands X number of times using the GO command.

T-SQL Tips and Tricks

In this article learn some TSQL tips and tricks working with CTEs, UPDATES, Window Functions, Duplicate Rows, Tally Tables and Concatenating string values in SQL Server

Getting started with the SQL MERGE statement

This article is focused on beginners who have already started writing SQL queries and are now diving deep towards more data processing and complex queries in SQL. When we talk about data processing, an important concept that comes to our mind is performing ETL workloads to a data warehouse. ETL is a very complex topic […]

Creating and Using Inline Table-Valued Functions

Inline Table Valued Functions (iTVFs) are one type of user defined function that is available to implement in SQL Server since SQL Server 2000.

iTVFs remain a very useful tool in our SQL armoury, so let's quickly revisit them and the different ways we can use them in our code.

Exploring the DATE Functions in SQL

Learn more about using the DATEADD function in SQL...

Collections

Problem The usage of a collection of integers in some scenarios is considered to be optimal because of the overhead involved by the creation of another user table used just to store numbers, which is the most common solution. What are collections of integers? They are lists or arrays consisting of integers. The number of […]

Introduction to PIVOT operator in SQL

Learn how to use the PIVOT operator in SQL in a step-by-step manner.