sqlserver Tag Posts Index

Solution When ISJSON May Not Be A Recognized Function Name

Check out the solution in the video Schema validation failed: 'ISJSON' is not a recognized built-in function name. First, note the version of Microsoft SQL Server

Creating a GUID For Each GUID

What happens when we run into a situation where we need to create a GUID for reach GUID? Check out the solution in the video TSQL: Create A GUID For Each GUID (Unique

T-SQL: How To UNION ALL Tables and Why

In some cases, we need to combine the result of two tables where data types may be similar or identical. We could combine the data in one table using INSERT syntaxes,

SQL Tutorial: Solving Data Differentials With LEFT JOINs Only

One challenge we face with data involves new and existing data from a source data set to a destination data set. The source and destination may be managed by us

Solving Data Differentials With LEFT JOINs

One challenge we face with data involves new and existing data from a source data set to a destination data set. The source and destination may be managed by us

Transaction Log Becoming Full Due To Replication

Review the solution and discussion in the video The transaction log for database 'DB' is full due to 'REPLICATION'. We do not want to develop the habit of micro-managing

SQL Tutorial: How To Use ROW NUMBER() and Why

No matter what data we receive, we will probably be required to order it a certain way at some point. In some cases, we may simply order data by dates and receive

Not Able To Drop Table Because of Reference

What happens when we try to drop a table that is being referenced by a view (it's also possible that we get an error if other references exist)? Check out the solution

T-SQL: How To Use DENSE_RANK()

In a previous lesson, we learned that we can apply ROW_NUMBER() to a data set and output the row number of the data set based on the order we specify. This means

SQL Tutorial: INNER JOINs vs LEFT JOINs

For people who are new to SQL, these two JOIN types can often be confusing. In the below videos and discussion we compare and contrast the two using the same data

T-SQL: How To Use PARTITION BY and Why

If we think about functions in mathematics, we'll recall that one function is the division function. If we have 10 apples and we want to divide them equally into

Weekly Tech Lesson: CROSS JOINs Versus CROSS APPLY

When we look at data, we will sometimes want to look at all data points relative to all other data points. We discussed this when we talked about CROSS APPLY, but

T-SQL: How To Use ROW NUMBER() and Why

No matter what data we receive, we will probably be required to order it a certain way at some point. In some cases, we may simply order data by dates and receive

SQL Tutorial: CROSS JOIN Basics and How They Differ From CROSS APPLY

When we look at data, we will sometimes want to look at all data points relative to all other data points. We discussed this when we talked about CROSS APPLY, but

T-SQL: How To Write A CROSS JOIN and Why

When we look at data, we will sometimes want to look at all data points relative to all other data points. We discussed this when we talked about CROSS APPLY, but

SQL Tutorial: How To Write A LEFT SEMI JOIN

When we INNER JOINfrom one table to another table with a column or set of columns and we select all columns, we'll get the results returned for both tables. This

T-SQL: How To Write A FULL OUTER JOIN

We've looked at the LEFT and RIGHT JOINs. These can be useful relative to the result set we want, thought RIGHT JOINs are less common in development and may cause

SQL Tutorial: How To Write A Cross Apply (SQL Server)

In our series, we've looked at how we can match data using relationships, or find data that don't match based on conditions, and even compare data to itself. What

T-SQL: How To Write A Cross Apply and Why

In our series, we've looked at how we can match data using relationships, or find data that don't match based on conditions, and even compare data to itself. What

SQL Tutorial: How To Write A Self Join

As we've seen with SQL joins, we can link data to other data using relationships between data, such as a relationship between the history of a sales' price for a