There are several string and analytical functions introduced with the newer versions of SQL Server and are listed below. STRING_SPLIT is a table-valued function introduced
Approximate Count of Unique Values in SQL Server
In my previous blog, I discussed the approximate count of unique values for which a predefined function is available in Impala (NDV), Oracle 12c (APPROX_COUNT_DISTINCT)
SQL Server 2016 – Compatibility Issues – Invalid object name
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
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
Big Data and SQL 