I don't really know of any. Data Architect is a pretty loose term for someone with a lot of experience and knowledge who can help you build, architect, your systems...

There is no way to go back in time to retrieve an execution plan. So, if you have a need to monitor particular plans, you need to set up, ahead...

I just wrote and submitted a 400 word editorial for Simple-Talk on MCM.

Brandie Tarvin (9/3/2013)

---

Grant Fritchey (9/3/2013)

---

Brandie Tarvin (9/3/2013)

---

One can hope. I know several older people who barely know what email is let alone...

Brandie Tarvin (9/3/2013)

---

One can hope. I know several older people who barely know what email is let alone what websites are out...

Presumably they all use the internet. Reference known web sites and talk about how they might work. You can use Amazon, Wikipedia, the Internet Movie Database (nicely named) or any...

You must use COPY_ONLY when backing up a database on a secondary server. When backing up a database on the primary you can run a regular backup, or a COPY_ONLY...

Jeff Moden (8/31/2013)

---

Grant, you're just as amazing. No "real" formal training but a great speaker on multiple subjects and you've written two of the best books on Execution Plans...

SQLRNNR (8/31/2013)

---

Can...

GilaMonster (8/31/2013)

---

Just ....

Sent late on a...

Certifications is a whole different discussion.

You're early enough in your career that it might help some. Maybe.

I'm honestly the...

I am not sure. This is not something I've seen before. Do you have all the service packs applied to the server?

Is it possible that it's a filtered statistic? I mean, the "good" example only sampled 38 rows. That seems pretty radically off unless it's filtered down to only a few...

Not seeing the code or structures or plans, just guessing at possible solutions, but allow me to point out, there is nothing inherently good, or bad, in nested loop joins....

Simple, follow your passion... and the money. Do what you love AND will get paid for.