Slide 73
Slide 73 text
2 - BIG QUERIES WORKED ON-PREM
Front-Of
fi
ce
SELECT p.ID
,
LAG (p.ID, 1) OVER
(ORDER BY p.OwnerUserId
DESC) AS PreviousID
,
LEAD (p.ID, 1)
OVER (ORDER BY
p.OwnerUserId DESC) AS
NextI
D
FROM Posts
p
JOIN Users u ON u.Id =
p.OwnerUserI
d
WHERE DisplayName =
'CecilPhillip
'
AND p.PostTypeId =
1
AND p.OwnerUserId =
333082
Web Server - IIS
Windows
Services
SQL Server DB
Co-colocated