I would not have more than one project for a given database. You should be able to manage a single database all the way from Dev through to Production from...

Yeah, I wouldn't create two data structures for the same data. I'd store the "messy" data right along side the "approved" data but then simply have a clean-up process that...

I've got a core, basic, set of counters that I suggest using here. They barely scratch the surface, but they ought to get you started.

If you do create a common set of code that you want to access from other databases, I wouldn't put it in master or msdb. You never know when a...

Also, not related to the issue you're describing, but worth mentioning, you're performing a non-ansi join between the two temp tables at the end of your query there.

FROM temp#1 x,temp#3...

If I understand the question correctly, no I wouldn't duplicate the structures & move the data around. Instead, store the member data in whatever format you had planned. Inlcude a...

The sample query you're showing looks correct. Verify the data in the original columns. Double-check your actual query (I'm assuming you're posting a sample and you have a real query...

If you use the IF EXISTS clause, it will only fire the code within the BEGIN...END when it finds the existance of a row in the SELECT statement. I'm pretty...

Actually that's only going to delete individual rows. The EXISTS followed by a full DELETE with no WHERE clause is probably what he's looking for.

Do you mean you need to delete all records where the value = 'Checked' or if any value = 'Checked' you're going to delete all values?

If the former, simply make...

In general terms, it doesn't sound bad, but it all comes down to the code, the indexes and the code, and if I didn't mention it, the code. How you...

Yeah, what he says.

I know you're just learning this stuff. When you get an error, look it up in the Books Online. It'll mostly tell you what's going on. In...

Hopefully this won't kick up too much mud.

I agree with some of what Steve Schmechel is advocating (if not necessarily his approach in advocating it). In working with our...

The thing to remember is that logically, they are different operations. They occur at different points in the query processing and will affect data in different ways. The JOIN criteria...

Nice article. You do a good job of outlining the issues that come up on the database side of things when doing Agile development.

The one thing I'd add is that...