Looking Forward
2018 has come and gone. And we’re on a new year once again. This is another opportunity for a new...
2019-01-04
241 reads
Blog Posts
Query memory grants part 1: Where does the memory go?
Let’s talk about how queries use memory, specifically in the execution plan. One of the query operators that use memory...
2019-01-04
181 reads
Running Windows and Linux SQL Containers together
Just for fun I decided to spend Christmas Eve getting Windows and Linux SQL containers running together.
WARNING
This is NOT a...
2019-01-04 (first published: 2018-12-24)
1,874 reads
Speaking at DataGrillen
After speaking at SQL Saturday Iceland last year, which is a smaller event that I absolutely loved (you can read about that adventure here), I decided I wanted to...
2019-01-04
4 reads
Speaking at DataGrillen
After speaking at SQL Saturday Iceland last year, which is a smaller event that I absolutely loved (you can read...
2019-01-04
150 reads
Speaking at SQL Saturday Nashville
I am excited and honored to announce that I have been selected to speak at SQL Saturday Nashville on January 12, 2019. I’ve been to Nashville before, in fact...
2019-01-04
3 reads
Speaking at SQL Saturday Nashville
I am excited and honored to announce that I have been selected to speak at SQL Saturday Nashville on January...
2019-01-04
124 reads
Speaking at SQLBits
I got an early Christmas present this year, I found out I had been selected to speak at SQLBits! That’s what I call a gift that keeps on giving....
2019-01-04
6 reads
Speaking at SQLBits
I got an early Christmas present this year, I found out I had been selected to speak at SQLBits! That’s...
2019-01-04
140 reads
Year in Review 2018 – The Year of Making a Difference – Up to 50
Rough Year, But 50 Kids, Can’t Beat That!
Last year was a pretty rough year personally. I totaled two cars, not...
2019-01-04
138 reads
Blogs
From Couch-Potato to Triathlete – and What This Means for Your SQL Server
Do you know if your SQL Server is really running at its best? To...
Retro Data 2025 – Slidedeck
You can find the slides of my session on the €100 DWH in Azure...
The Book of Redgate: We Value Teams
By Steve Jones
This value is something that I still hear today: our best work is done...
Forums
Is there a way for SP to know who called it?
Hi everyone I am writing an SP where there is logic inside the SP...
Planning for tomorrow, today - database migrations
Comments posted to this topic are about the item Planning for tomorrow, today -...
Bottlenecks on SQL Server performance
We have a BI-application that connects to input tables on a SQL Server 2022...
Question of the Day
The Tightly Linked View
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