SNESSUG President

September 15, 2008 at 8:58 am (PASS) (, )

I’ve been crazy busy and I didn’t mention this before, but last Wednesday I was elected (unapposed) to the post of President of the Southern New England SQL Server Users Group (SNESSUG).

Permalink 2 Comments

Community Building

April 28, 2008 at 12:21 pm (SNESSUG) (, , , )

Building a community is hard. I’m one of the leaders of the Southern New England SQL Server Users Group, SNESSUG, a PASS affiliate. We’ve been going for just over a year. We were launched by the drive and initiative of one person, who got us going and then had to leave. We’ve been on our own for about four months now. It’s been difficult without the drive of the founder, but we’re getting the job done & moving things forward. Andy Leanard, MVP, Solid Quality Mentor, nice guy (for a DBA), has a series of posts that, while short, are very helpful guide-posts for those attempting to start a community or keep one running (read them bottom to top). If you’re in that position or thinking about volunteering at your local community group (and if you haven’t volunteered, do it, they need the help), this is worth a read (or two).

Permalink Leave a Comment

Presentation Last Week

March 17, 2008 at 1:51 pm (SNESSUG, SQL Server 2005, SQL Server 2008, TSQL) (, , , )

Last week I presented at the Southern New England SQL Server User Group (SNESSUG) where I’m the Program Director. I presented from the book, Dissecting Execution Plans, that is supposed to be published any day now. I kept it basic and it flowed very well. The audience seemed receptive and there were a few questions. Mostly around figuring out what to do when you saw certain problems within the execution plans. Since that was the goal of the presentation, I was ready for most of the questions. I got stumped once on a Constant Scan operation.

I finally looked it up this morning and feel silly. Here’s the query:

INSERT INTO [AdventureWorks].[Person].[Address]
     ([AddressLine1]
     ,[AddressLine2]
     ,[City]
     ,[StateProvinceId]
     ,[PostalCode]
     ,[rowguid]
     ,[ModifiedDate]
VALUES (‘1313 Mockingbird Lane’
     ,’Basement’
     ,’Springfield’
     ,24
     ,’02134′
     ,NEWID()
     ,GETDATE());

Silly simple right? It creates an execution plan that starts with the Constant Scan operator. For those who aren’t snickering behind their hands because I forgot this simple fact, the Constant Scan operator creates a blank row, or rows, for the query in question to begin filling in. Simple. I still feel goofy that I didn’t remember it.

Permalink Leave a Comment

« Previous page