Configure SQL Jobs in SQL Server using T-SQL
SQL Server Agent is a component used for the database tasks automation. For instance, we need to...
Understanding Text Mining with SQL Example
The current article focuses on the conceptual understanding of Text Mining. It gives clear examples and teaches us to use the T-SQL script...
Filtering Data in T-SQL
Introduction In most scenarios when working with data, users do not require all the data in each instance of a query. T-SQL (and SQL of...
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...
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...
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...
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...
