SpringTownDBA (12/1/2011)

---

Alexander Suprun (12/1/2011)

---

SpringTownDBA (12/1/2011)

---

weighting factors are measures that go in the bridge table, otherwise, distinct counts are typically the only useful measure in a bridge table.

here's Microsoft's example from...

SpringTownDBA (12/1/2011)

---

weighting factors are measures that go in the bridge table, otherwise, distinct counts are typically the only useful measure in a bridge table.

here's Microsoft's example from msdn:

http://msdn.microsoft.com/en-us/library/ms345139(v=sql.90).aspx#sql2k5_mmdim_topic4

anyway, the...

You don't need to specify relation between "DIM D" and "Intermediate B to A". What for?

Are you going to calculate some values in "Intermediate B to A" by "Dim D"?...

Elliott Whitlow (11/30/2011)

---

Phil Parkin (11/30/2011)

---

jnichols-797753 (11/30/2011)

---

T hanks. I was expecting this reply but hoping someone had found a secret MS was holding back on. I wonder if there...

Craig has already posted some test scripts with different solutions and comparison in another topic.

Check this out: http://www.sqlservercentral.com/Forums/FindPost1210550.aspx

http://lmgtfy.com/?q=compress+specific+tables+msdn

Hi Craig,

I've played around with your scripts and here are my thoughts and findings:

I see why you've created index on UpdateDate in DESC order rather than ASC so in this...

Thanks guys, very interesting stuff, I am definitely going to play with these scripts provided.

I'll be waiting...

Could you post the Execution Plan and scripts as attachments?

p-nut (11/22/2011)

---

I understand what you are saying in a simple example, but we cannot appropriately help the OP without the DDL. All the OP said was that it was an...

p-nut (11/22/2011)

---

Alexander Suprun (11/21/2011)

---

From my experience using CROSS APPLY will force the server to do LOOP JOIN which may be not...

From my experience using CROSS APPLY will force the server to do LOOP JOIN which may be not the best option....

Kwisatz78 (11/21/2011)

---

Hi there, I will post this tomorrow if thats ok, the query is ginourmous which is why I was only intrigued by this aspect of it.

Thanks for the info...

mister.magoo (11/19/2011)

---

One word - ROWVERSION - I don't think you can break this...

BEGIN TRAN

-- Let's have a test table with an identity (to be forced out of order)

-- and a...

captcooldaddy (11/15/2011)

---

I'm just started working at this place and there must be some setting on the ssms that they set up on my box.

Whenever i open a new window for...