SQL

TSQL pattern matching as part of a table join

OK so anyone with some fundamental SQL knowledge will be able to read the following SQL statement and understand what it’s returning, let’s take a look:

To summarize we’re joining the FactInternetSales table to the DimCustomer table via the foreign key called CustomerKey. From the DimCustomer table we’re returning the LastName and FirstName and…

Read More

SQL Server Table Designer can’t save changes

I come across this warning/error message every time I do a fresh install of SQL Server on my laptop and despite having set this option back more times than I care to remember, I end up spending a few minutes looking for the setting in the Management Studio options. Figure: Warning saving changes would result…

Read More