I bet they are going to lose. Hard. 😀

Duplicate post. Original thread with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1580791-2797-1.aspx

andrew gothard (6/13/2014)

---

" store the dates as integers, like 20140612, and then join to a 'Date' table with this 'key' to get a real date field" - this still is...

Michael Valentine Jones (6/13/2014)

---

Something no one has mentioned is DATETIME in the fact table for situations where it may be important. I have seen people break date and time...

jasona.work (6/13/2014)

---

WHY can't MS come up with a better way to store the duration of Agent jobs? Saving it as an INT? Really? I mean, I can...

Jeff Moden (6/13/2014)

---

I really don't like integer dates. They're tough to do date math with and they have no built in checks for whether an entry is a legal...

Sean Lange (6/13/2014)

---

The semantics here seem to be a little bit mixed. It seems that some of these integers are dates and others are keys. The keys one I have...

You really opened Pandora's box here 🙂

My mailbox is overflowing 🙂

GilaMonster (6/13/2014)

---

SQLRNNR (6/13/2014)

---

GilaMonster (6/13/2014)

---

Thought process of last 10 minutes.

- Tune a proc quick, then go home

- Wait, it's got user defined functions

- Wait, the UDFs have cursors

...

Ah, the world cup...

Eirikur Eiriksson (6/13/2014)

---

You have to use BIDS or SSDT,...

Take a look at this article:

Retrieve Data from a Data Mining Model (DMX) (SSRS)

Can you take a screenshot of the context menu that you get when you right click on the package?

Don't notice anything different.

Why not? I could use some sleep 🙂