versus

SQL Server parallels to Oracle Alter Table Set Column Unused?

Is there a parallel in Microsoft SQL Server (2005, preferably) for the Oracle functionality of setting a column to be unused? For example: ALTER TABLE Person SET UNUSED Nickname; Nothing turns up in searches, so my thought is this feature must be Oracle specific. ...

SQL Server: what can a stored procedure do that a user defined function cannot?

Can you tell me what is the need for a stored procedure when there is UDF? ...

How Expensive are ???-Hosted WCF Services?

A co-worker and I are having a discussion about WFC services when the topic of "cost" comes up. The question is this: Given that an IIS-hosted WCF service and a Windows-Service-hosted WCF service do the exact same thing, which service will be more "expensive" with regard to memory and CPU cycles if they both are accepting the same load...

HTML: Single vs Double quotes (' vs ")

I've always used single quotes when writing my HTML by hand. I work with a lot of rendered HTML which always uses double quotes. This allows me to determine if the HTML was written by hand or generated. Is this a good idea? What is the difference between the two? I know they both work and are supported by all modern browsers but is ther...

Prototype VS jQuery

Hi All guys! First of, thank's for your time; then i want go directly to the point by saying that, i don't want to open another "Yet Another Js VS Js" 3d , the web is almost busy of this! I want also make a premise, i have used both theese js frameworks and i love it and i know, that there are a lot of good js frameworks around, maybe...

MongoDB on EC2 server or AWS SimpleDB?

What scenario makes more sense - host several EC2 instances with MongoDB installed, or much rather use the Amazon SimpleDB webservice? When having several EC2 instances with MongoDB I have the problem of setting the instance up by myself. When using SimpleDB I have the problem of locking me into Amazons data structure right? What diff...

"asdf".Length > 0 vs. "asdf".Any()?

How is an arrays Length property identified, by an internal variable (i.e. m_Length) or it's gonna enumerate thru all the items of the array. The difference takes place if I want to check whether an array contains any elements. Dim asdf = { "a"c, "s"c, "d"c, "f"c } Dim any = asdf.Any() Dim any2 = asdf.Length > 0 (Also note that Any i...

Oracle versus DB2 on data Validation

Most forums cite minor differences in speed, backup, etc. It's about time someone tell how the two differ when it comes to GUI data validation. Do this 2 Database always depend on java(or other software), or do they have the ability to create a user interface the accepts only valid input. Things like: positive numbers only, age between 1...

Which book should I buy? Working Effectively with Legacy Code or Refactoring: Improving the Design of Existing Code?

I am working with a few programs in PHP 4, ASP classic and C# (.NET 2). They were all created by different people with different styles. None of them have any unit tests and there are very few comments. I would like to be able to effectively add new features to the code while refactoring small parts along the way and I am wondering which...

Type equality performance

I have an iterator of objects and I have to take specific action if the item is of some type. That type is a friend class in the runtime, and therefore cannot be used in design-time. So my question is, which of the following will cost less performance: Private Const myType As String = "System.HiddenNameSpace.MyHiddenType" Sub Compare()...