To be honest, I'm...

Toreador (6/18/2014)

You are working for a company that has uses SQL 2012 for their on site databases. A fellow DBA is trying to do a quick check on a database...

The JET OLE DB provider is only available in 32-bit, so the query needs to run in 32-bit as well.

The JET provider only has a 32-bit version.

BWFC (6/18/2014)

Koen Verbeeck (6/18/2014)

BWFC (6/18/2014)

This explicitly rules out that the databases are in the...

BWFC (6/18/2014)

This explicitly rules out that the databases are in the cloud, the answer...

sparikh (6/17/2014)

Thanks for the reply.

as of now i have only created sample cube in BI and browse it through BI Browser.

i think this can be done by analysis service...

What if you put a dummy select statement in the Execute SQL Task first. Something like "SELECT '1','2'". This dummy statement will be replaced with the expression anyway.

The User::varRestoreScript variable,...

You are trying to store the value 18 in a month, which is not possible of course.

You can either use CONVERT to convert the string to a datetime. You only...

The answer is incorrect.

The question clearly states that the databases are on site. Thus, by the process of elimination, the corruption answer is the only one left.

rhythmk (6/17/2014)

So are you ok with dropping a table having 90 million records from any environment ? Think of the scenario when you are working on some...

The expression seems OK, except for the + sign. What is it doing there?

The views being what they are, you can only create 1 dimension which holds all the attributes of view 1.

This is because your fact table (which is view 2) has...

How do you link Thomas from View 1 to the measures in View 2?

Is record key the same?

Ah, I actually meant those ones. I...