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
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.
SQL Server Identity Functions
Identity values are handled by a number of functions in Microsoft SQL Server. The functions assist in establishing the automatic sequential value for table rows,
Data Tools Comparison
This is a comprehensive list of articles on this website that compare various softwares, programs or features that aid in either file system, data analysis
Data Platform Job Roles
This is a collection of articles regarding job roles in data platforms that have been published on this website. This will provide a clear image
Skewed Tables – All Articles
This is a collection of articles regarding skewed tables in Hive that have been published on this website.
Apache Impala Architecture
Impala is a massively parallel query engine that runs on hundreds of servers in existing Hadoop clusters. Unlike standard relational database management systems, where query
Big Data & SQL 