T-SQL Regular Expressions: SUBSTRING, PATINDEX and CHARINDEX
In my previous article about T-SQL regular expressions, I have explained the LIKE operator, its...
Transact-SQL: Working With Strings
Microsoft SQL Server has many built-in functions that can be used to format the output and represents it in the desired format. In this...
How to Update SQL Server Statistics for Big Tables
In my previous article, I have briefly covered database statistics, its importance, and why statistics should be updated. Moreover, I have...
Calculate the median by using Transact SQL
The statistical median is the value which separates a dataset into halves – one comprises...
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...
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...
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...
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 their use. I also talked about UNION...
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,...
