yes.

All access to a sql server database instance is done through a provider (normally OLEDB) so it does not matter if database is on an instance with same name or...

you need to setup 2 instances

Instance 1

-sql server

-ssis

-ssrs

-ssas tabular

instance 2

-ssas dimensional

have a look at this document http://www.vmware.com/content/dam/digitalmarketing/vmware/en/pdf/solutions/sql-server-on-vmware-best-practices-guide.pdf.

As said above if a physical host is going to be fully dedicated to a single SQL instance then its better to have it...

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