Welcome...

Excellent article. Thanks. I only wish I could use Firefox at work. Still, this is some interesting stuff. No, I hadn't been using a wiki to manage my info. I'm...

For many years now I've been doing interviews for senior level DBA's and I've consistently received resumes with between 5-10 years of experience from people. These individuals don't know the...

Hmmm. That is odd. I had a short period where our local spam blocker was taking out the daily emails, but never the discussion alerts.

Let me know if you got...

From the description it sounds like an inline function, but I have to ask, is it? If it's a multi-statement UDF, that could explain the performance issues too.

Thoughts?

I wish I was a consultant who worked near your office so I could make all the great money that's going to roll in when those queries have to be...

Sorry man, it's just you. You're not really appreciated any more.

Kidding. Seriously, I've been getting my emails fine, so there must be something happening to yours.

samalex (2/18/2009)

---

Hey Guys,

Thanks for the replies... if you have a moment I have some questions now that I have VS2008 DB Edition installed and have been using it for...

GSquared (2/18/2009)

---

Didn't think of those. Yes, they work. But I'm used to copy-and-pasting my code from SSMS into the forums. Every time that includes some XML, it...

I assume with the code formatting we'll be able to put a semi-colon in the code without having to sweat getting smiley faces:

SELECT * FROM (SELECT * FROM dbo.MyTable);

We've been using it pretty extensively for years. Yeah, it pretty much takes over as a development mechanism on your databases. However, it doesn't replace SSMS. There's still stuff that...

Given my druthers, I go with a singular object name, but I've long ago stopped worrying about some of the silly stuff. This is especially true when we have people...

Chris Lane (2/18/2009)

---

Yes, that is exactly what I need, but what to call the Question to group join table?

Question

QuestionID PK

QuestionGroup Or Just Group? Group by itself seems to vague.

QuestionGroupID...

So, we have a Survey, a Question, and a Group? What's the Group do and how does it relate to both Question & Survey? It really depends on how the...

And are you still seeing parallelism in the execution plan?

There has to be something going on, something different. If you simply air drop a database...