To make your queries run faster, you should avoid unnecessary joins that do not add any value to your results. For example, if you only need data from one table, do not join it with another table ...

Comments are a way to add internal notes or annotations to SQL queries to explain or clarify the code. Headers can provide an overview of the query, such as its name, author, date, description ...

Fetching data from the database takes a lot time process. eventually when you need to combine multiple tables in order to fetch the data, reducing database calls becomes very meaningful. although in ...

When you execute a query using the RIGHT JOIN syntax, SQL does two things: It returns all of the records from both tables that contain matching values, as defined by the ON clause.

I checked it again recently though and now it does something very handy indeed: it allows you to pass parameters to SQL queries. Before this, if you wanted to use parameters in your SQL, you had to do ...

A few days ago I was tagged on a thread on Twitter: my old pal Mim was upset to find that he couldn’t use a SQL query with a Common Table Expression as the source of a table in DirectQuery mode. He ...