Thanks

Thanks to all for your responses. I wanted to work with V1.0 to make use of the data models. The data models can hide joins and I can add computed...

I uploaded them again! Once the moderator will refresh the article, they should be there. Sorry for this

Thanks to all for your comments.

Phil Parkin (5/14/2015)

---

An interesting read, thank you very much. Hope you don't mind me mentioning a few minor typos:

'FacTransaction_ColumnStore' – needs an extra 't'

'Compression ration' – ratio

'foorprint' – footprint

'datawarhouse' –...

Jeff Moden (5/8/2015)

---

I have to remind everyone that changing a database to the SIMPLE Recovery Model is one of the very worst things you can do if Point-In-Time Backups are...

See if this helps - https://technet.microsoft.com/en-us/library/ms190421(v=sql.105).aspx

Thanks for your comment. If...

rchantler (5/7/2015)

---

"You can change the Optimize for Ad hoc Workloads to True.This setting will not have a direct performance impact on SELECTS, however it will improve the efficiency of the...

Thanks for the links. I should have included them in the article.

GilaMonster (8/4/2014)

---

There's nothing about local variables which prevent index usage.

That 30% is the worst possible case for a guess by the optimiser, not the norm. If it can manage a...

Hi

In the Connection manager of SSIS, I have the option to Use...

Yes I can connect successfully when I...

Nevyn (7/24/2014)

---

I am guessing that you are using Windows Authentication? Are you logged into the production server you are trying to run the package from, or are you connecting...

Yes I am. Do please note that the 'Test Connection' of the Connection Manager is successful. The only difference from my...