Partitioning is a way of separating tables into smaller chunks based on partition keys. Partitions, in other terms, are horizontal data slices that allow large
Category: RDBMS
Hive Metadata Queries
Metadata is a type of data that describes and provides information about other types of data, such as database objects. And Hive’s metastore maintains metadata
SQL Server – Altering IDENTITY Values
When a new record is added to a table, SQL Server generates a unique number using the IDENTITY keyword. This is the primary key field
SQL Server – Altering DEFAULT Values
The DEFAULT keyword can be used to assign a default value to a column. If the user’s INSERT statement does not have a specific value,
SQL Server – Partitions on Existing Tables
About the fact that my site’s name is Big Data & SQL, I don’t write much regarding SQL. It’s because I don’t want to repeat
SQL – Searching Unicode Strings
Is it possible to search strings in columns assigned with the Unicode datatype in the same way that we search strings in non-Unicode columns?No, it’s slightly
Big Data & SQL 