Search for: subquery

RTFM365, Week 1

Big lessons learned this week: 1, its’ always worthwhile to go back and reread the basics. 2, sys.sp_trace_create option 4 doesn’t stop the server side trace, it stops SQL Server itself. Be warned. Boilerplate: For the next year (-10 days now), I will read from SQL Server Books Online a little every day, and blog about […]

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 […]