2010-11-01
1,598 reads
Blogs
Why You Should Vote for My SQLRally Pre-Con
Self-marketing is not my strong suit. I don't feel very comfortable doing it, but Andy Warren (twitter | blog) suggests that we...
2010-11-01
2,380 reads
Get Out The Vote
It’s actually kind of cool that SQL Rally voting for the pre-conference seminars and voting in the real(ish) world in the USA are coinciding. I’m in the running for the pre-con AND I’m volunteering for an actual election campaign for the first time ever.
2010-11-01
1,038 reads
Vote for my precon workshop for PASS SQLRally
I’m one of the 3 lucky guys whose submitted precon workshop for the developer category
for PASS SQLRally is in the...
2010-10-28
542 reads
SQL Rally: One Day on Query Performance Tuning
The SQLRally, a new PASS initiative taking place in the spring, is going to be a community driven event. This...
2010-10-28
1,512 reads
You know you want it! - SQLRally Precon Voting
For those of you who have seen our team present, we always do our best to make it really informative,...
2010-10-28
1,025 reads
Vote For The SQLRally Pre-Con Seminars
Do you know a real-life Pointy Haired Boss? Maybe you don’t work for him, but I bet you’ve met one.
In...
2010-10-28
873 reads
When was SQL Server Restarted?
While doing some performance testing recently and utilizing some of the DMV’s I figured, I better find out when the...
2010-10-21
2,806 reads
Powershell is Really Easy… If you know what you’re doing
Sigh… I just spent almost a full work day trying to come up with, what turned out to be a...
2010-10-20
4,525 reads
T-SQL Tuesday #12 - Misconceptions
It’s time for T-SQL Tuesday again, and I’m happy to participate again. This is a monthly blog party started by...
2010-10-14
2,273 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