Ran ACE OLEDB on SQL box for last 12 years. No issues
@rebornfenix4412
7 ай бұрын
3:03 I use that same sort of pattern when making large updates/ inserts of data through EF. Before EF 7, the best way to get performance was to create temp table then merge since ef would update one row at a time. Want to update 200 rows and get any performance? Use a temp table then use set based update queries to join the temp and actual data table.
@TS-kb6sd
7 ай бұрын
You often indicate just how expensive SQL Server is, so I was surprised to hear you recommend running SSIS on a separate VM since that will require it's own SQL licensing.
@BrentOzarUnlimited
7 ай бұрын
Yes, but you can use Standard Edition and license SSIS by the core, or you can license SQL Server at the VM host layer and then run tons of VMs on it.
@Kane0123
7 ай бұрын
Giannis is in shambles right now.
@BUY_YOUTUB_VIEWS_d0dd115
7 ай бұрын
I played this at my job orientation, and now it's part of the company culture
Пікірлер: 6