Blog entries tagged with Microsoft SqlServer

LOOP JOIN and other fun query optimizations

by: Per Bjurström

Consider this SQL Server query that is part of EPiServer CMS 5:SELECT tblPageLanguage. fkPageID, tblLanguageBranch. LanguageID as LanguageBranch FROM tblPage JOIN tblPageLanguage ON tblPage. pkID=tblPageLanguage. fkPageID LEFT... [ Read full article ]

26 March 2008  0 Comments

Tags:

Per Bjurström

About me

I'm a senior developer and architect on the development team in Stockholm and has been with the company since 1999. I live on Södermalm in Stockholm. My main focus areas are new technologies and how we can use them in our product development.

Messenger

Syndications

Archive

Tag cloud

EPiTrace logger