Series

T-SQL HUB

Welcome to the T-SQL Resource Hub! This page is dedicated to sharing helpful Transact-SQL code snippets, techniques, and best practices for working with Microsoft SQL Server databases.

Articles in this series

Find Top 10 CPU Intensive Queries

Apr 4, 20241 min read

If you want to find the top ‘n’ queries that are currently in the cache, which are consuming more CPU, then you are at the right...

Find Top 10 CPU Intensive Queries

How to Find Duplicates in SQL SERVER: A Step-by-Step Guide

Apr 5, 20242 min read

Hi techies in this article we would see what are the different ways in which we would find duplicates in SQL SERVER 1) Identify the Columns to Check...

How to Find Duplicates in SQL SERVER: A Step-by-Step Guide

Database, Table, Column and it's datatype

Apr 7, 20241 min read

I used this script because I was concerned regarding the default of Varchar(max) being used inappropriately. This script showed me the extent of the...

Database, Table, Column and it's datatype

Search Database Objects

Apr 9, 20241 min read

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

Search Database Objects

Validating different types of data like Gmail, Outlook email addresses, phone numbers, and URLs

Apr 19, 20241 min read

Validating different types of data like Gmail, Outlook email addresses, phone numbers, and URLs in SQL can be a bit challenging since SQL is primarily...

Validating different types of data like Gmail, Outlook email addresses, phone numbers, and URLs

SQL SERVER – Checking If a Column Exists in a Table

Apr 20, 20242 min read

One of the common tasks that developers deal with when working on database-related projects is ensuring that certain columns exist in a table. This...

SQL SERVER – Checking If a Column Exists in a Table