Martin Lazarus

In this post, we’ll look at how to use the WHERE clause with the equals, like, greater than, and less than operators in the StackOverflow… Read More »Where Clause

Below we have data from our Stack Overflow database. And this is what our data looks like. Suppose I want to know how many posts… Read More »Group By

When I encounter a new database, I want to get familiar with it. Navigating around in Object Explorer can only go so far. What if… Read More »Search Database for Tables and Columns

All my demos will use the StackOverflow database. You can download the StackOverflow database (I use the Small version) on Brent Ozar’s blog here. Once… Read More »Attach StackOverflow Database to SQL Server