Depends on what kind of scale of data you're looking at.

One of the easiest ways to do it, in the database, is to add columns for each language. Keep...

Do it as two queries.

select *

from MyTable

where 'AA' in (Col1, Col2, Col3, Col4, Col5)

union all

select *

from MyTable

where IsNull(Col1, Col2) = IsNull(Col2, Col1)

and IsNull(Col2, Col3) = IsNull(Col3, Col2)

and IsNull(Col3, Col4) =...

I'm not entirely sure what you're looking for here. There are probably as many "types" of "DBA" as there are DBAs in the world. I seriously doubt any...

The ultimate measure of ambition of any sort is what do you actually end up doing. What are you doing with your life? Well, whatever the answer to...

I recommend starting with this article: http://www.simple-talk.com/sql/database-administration/great-sql-server-debates-lock-pages-in-memory/

Research from there. It's a complex subject, in its own way, with a lot of different opinions backed by a lot of the...

That still doesn't say what the second server is for.

What options you have depend on why you're doing this. If it's to have a standby server, then replication or mirroring or log shipping (already mentioned by another) might...

Apply to passive, fail-over from active, make sure it works as intended (should already have been tested in a test environment, but you still need to be absolutely sure on...

Can you strip out punctuation before you compare them? Replace commas, periods and a few others (I don't know what's common in Portugal/Brazil/wherever else you might be), then compare...

Depends on what you mean by "shrinking". If you mean truncating it, to "shrink" the data in it, then yes. If you mean shrinking the file but leaving...

David.Poole (10/10/2012)

---

When I wrote The danger in hiring stars[/url] it became apparent to me that a "star" employee exists within an whole ecosystem.

If you take the star out of that...

You're welcome. Glad I could help.

Looks to me like you need to rewrite the query to provide the data you need.

Cool. Glad I was able to help.

Sounds like a good plan. How'd it go?