If a string is found in a string list with N substrings, the “Find in set” function returns a value in the “1 to N”
DATEDIFF_BIG Function in SQL Server
This function returns the number of times the specified date part boundaries were crossed between the supplied dates (as a signed big integer value). The
MongoDB Cloud in Navicat – Connection Failed
It was described in my previous post how to connect to the MongoDB Cloud in Navicat. If you are having trouble connecting, your IP address
SQL Assignment-2
This is a simple test or assignment to see how comfortable someone is using SQL at the beginner to advanced level. Exercises of this nature
Connecting MongoDB Cloud to Navicat
This article explains how to connect MongoDB cloud to MongoDB Compass, Workbench, and Navicat Premium. Click on “Databases” from the left-side navigator and click on
Reorganize vs Rebuild Indexes
DBAs frequently have to choose between rebuilding the indexes and reorganizing them. Depending on how fragmented the index is, one must make a choice. Reorganizing
Big Data & SQL 