One of the most prolific and popular authors at Simple Talk has been Phil Factor. He wrote many pieces on all aspects of database work and has probably written more articles on the Redgate Product Learning site than anyone else. He has entertained, informed, and inspired many database professionals in his many years as an […]
2025-09-19
79 reads
This value is something that I still hear today: our best work is done in teams. On the facing page, there is a short description of what this means....
2025-09-19
7 reads
2025-09-19
1,554 reads
Prompt AI released recently and I decided to try a few things with the tool that might help me in database work. I’ve had to do this task, but...
2025-09-17
64 reads
Many of you reading this likely have an Availability Group (AG) set up on at least one database in your organization. Maybe not most, but many of you as this has proven to be a technology that many people like for HA/DR, upgrades, and probably other uses. As the technology has evolved from it's SQL […]
2025-09-17
90 reads
Are the AI tools developers use making them enjoy their jobs more or less? Steve has a few thoughts.
2025-09-15
1,017 reads
One of the parts of getting older that really sucks is I seem to attend more funerals than weddings. It’s a sad fact of file, and this was one...
2025-09-15
292 reads
2025-09-15
1,519 reads
anderance – n. the awareness that your partner perceives the relationship from a totally different angle than you – spending years looking at a different face across the table,...
2025-09-12
500 reads
Older technology can introduce security issues, along with performance ones. Keeping your systems somewhat up to date is important for security.
2025-09-12
51 reads
You can find the slides of my session on the €100 DWH in Azure...
By Steve Jones
This value is something that I still hear today: our best work is done...
By gbargsley
Have you ever received the dreaded error from SQL Server that the TempDB log...
Hi everyone I am writing an SP where there is logic inside the SP...
Comments posted to this topic are about the item Planning for tomorrow, today -...
We have a BI-application that connects to input tables on a SQL Server 2022...
I try to run this code on SQL Server 2022. All the objects exist in the database.
CREATE OR ALTER VIEW OrderShipping
AS
SELECT cl.CityNameID,
cl.CityName,
o.OrderID,
o.Customer,
o.OrderDate,
o.CustomerID,
o.cityId
FROM dbo.CityList AS cl
INNER JOIN dbo.[Order] AS o ON o.cityId = cl.CityNameID
GO
CREATE OR ALTER FUNCTION GetShipCityForOrder
(
@OrderID INT
)
RETURNS VARCHAR(50)
WITH SCHEMABINDING
AS
BEGIN
DECLARE @city VARCHAR(50);
SELECT @city = os.CityName
FROM dbo.OrderShipping AS os
WHERE os.OrderID = @OrderID;
RETURN @city;
END;
go
What is the result? See possible answers