development

CTEs, Inline Views, and What They Do

SQL Server
10 Comments
By now, you have probably heard of CTEs And you may have even heard them referred to as Inline Views. Really, an Inline View can be any type of derived table. It’s very easy to illustrate when one may turn into a performance problem with CTEs, if you aren’t careful. A lot of people think…
Read More

Trade Offs: Code Quality

SQL Server
1 Comment
What has two thumbs and is talking about code quality at SQL in the City Seattle? Nearly every day, we’re faced with a decision about quality and time. Do you write quick and dirty code or do you take the time to get it right? Your decision is going to last a lot longer than…
Read More