Easy Answers to 5 Vital Questions about Composite Index in SQL
Imagine you need to query a table with a WHERE clause on columns a, b, and c. Sometimes, you filter...
The Cartesian Product in SQL
Cartesian product in SQL is a term from the set theory of mathematics. However, we can also find this term in SQL database manuals. What...
Clustered and Non Clustered Index: 7 Top Points Explained
Indexes are speed-boosters in SQL databases. They can be clustered or non-clustered. But what does it mean and where should you apply...
Simple SQL Server Functions to Solve Real-World Problems
Introduction Today’s article comes from a scenario we experienced in practice some time ago. We...
MySQL UPDATE: Top 5 Tips for T-SQL Developers
Are you adding MySQL to your list of database skillsets? Then MySQL UPDATE statement is one of the commands you need to learn. We are...
SQL DEFAULT Constraint to Insert Column with a Default Value to SQL Server Table
To insert data into a table having columns with default constraints, we can use the DEFAULT constraint to a default value in a table. This...
Install SQL Server 2019 Ubuntu Linux Server Step by step
After exploring the processes of building a virtual machine to install Ubuntu Linux 18.04 (refer to...
Installing Ubuntu 18.04 for SQL Server 2019 on Virtual Machine Using VMware Workstation
Microsoft has been supporting SQL Server for Linux-based operating systems since the SQL Server 2017 release. The current article will...
Understanding of SQL Server UPPER Function
There are many cases of SQL lowercase that we need to change for our purposes. For instance, we have keywords or strings of characters in...
Understanding SQL DELETE Column from Table
Adding and removing columns are among the most common tasks when you manage tables in databases....
