We don't have any indexes on this Fact table.

Sounds like we need to have a conversation with our DBA

The main goal at the moment is to ensure that when a monthly report goes out we can get the data out fast.

Instead of scanning 1.4 - 4 billion records,...

Good question

We are going to generate reports on a monthly basis by joining this Fact table to Dim_Date on a key.

Each month of data has about 100 million records.

The...

I believe you are correct.

I did notice that for instances where tables had clustered indexes, adding index to page space utilization of this query result would show double the correct...

Thanks for everyone's input.

Check this out for another solution: http://basitaalishan.com/2012/07/01/determine-space-used-for-each-table-in-a-sql-server-database/

How does it compare to MDW (master data warehouse)?

How does one deal with the fact table becoming read only once this index is added?

What is the suggested best practice when data needs to be added on a regular...

Will it properly extract .csv file and show in excel if some columns are nvarchar and contain data in Russian for example?

It looks like one would need to buy Mist software in order to get access to this feature:

http://varigence.com/Products/Mist/Capabilities

http://varigence.com/Forums?forumName=Biml&threadID=157

I've read here (http://varigence.com/Forums?threadID=157) that a feature to reverse engineer an existing package into BIML would be release back in 2011.

Does anyone know if it has been released?

It would be...

Hi,

Is there a way we can be notified if the next series article gets published (other than watching emails from SQL ServerCentral.com)?

Thanks!

Lowell - here is the wiki link to the description of the broadcast calender:

http://en.wikipedia.org/wiki/Broadcast_calendar

Alan - thank you very much for the provided code. I have to admit that it...

Hi opc.three,

I thought about bcp, but my sense (from what I heard as I have not worked with it much) is that there could be access issues with running bcp.

What...

Hi opc.three and Daniel Bowlin,

Thank you both for suggestions.

opc.three - would you be able to share the "power shell" code you wrote?

Daniel Bowlin - data profiling task is a great...

Thank you for your suggestions.

It makes sense.