Nah, we're still aspiring to reach sewer rat. I'm thinking this will get us from cockroach to water...

One way:

SELECT t.A1

FROMtest t

JOIN test t2

ON t.A1 = t2.A1

WHERE t.A2 = 1

AND t2.A2 = 4

That will make...

Please don't cross-post. Especially don't post things in the 2008 forums that has no relation to 2008.

Oh yeah, do that. The Static Code Analysis tool is a great way to review TSQL. It replaces a lot of the functionality that they dropped from the Best Practices...

Not knowing much else, I can make too guess. First, the indexes need to be rebuilt or your statistics are out of date. This can lead the optimizer to make...

Indexes can be, but aren't always, a performance problem when performing ETL. Best answer to that question is for you to test your load both ways, running with the indexes...

Thanks for confirming Steve. I'd done several searches and hadn't come up with anything.

That is truly sad news.

I thought he was fairly young.

Really? Hmm. That actually used to be a specialty of theirs because they were bringing so many people over from ERWin. I haven't upgraded an ERWin model myself since 2002....

Put me down for Embarcadero ERStudio too. Great tool.

Microsoft will allow you to transfer your Developer license to a Database license. I know because I did it. You just have to remove the developer edition before installing DBPro....

Personall, I'd start here.

You want to normalize the data as much as you need to. There really isn't a "too far" or a "not far enough." Meet the business requirements in the best...

Using cursors at all is frequently a poor choice to solve a problem. However, if you have to use two cursors, use two cursors. Declare both, open both, parse through...

Are you kidding? I skip the ones that I know I don't know and I'm still only batting about 58%. Lighten up on yourself just a bit.