I...

what we do at my shop is as follows.

All databases on DEV/UAT/FIT are named as follows

XXX_YYY_999_databasename

where XXX is one of DEV/UAT/FIT

YYY is the developer code/name

999 is the project being worked...

use the ACE driver - 32 and 64bit available and will process all versions of Excel. freely available at microsoft https://www.microsoft.com/en-us/download/details.aspx?id=39358

first thing I would look at on a vm environment is to check if both vm host and the vm machines have their power settings to high performance.

check this http://oraclehunterz.blogspot.ie/2013/06/ora-02391-exceeded-simultaneous.html

if you are executing code and/or querying over a remote dblink that can also happen

-- check last post on http://www.orafaq.com/forum/t/96704/ for this last issue

Hum..

just for record I have given vilyana a working bit of code prior to the posting of the code above which I can't download at all as it gives an...

That helps.

regarding data by all means do not put real data.

something like

patient 1

patient 2

treatment 1

treatment 2

will do fine as long as the joins work.

And I hope you have dummy data...

complex - and a few answers required.

your code only contemplates 2 treatments and 2 courses - what if there are 5 or 10 treatments? or if there are more than...

have a look at http://hownottoprogram.azurewebsites.net/?p=631 - maybe it applies

ensure your backets are really as they should be.

you got 3 conditions - see which one is "incorrect" according to your expectations.

CASE

WHEN

-- condition 1

(CalendarSchool.schoolLevelOPS IN ('All', 'Elem') AND ScheduleStructure.name...

rowversion is only used to determine if a row has been changed on the following cases

1 - syncronization with another systems (but it won't catch deletes)

2 - to ensure that...

look here https://msdn.microsoft.com/library/mt204009.aspx

As said you can do it with C#. - but execute it on the SQL Server server machine, not locally on the users machine.

see https://msdn.microsoft.com/en-us/library/ms403355.aspx for ways to execute a...

newer versions of VS are supposed to be backward compatible..

and at least with SSDT for VS 2015 on the Integration Services project properties there is a TargetServerVersion property that allows...

you can do it in c# or powershell - see a good example here https://blog.netnerds.net/2015/01/powershell-high-performance-techniques-for-importing-csv-to-sql-server/

main thing is not loading everything in one go to a data table - load a...