I think I know what you are after. But to prevent me guessing and you possibly using a solution that works fine on your test data only, I will not...

Good! Now test it with a much larger and more varied selection of test data....

Perhaps a stupid question, but did you actually copy over the job to the new server? And did you make sure that the name is unchanged?

If you answer yes to...

Since you say that you only want data from table t1 if it satisfies the condition that it has "English" in table2, I would keep the query close to these...

Not ambiguous. Missing.

Pedantic, I know, but there are situations where the distinction is relevant.

g.britton (1/28/2016)

---

Carlo Romagnano (1/28/2016)

---

I disagree with explanation:

CHECK evaluates only true (accepted) or false (rejected) expression not UNKNOWN (accepted).

From...

At this time there is no built-in functionality in SQL Server for transforming a number into words.

For SQL Server, integrity and consistency are like holy grails.

So even if you use different filegroups, SQL Server will still insist that they be consistent. When restoring you can do...

Battering

Disclaimer first: I have never used Oracle. So take the below with a huge helping of salt, please.

However, I have heard many times that Oracle, unlike SQL Server, does not...

Several people have already explained how SQL Server treats memory, so I won't repeat that.

But I am going to question your question. You want to reduce the memory used by...

First hit on Google: http://blogs.msdn.com/b/amantaras/archive/2014/10/21/biztalk-server-is-not-supported-with-sql-always-on.aspx

That's the CREATE TABLE statements I was asking for, but not the INSERT statements, nor the expected results.

Also, the queries in your original question reference two table variables; one is...

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/539424f7-a282-4a21-b99c-191db90e061c/what-is-dbmirrordbmevent-?forum=sqldatabasemirroring

http://blogs.msdn.com/b/grahamk/archive/2011/01/10/sql-server-blocking-caused-by-database-mirroring-wait-type-dbmirror-dbm-event.aspx

I see myself as mostly database developer, not a DBA. So I have not done a lot of upgrades. For a serious production use, I would definitely insist that the...