TRUNCATE TABLE is a Data Definition Language operation in SQL that marks the extent of a table for deallocation. This operation removes all data from
Category: RDBMS
Naming Conventions in SQL
Why is a naming convention required in SQL? The short answer is READABILITY. A naming convention is a set of rules that you decide on
Aliases in SQL
In this post, we’ll go over aliases in SQL Server. The following are some key points about Aliases. In SQL Server, aliases can be used
Disable and Enable Index in SQL Server
This topic describes how to disable and enable an index in SQL Server. Disabling an index prevents users from accessing the index and, in the
Data Types in SQ Server
The allowed data types in SQL Server are listed below, along with their complete descriptions. Beginners should be aware of these data types and their
DROPPING INDEXES
The DROP INDEX command can be used to delete a non-primary key index. However, this method cannot delete indexes created as a result of a
Big Data & SQL 