Chad Crawford (3/18/2010)

---

How did this work? I just registered for PASS (wahoo!), used the SSC code and got $200 off the registration? I had heard that you...

Jeff Moden (3/17/2010)

---

I can certainly understand not having any access to the internet during an exam... but not having access to BOL doesn't seem right to me. It's a...

If you look at the exam description and the skills measured it tells you how the areas are weighted so there is not a specific get 1 wrong you got...

Not to be trite, but study and practice. I have a blog post where I talk about my experience and preparation for taking this test. I took and...

I don't think the CAST should have been an issue. I'm not a Linq to SQL Expert, but I've used it and evaluated it and it should be passing...

Esat,

I think you'd see the same behavior with a stored procedure because the plan would be cached the same as the sp_executesql code is being cached. Also with the...

You are never getting the child project id so you are joining on the same project id in the recursive part of the CTE. Your query should look more...

Grant Fritchey (3/16/2010)

---

sp_executesql is actually one of the best ways to run ad hoc tsql because you can parameterize it and get more plan reuse.

It sounds like, possibly, you're hitting...

The Dixie Flatline (3/16/2010)

---

Thanks, guys.

Jack: You're right. This was written back in November. Things have been hectic since. ...

It's nice when an exceptional article comes out. ...

Nice job Bob, very thorough as would be expected. Glad to see yo back in the saddle so to speak. I know the article was probably written awhile...

I went there and I don't see anything that addresses index maintenance.

Grant Fritchey (3/15/2010)

---

GSquared (3/15/2010)

---

What year? (My birthday was yesterday, so I'm curious as to what the actual age difference is.)...

RBarryYoung (3/14/2010)

---

Well, my back surgery is tomorrow (it got moved up). They've been putting me through medication withdrawal the last two weeks in preparation, so apologies if I've been...

My recent favorite is having a consulting company come int o discuss possible outsourcing the UI for a project. They asked if we used Linq to SQL. I...