Marco +1. I'll also use them in a version upgrade, where the schema is changing and I am converting tables to the new schema, I may need to store an...

Several of us on our dev team managed to convince management to try a work from home experiment several years ago. After 3 years of doing this, everyone couldn't be...

We recently upgraded to Visual Studio 2010 Ultimate and I had some free training time, so I dove into the database project stuff. At first, I thought I was wasting...

Thanks again Gail. Your 3-part article solidified me on this answer.

I've been doing SQL dev for a long time, but decided to approach this series like I was just starting out and knew jack about indexes. Yes, I learned a...

No way. I never really enjoyed the Admin side, and haven't been involved with it in over a decade. Love SQL development though. Back in the 90's I managed many...

LOL, yes it's definitely that old. I started using SQL with INGRES back in '88. Just give me a cane, ehhh?

Columns in the IN clause! 22 years of sql and that was a first. You're never too old to learn. Thanks!

The answer to this question is withOUT question: it depends. Are you talking of right-clicking in the object explorer to create one (not supported), or are you including the fact...

As usual for a DBA, the answer is... IT DEPENDS. Entirely on my mood. Sometimes listening to music helps me to focus and other times it's a complete distraction.

To use huge multi-column "real-world" keys, you have to have a lack of knowledge about database design. Surrogate keys are the only way to go if you want large production...

At 45, I have 23 years of IT experience, all of it in the SQL world. I truly enjoy just being a developer (not a DBA). In my 30's, I...

OK, I got the MERGE (WHEN NOT MATCHED THEN... INSERT) with OUTPUT to work. Thanks for the link Dave!

That's interesting that you can't reference a non-INSERTED table column when inserting, because you CAN when deleting. Here is an example from books online OUTPUT clause:

USE AdventureWorks2008;

GO

DECLARE @MyTableVar table (

...

Thanks Lowell, but that depends on BrandName being unique, which it may not be (in the real-world case). Back to my original question: can you use a column from one...