The query isn't failing. You're not getting error messages....

Brian McGee-355525 (10/19/2009)

---

I've dug a little deeper and it turns out that out of 2m rows, the join hit 1.6m of them, so a scan is probably fine. But...

There's no...

bas de zwart (10/16/2009)

---

Some obvious disadvantages would be:

- Users would be unable to quickly check what's there in each field by using a 'SELECT TOP 100 * FROM OBJECT' query.

-...

Then you should have a join between the two tables on that column, just as you've joined applicant and intake

<raised eyebrows> Was that really necessary?

Personally I've seen far more males than females who wouldn't open a book if their lives depended on it. Might...

You can study any way you like. No one's going to restrict you there. The material is not the same in the two exams (no big surprise), so it might...

The MCTS is a pre-requisite for the MCITP certification. You'll have to write and pass the TS exam first, then the PRO to get the certifications.

or seach Books Online for hardware requirements.

8060 bytes, excluding LOB data and not considering row versioning or other things that will reduce the available space...

gardenlady (10/16/2009)

---

So that's one issue that I found just by going through Gail's steps re the execution plan (although could not find a way to print it/save it, running 2005...

GSquared (10/16/2009)

---

So far as I know, and I could be wrong, this scenario basically results in restoring to the point immediately prior to the lost log backup file, and losing...

I think it's sysadmin. I'd be very surprised if it's anything less since you can use it to read any page, anywhere in any database.

Looks like MS Access. Specially with the comment 'under a single button click'

Likes without wildcards

Non-aggregate comparisons in the having clause

The same two predicates repeated several times with ORs between them....

As far as I'm aware, it doesn't matter. With a missing log file, the page...