SQL Logic

In this article, I will discuss the history and thinking behind several types of logic that are typically associated with writing relational database code.

Does Your GROUP BY Order Matter?

Sometimes when you do GROUP BY, the order of the columns does matter. For example, these two SELECT queries produce different results:

Pagination and ordering by large values

Pagination is a technique for limiting output. Think of Google search results, shopping the electronics category on Amazon, or browsing tagged questions on Stack Overflow. Nobody could consume all of the results in a single shot, and no site wants to spend the resources required to present them all to us

Finding Sister Locations to Help Each Other: Answers & Discussion

This week’s query exercise asked you to find two kinds of locations in the Stack Overflow database.

LIKE Condition for Date

Check Azure SQL DB Space Used

Learn how you can check the space used for your Azure SQL databases.

Logical Operators

Updatable Views II

Daylight Saving Time

Error_Severity()