I should not have made the assumption that the question was solely about the differences between char and varchar! I was assuming (see, that was my problem!) that the...

I agree that both the SQL OS and the T-SQL enhancements should be done. In fact, it seems logical to me that by paring down the OS side, much...

Michael Ross (8/26/2009)

---

As painful as it is, it's hard to dispute throwing hardware at the problem as a viable solution. I participated in discussions where a memory leak in...

A stripped down version of Windows to support SQL Server is a great idea. It's a rather proven concept (as many others have pointed out) that would simplify administration...

Yeah, it was a "no-brainer" and evidently my...

Doh!! Goes to show what you get when you click through something too quickly without checking your answers! (I checked 0 when I meant to check 1).

I don't believe so. The range of numeric values is limited because the datatype is limited....

If you'll notice, the parameter to the...

I've been burnt by this "feature" too often to not recognize it! It took me hours to track down an issue cause by a string truncation that was being...

I couldn't agree more. One company I worked at previously though...

Being in IT all of my career, I've worked quite a bit of overtime in my day. I've always given 125% and was willing to do what was necessary...

I don't believe that isnumeric looks at the string as a whole, but as the individual characters in the string. I think it's a rather broad assertion that the...

Paul (8/4/2009)

---

Aaron: My point about the class alternative was that it's just that; an alternative. You could use either, actually I normally use both, (database objects and classes), as they...

Paul (8/4/2009)

---

Although you don't need to use stored procs to have an API - us developers, (yes I am one), also have utility classes that provide the same sort of...

Are you sure you weren't listening in on our development meeting the other day? We talked about both using FogBugz and developing stored procedures to use as an API...