Could it be IMPLICIT TRANSACTIONS set off for some connection?

The ROI or cost/benefit is something you have to determine, but I think there's something else to consider.

Is your company a risk taker?

Going with a new version early, means you're...

I've seen it both ways, and bragging doesn't always have anything to do with skill in my experience.

If someone is right, you might be annoyed by their bragging, but they're...

At this job the title doesn't much matter. However when you look for the next job, the title will matter.

Really you've got a couple titles. I'd talk about this...

Hmmm, my wife just calls me :hehe:

Great comments and while I was thinking of technical skills, I'm glad you ran with the communication and problem solving items. Those are really important and if you were hiring...

Change all your tables in the FROM clause to

FROM tablea inner join tableb

on tablea.x = tableb.x

The mixed join types might cause issues (ANSI and non-ANSI)

you can do this with charindex or patindex. Search for the "." and then use substring to pull things out.

There are about 150 SQL Server MVPs, about 1500 or so across all products. The number depends on funding and each MVP is evaluated against others in the quarter they...

There are about 150 SQL Server MVPs, about 1500 or so across all products. The number depends on funding and each MVP is evaluated against others in the quarter they...

Not sure, but please let us know if that fixes things.

Congrats as well and glad it worked out!

Better yet, give this to the accountants. Let them track purchases, you send them an update of when you have a new server and how it's configured.

you need to see how IIS is connecting to SQL Server. It can pass through credentials, it can ask for Windows credentials, or it can allow anonymous users and use...

do you mean you want to schedule this? You can right click in EM and script things out.

If you want this on a schedule, you'll need some DMO automation.

http://www.sqlservercentral.com/articles/1084/