An index in SQL is a quick lookup table used to find records that users frequently search for. An index is designed to be small,
Category: RDBMS
Renaming Objects in SQL Server
It is extremely rare to rename any database object once it has been defined; however, if the need arises, one must be aware of how
Deleting Objects in SQL Server
Schema changes are uncommon in some businesses. Dropping the objects is unusual too. When deleting any database objects, one must be cautious because it may
Creating Objects – SQL Server
Although the CREATE, ALTER, and DROP (DDL) commands appear to be extremely straightforward, their use is high and will be used frequently since they deal
MySQL UPDATE JOIN with Aggregate Function in SET
When relational model tables are normalized, as was discussed in a previous post, it may be necessary to join them to obtain the correct records
MySQL UPDATE with JOIN
When tables in a relational model are normalized, it may be necessary to join them in order to fetch the required records or update the
Big Data & SQL 