The MIN and MAX functions in SQL Server can be used separately on a column level to find the lowest and maximum value of a
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.
First Value and Last Value Functions in SQL Server
The First_Value function in SQL Server returns the first value in an ordered set of values and the Last_Value function returns the last value in
SQL Server Built-in Functions
In SQL, a built-in function is a programming object that takes zero or more inputs and returns a value. A feature that is built into
Partitioned, Bucketed and Skewed Tables in Hive
When working with a large amount of data on a Hadoop file system, both partitioning and bucketing in Hive are used to avoid table scans
When to avoid bucketing in Hive
When working with large datasets that need to be divided into chunks for better management and the possibility to connect queries with other large datasets,
Apache Sqoop vs Apache Flume
The goal of choosing an ETL solution is to ensure that data enters Hadoop at a rate that meets analytic requirements, and top-rated Hadoop data
Big Data & SQL 