I know it’s been a long, hot, difficult August without your regularly scheduled DBAs at Midnight to entertain and gross you out…but we’re about to start up again. Introducing… DBAs at Midnight, Season 2!!! We’re going to have some really cool new stuff on the show this season, and we’re quite excited! Edit: I’m not […]
Category: sql server
N Things Worth Knowing About CTEs
Edit: This post was originally published on August 26, 2010. If you haven’t messed with them yet, you should know that CTEs (Common Table Expressions) – new in SQL Server 2005 – are actualy pretty #awesomesauce. A CTE is, in essence, a temporary view attached to your SELECT statement. They’re good for a number of uses, […]
N Things Worth Knowing About SELECT
SELECT is our bedrock, our foundation, our now-and-forever T-SQL multitasker…and it’s one of the most complicated structures available to us. Here are a few things worth knowing about it, from the basic to the obscure. More-or-Less Basic Structure There’s tons more that can go into the SELECT statement, of course, but the basic structure is: WITH […]