SQL Server High availability: Add new disk to an existing failover cluster instance
In my previous article, I have explained the step-by-step process of installing a node in existing...
Installing SQL Server Failover Cluster Instance – Part 1
In this article, I am going to explain the process of installing SQL Server on failover cluster instance (FCI) on the primary node. First,...
T-SQL Regular Expressions: SUBSTRING, PATINDEX and CHARINDEX
In my previous article about T-SQL regular expressions, I have explained the LIKE operator, its usage and provided several examples with...
Transact-SQL: Working With Strings
Microsoft SQL Server has many built-in functions that can be used to format the output and...
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...
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...
Update SQL Server statistics using a database maintenance plan
Database backups, integrity checks, and performance optimizations are core regular tasks of DBAs. The client data is very important for a...
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...
