careusa2003 (3/17/2010)

---

This is good stuff.

My question is what if the user switches the two inputs (Vejle, 17). The SQL would do a compare with the wrong columns to data....

Hi Ray

The event will start around 8:30 AM - 9:00 AM. The official schedule should be published later this month when we meet to assign speaker sessions to tracks....

Hi Ray,

I'm on the team that's bringing SQLSaturday to NYC, and here are some things you can expect:

* We've invited dozens of top experts in the industry to present on...

Matt Arpidone (1/30/2010)

---

What I meant was that in a peer reviewed public forum, criticism should be welcome, even encouraged as long as it is well structured, helpful, and avoids personal...

Paul White (1/29/2010)

---

Mike C (1/29/2010)

---

What Tony is referring to is the fact that the CTE regenerates the GUID every time the "rn" column is referenced from the CTE. This...

Paul White (1/30/2010)

---

Matt,

I wouldn't take it too much to heart. There is always a risk of misunderstanding arising when communication occurs in this medium. Personally, I didn't find...

Matt Arpidone (1/30/2010)

---

Thanks Mike, I'll keep in mind that any criticism of articles or disagreement will be met with animosity. I guess my opinion isn't welcome unless I agree...

Paul White (1/29/2010)

---

RBarryYoung (5/12/2009)

---

tony rogerson (5/12/2009)

---

Using non-deterministic functions like ROW_NUMBER and NEWID need to be done carefully - my blog article: http://sqlblogcasts.com/blogs/tonyrogerson/archive/2008/06/12/bug-in-inline-expansion-of-non-deterministic-functions-in-derived-tables-and-cte-s-causes-incorrect-results.aspx explains the serious bug that exists in SQL...

Matt Arpidone (1/29/2010)

---

DISCLAIMER: I do not consider myself to be a "DBA", and I don't have any sort of certification.

I'm going to have to disagree with most of you...

Hey Ron,

It's even easier if you have SQL 2008 -- the DateTimeOffset data type holds date/time and offset information together. The only thing I would mention about your script...

Ayie, that's a completely different set of stored procedures. I haven't seen the xp_makewebtask proc in a long time to be honest. Check your server settings and make...

duda (10/26/2009)

---

Thanks and that’s a good article but I have a question though.

I have 2 dimensions stored in the same SQL table (data mart).

Data for my date dimension is...

Hi Tony,

Funny you mentioned extended properties 🙂 I'm working on a little set of apps right now that will greatly simplify working with them. Of course the Intellisense...

Sorry I've been out of the loop for a while. Thanks for the update Roman! If you don't mind I'll grab the newest Irony DLL and rebuild the...

It's tempting to say "sorry it didn't work out, good luck", but if you'd be willing to post...