Feedback is encouraged? Not very much IMO. The following two really efficient ways to communicate feedback are completely closed.

1. Tools such as SSIS and SSMS are "free", which means that...

Can you explain why you have chosen TFS over its alternatives, Subversion and Git?

Hi Adam,

The following sounds like a good reason: "tracks object evolution automatically".

Thanks for the answer.

AK

Adam,

Alternatively, I can just store all I want in my own table, and then I can work with sets of rows, search on any criteria I wish etc., and the...

Steve,

While I completely agree with " You can't trust stuff you download", why are you singling out only open source: "no matter what the Open Source crowd says."

Are you...

Hi Steve,

Can you please remove this question, because it is plain wrong:

--Select the first customer

SELECT TOP 1 * FROM #Customer

Without ORDER BY, the order is not guaranteed.

Thanks!

AK

Dave,

I liked this article, thanks!

One more thing: this optimization relies on the assumptions that only a small percentage are winners. It might be interesting to research which query is faster...

Same here, Andy - I ended up unit testing almost everything, but with other tools.

Scott Abrants (8/21/2009)

---

Great series Andy - Thank you.

I do have a question. All of the work you did here is something that has to be done manually and maintained...

blandry (11/17/2010)

---

After all, if you want a great and recent historical example of "10's" who thought they "knew" something - look at Wall Street. They "knew" the party would...

blandry (11/16/2010)

---

"Jeff Moden often quotes, it doesn't take any more time to do it right the first time."

I was struck by this comment in today's editorial. Struck by the...

del

Andy,

What will happen if you just drop this test? Is there any chance the problem you are testing will go unnoticed?

I don't think so. If your database is gone, every...

Hey Andy,

Why would we want this: "Unit Test developed here will live on as a Regression Test for the remainder of this database's lifecycle".

What the purpose of keeping this test?...

mtillman-921105 (10/21/2010)

---

Tom.Thomson (10/21/2010)

---

mtillman-921105 (10/19/2010)

---

kevin.l.williams (10/19/2010)

---

If I saw any production code like 2, 3 or 4, the developer would get an ear full. I will stick with count(*) thank you very...