Mathematical Functions are built-in scalar functions that perform calculations depending on input values provided as arguments and return a numeric value. We’ll go through the
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
Can permanent and temporary tables with the same name coexist?
Temporary tables in SQL Server are prefixed with “#” and table variables with “@,” thus they can have the same name as permanent tables and
Definitions of Big Data, Hadoop and Ecosystem Components
Commonly used terms in Hadoop / Big Data are described in this post. VMWare: A hypervisor is installed on the physical server using VMware server
Multi Insert in Apache Hive
Multiple records in the same table is a well-known technique. But in this post, we’ll look at inserting into multiple tables using a single expression.
DIFFERENCE function in SQL Server
The DIFFERENCE() function returns an integer after comparing two SOUNDEX values. The integer number, ranging from 0 to 4, indicates the match between the two
DATEFROMPARTS in SQL Server
It may be necessary to integrate the several elements of the date into one. In such cases, SQL Server’s DATEFROMPARTS function will come in handy.
Big Data & SQL 