A picture is worth a thousand words and this image proves it all…a great reference point when you are dealing with choosing the algorithm for
Month: July 2021
Did You Know…That 0% Cost in SQL Query Plan is Not Actually 0%
This post is a part of the series “Did You Know” whereby the purpose is to share some quick key point of a particular concept
Spark and Databricks Runtime Version
You can check the version of Spark running on the cluster your notebook is attached to as follows – … and to check the Databricks
Power BI: Use COUNTROWS instead of COUNT
Both COUNT() and COUNTROWS() functions accepts single parameter. The difference lies in the fact that COUNT() operates over a column whereas COUNTROWS() asks for the
Get Started With Azure Cloud Shell
Azure Cloud Shell is a command line interface to work with Azure resources for different administrative tasks. If you are not an administrator, a developer
Artificial Intelligence (AI) Feature(s) in SQL Server/Azure SQL Database
As shown in the previous post that Artificial Intelligence has become or if not convinced yet then let’s say that is becoming an integral part
SQL Script to Check Unused or Bad Indexes
sys.indexes, sys.objects and sys.dm_db_index_usage_stats Checks where writes are greater than the reads i.e. index maintenance is higher than the benefit it is serving during read
Did You Know…This About GPU Enabled Computers and Deep Learning
This post is a part of the series “Did You Know” whereby the purpose is to share some quick key point of a particular concept
SQL Script to Check Index Fragmentation
This may take some time to get executed if tables are heavy in the database sys.indexes, sys.objects and sys.dm_db_index_physical_stats() Mode can be “Sampled”, “Limited” or
How to Awake or Develop a Leader in You
I have always been saying that more than a professional, we are humans and the interpersonal skills that we develop as part of our usual