If you are using SQL Server 2016 version and still you are getting the error Invalid object name ‘STRING_SPLIT’ as shown below while using the functions
Category: RDBMS
Word Count in SQL Server – String_Split Usage
STRING_SPLIT is a table-valued function that splits the words from the input text and returns into rows. This function has been introduced in SQL Server
Identify the active node in SQL Server Cluster
Probably most of the DBAs are already aware of how to identify which is active SQL Server node in the clustered environment, however, this will
Reason to convert datetime to bigint – What is epoch time
In my previous article, I had discussed the conversion of bigint value to date time in both PostgreSQL and SQL Server. It raises several questions
PostgreSQL BigInt Value – Conversion to UTC and Local Times
Most of the ticketing systems by default use either MySQL or PostgreSQL and often stores the date-time of the DML events in Bigint format. When
Computing Running & Cumulative Average
This article helps you understand how to calculate the running average and cumulative average on a given data set. As discussed earlier, windowing functions
Big Data & SQL 