The functions SUM, AVG, COUNT, MIN, and MAX are well-known aggregate functions that we use every day. They are to compute/summarize the multiple rows by
Category: SQL Server
SQL Server Administration, Development and Maintenance
SQL Server 2016, 2017 and 2019 New Functions
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
Big Data & SQL 