actually there are some things you just can't...

look at alter table in BOL. The command will basically be:

alter table add constraint <name_of_contraint> UNIQUE(column [, column,...]) [clustered]

But you should double check my syntax with BOL

Can't really answer this question properly unless we know more about the data and the application.

Advantage of having the clustered index...

Sadly, No. A lot of existing organizations have business architectures...

We do this now in our organization. We have data that is badly organized (ie poorly designed databases with complex and improperly partitioned data structures) that needs to be...

Good article. It is human nature to wait till something breaks before spending any money or time on it.

In the best case it may be a few hours of a...

The number of rows you will be dealing with will play a big part in which way you decide to go.

Either way, my goal would be to minimize the number...

So glad you wrote this Steve I couldn't agree with you more. But as you state it does need to start top down and I really believe that too many...

Any business with that kind of cash flow needs big...

One of the easiest ways is to use reverse.

select StringID,

Reverse(LEFT(reverse(StringField),charindex(',',reverse(StringField))-1)) as StringField

If you need more complex parsing of the column search for Jeff Moden's csv splitter articles.

GSquared (6/27/2012)

---

If there's one I listed that's not, please point it out to me with specifics. Otherwise, I recommend reading the whole thing, or at least all of Article...

GSquared (6/26/2012)

---

Shall I continue? Or just read the Constitution and you'll see a list of the critical services and enforcement needs. It's very finite, though subject to abuse...

The LEFT() function on columns involved in your join clause can/will negate any indexes you have.

You might try using like instead and see how that works. I can replace the...

jbnv (6/26/2012)

---

patrickmcginnis59 (6/26/2012)I'm pointing out that you have not addressed the free market response to a visibly bad actor. There very well could be an answer here, thats why I'm...

patrickmcginnis59 (6/26/2012)

---

And in the scenario I pointed out, they will be at a competitive disadvantage when competing against the one hypothetical bad actor. Again, I'm pointing out that you have...