Basics of SQL Server Task Automation
This is an introductory article about automation in SQL server primarily focused on the basic...
T-SQL Regular Expression: LIKE Operator and Its Use-Cases
A Regular Expression (Regex) is a rule defining how characters can appear in an expression. In essence, it is a sequence of characters or...
Calculate the median by using Transact SQL
The statistical median is the value which separates a dataset into halves – one comprises greater values, and the other comprises...
Parameter Sniffing Primer
Introduction Developers are often told to use stored procedures in order to avoid the so-called ad...
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...
Learn Basic Data Analysis with SQL Window Functions
This article is about T-SQL (Transact-SQL) Window functions and their basic use in day-to-day data analysis tasks. There are many...
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...
How to Properly Use the T-SQL IsNumeric Function
This article is focused on the T-SQL (Transact-SQL) IsNumeric function and its proper use in day-to-day SQL scripting tasks. We will also...
T-SQL Datetime Data Type
Introduction Data types are attributes that specify the kind of data that objects such as columns, local variables, expressions, and...
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...
