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.
DATALENGTH Functions in SQL Server
DATALENGTH is a function that returns the number of bytes used to represent any expression. This looks similar to LEN function that helps in identifying
Big Data & SQL 