And this: http://www.sqlservercentral.com/articles/outer+join/103026/

Seems to work for me as well.

Perhaps you can include more code and setup DDL as wolfkillj did

I've corrected it. Sorry I missed that.

Brent Ozar (12/26/2013)

---

Why is it headline news that you agree with me, Steve? Are you saying you don't always agree with me, is that what you're saying? You'd better not...

Merry Christmas to all and Happy Holidays.

Out of town yesterday, so no posts for me, but I hope everyone had a peaceful, happy day.

Revenant (12/24/2013)

---

Revenant (12/24/2013)

---

In my Christmas tradition, it is a...

Congrats to Ditka and Ray for the 1st and 2nd places.

I'll sort out prizes later in the week.

You are welcome. It does sound like an account/security issue.

Good luck. Let us know what you find out.

Haven't found much on these exams. I did find this advice: http://byobi.com/blog/2013/04/passed-70-466-and-70-467-exams-study-guides/

The only way you can really control the ram on setup 2 is to set a max memory. However, I'd look at the target memory on both setups as well....

WayneS (12/20/2013)

---

I'm curious as to the different ways that you fine folks have seen / dealt with being on-call, and what you perceive the pros/cons of these are?

For instance:

on-call...

You would use unbounded preceding for all the rows. The title did say all the rows, but the question did not.

When you run SQLCMD from your machine, regardless of where the file is located, it uses the paths that are seen from your machine. The thread runs on your CPU,...

Jack Corbett (12/19/2013)

---

Yeah, me too. In order to have put in an automatic standby I would have had to have brought in propane in addition to the...

You use the CREATE CERTIFICATE command with the FROM FILE option.

http://voiceofthedba.wordpress.com/2012/03/05/restoring-a-certificate/