No, you can't conclude that.

They both can be minimally logged, the both hold the same locks.

Apples and watermelons

Joins are for when you want to relate two tables or subqueries. Apply is for when you want to run a function or subquery once for every row...

Filing that one under 'barge pole'

You want agent alerts on all severity 20+ errors (you can set them on severity level) and on error 825. If you're doing checkDB once a week, make sure you...

Or create them in Model.

Can't think...

Have you tested it out in a test environment? Was there a noticeable performance degradation? Have you had reliable reports of performance degradations caused by MDW?

See the section on 'can't create the error log.'

A database will go into the offline state if someone explicitly sets it offline. Errors cause other states

If I...

It can. Apply used inappropriately can cause massive performance degradation.

Please post new questions in a new thread and give as much detail as possible. Thanks

Indeed, and it's very hard to find articles...

Right click database -> tasks -> bring online

ramana3327 (5/25/2014)

---

Hi,

I think I can use outer apply to substitute left outer join, but I am not sure do we need to give column name like join

Suppose in left outer...

Why? That's not the kind of query you'd use apply for. Apply isn't a magic performance enhancement.

Lowell (5/23/2014)

---

i'm under the impression that WHERE SomeColumn = SomeValue OR SomeColumn Is NULL is a catch all query syntax, so it doesn't matter if it's a variable or a...