Reading Time: 9 minutesThe SQL Server RANK function is a simple window function you should know to help gather meaningful information from your data. Window functions are considered an advanced tool when querying data in SQL Server. If you’re trying to learn about window functions, congratulations, you’re moving up! The RANK function is Continue Reading
Querying data
SQL Server ROW_NUMBER: A window function you should know
Reading Time: 8 minutesThe SQL Server ROW_NUMBER function is a simple window function you should know to help you gather meaningful information from your data. Window functions are considered an advanced tool when querying data in SQL Server. If you’re trying to learn about window functions, congratulations, you’re moving up! The ROW_NUMBER function Continue Reading
SQL Server Ranking Window Functions: ROW_NUMBER, RANK, DENSE_RANK, NTILE
Reading Time: 10 minutesWhen querying data in a SQL Server database, there may be times when you want to rank rows in your dataset. Maybe you want to rank Customers by how much they have spent in your store, or maybe you want to rank Products from most expensive to least expensive. SQL Continue Reading
SQL Server Window Functions: An introduction for beginners
Reading Time: 16 minutesWindow functions in SQL Server are very powerful tools we can use to gather meaningful information from our database. Window functions are considered an advanced tool when querying data in SQL Server. If you’re trying to learn about window functions, congratulations, you’re moving up! Do you need to understand how Continue Reading
UPDATE statement with JOIN: How it’s done
Reading Time: 8 minutesOne of the more tricky things I learned early in my career was how to do an UPDATE statement with a JOIN. This is a very interesting task to think about. There may be situations when we want to perform an UPDATE to the results of a JOIN query, such Continue Reading
DATENAME function: Explained
Reading Time: 7 minutesThe DATENAME function is a system function in Microsoft SQL Server we can use to present meaningful date information to the user. We use this function to basically spell out a specific part of a date value. For example, if we have a date of 4/1/2021, we can use DATENAMEÂ to Continue Reading
Top 6 tools you should know for writing AWESOME Select statements
Reading Time: 13 minutesAs a database professional, you will be asked to come up with SELECT statements to pull needed information in a meaningful and accurate way. Sometimes you will need to review other SELECT statements written by other people, too. Maybe those queries have a problem which is causing it to pull Continue Reading
CAST and CONVERT: A How-To Guide
Reading Time: 9 minutesTwo of the most common system functions you will see as a database developer are the CAST and CONVERT functions. These two functions perform in a similar way, with only slight differences between the two. The one you use will depend on your needs at the time. CAST and CONVERT Continue Reading
SQL Server CASE Statement: A How-To Guide
Reading Time: 8 minutesThe CASE expression is a very handy tool you should know when querying data using T-SQL in a Microsoft SQL Server database. In this very brief tutorial, we’ll break down the CASE expression and show you exactly how to write it and how it can make your querying life easier. Continue Reading
SQL Server Wildcards: The 5 wildcards you need to know
Reading Time: 9 minutesYou are the manager of a new up-and-coming hardware store in the city of Denver, Colorado. You are speaking with a new customer who says they own a woodworking business, and enjoy shopping at your store very much. They plan on being a regular customer, which you know will bring Continue Reading