Bring on Part 4. Can not be published too soon.

pcd

Alan

It's so unfortunate that people respond to your offering criticizing what you have done and made freely available. I have a simple response "If you don't like it, don't use...

Jeff

I guess we have all had our wins of note. I think my best was 4h+ to under 13minutes.

I also don't deny the importance of squeezing all available performance with...

Adi Cohn-120898 (8/2/2016)

---

I think that an example can show one aspect of the problem. Take a look at the code bellow. I'm not modifying the data, I'm just...

John Mitchell-245523 (8/2/2016)

---

Given that this is a data warehouse application, all the data is sourced from existing databases, so in theory it should be correct. That said I did work...

Eirikur Eiriksson (8/2/2016)

You will have to understand how the SQL Server works, which workload is expensive and which factors bear more weight than others, data sizes and IO do have...

Eirikur Eiriksson (8/2/2016)

---

pcd_au (8/1/2016)

---

There's a great article here (http://sqlfool.com/content/PerformanceConsiderationsOfDataTypes.pdf) about WHY you should pick the appropriate scale of a datatype, but in this day and age of fast(er)...

John Mitchell-245523 (8/2/2016)

---

Also, choosing the appropriate data type (and scale) helps prevent absurd data from getting into your database - you know, dates that aren't proper dates, phone numbers with...

I thought TFS supports GIT. We are using the Visual Studio Team Services and it appears to be working OK for us, but it's a small setup / project.

pcd

Phil

Currently only one, but we have proven that we can run multiple SSIS servers, with centralised logging / monitoring / reporting.

As for the number of packages, I have a model...

.

The recommendation we received from a MSoft consultant recently was reserve 2Gb for the OS for each 16Gb of memory - if the server is dedicated. Just another guideline to...

to get the collation of a column of a table

select COLLATION_NAME

from information_schema.columns

-- you complete this bit as necessary

where table_name like '%'

and column_name like '%'

or have I missed something?

pcd