Agree with Aaron, T-SQL is a mixture of set-based and procedural programming. Any individual SQL command, like a SELECT, is set-based, but if you put anything after it suddenly you...

I've been eying netbooks for a while myself, but not for business purposes. I want one to make blogging on the go easier, perhaps use it as an e-book when...

http://techrepublic.com.com/5208-12845-0.html?forumID=102&threadID=281804&messageID=2673975

GSquared (1/5/2009)

---

If you set a standard that the variable "i" (or @i) is only to be used for while loops, and is to be used for all while loops, and...

Jack Corbett (1/5/2009)

---

Timothy (1/5/2009)

---

The rest of the time I rely on properly named classes, methods, and variables. In a sense the code is self-documenting. I often use names that are...

I'll admit I rarely write comments. About the only time I do is if the code has "gotchas": basically it does things in a way you wouldn't normally expect but...

Nice post blandry. I agree with pretty much everything you said. I've been thinking a lot myself the country seems to be going through a hangover right now. The credit...

Good point you make Steve about companies possibly selling the data you trust them with when/if they go belly up. I see so many statements on websites about how your...

Yeah, I was going to ask about your conservative and realistic savings. Generally speaking I'd expect conservative estimates to be lower than realistic since, by definition, you're being cautious.

I'm just curious, how would you expect any object relational...

Adam Machanic (9/22/2008)

---

Sure, but how will it deal with the following perfectly valid stored procedure:

CREATE PROC x

@i INT

AS

BEGIN

SET NOCOUNT ON

IF @i = 0

...

Unless I'm missing something...

cs_troyk (9/22/2008)

---

In addition to the automatic parameterization issues mentioned earlier, I have seen cases where the SQL emitted by a LINQ expression contains a cartesian product (CROSS JOIN) where it's...

Using Linq to SQL for direct table access is something I've just recently started doing, but only in limited respects. Mainly, for now, for constructing queries for a search, i.e....

I happened to click on a tab in Maxthon that had a Digg story about He Kexin, the Chinese female gymnast under suspicion of competing in the current Olympics as...