Category: Beginner

N Things Worth Knowing About SELECT

Post author By Jen McCown
Post date August 23, 2010
Categories In Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC, Tips, TSQL
4 Comments on 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 […]

SQL Trace Events Reference

Post author By Jen McCown
Post date July 19, 2010
Categories In Beginner, Intermediate, sql server, sqlserverpedia-syndication
3 Comments on SQL Trace Events Reference

I’ve mentioned before that I’m something of an absentminded DBA – I know where to find information, even if I can’t keep it in my head all the time. One of the lookups I have to do most often is for server side trace / SQL Profiler event numbers and names. See, when you create […]

Demo: What’s the difference between CHAR and VARCHAR?

Post author By Jen McCown
Post date April 30, 2010
Categories In Beginner, sql server, sqlserverpedia-syndication, SSC, TSQL
2 Comments on Demo: What’s the difference between CHAR and VARCHAR?

Content level: Beginner / refresher At last week’s SQL Saturday 41 Atlanta, I gave my TSQL Beginner’s Kit session in the last time slot of the day, to deafening applause and accolades. Actually, there were about 12 of us in the room, and we had a really good time. One of the more popular items in […]