If you are only trying to compare email1, then this will return all email addresses being used by more than one employee...

SELECT email1

FROM #temp1

GROUP BY email1

HAVING COUNT(*)>1;

If you need to...

So what did you try?

I don't have an Oracle instance to connect to, but when you run the wizard to add a Data Source, you can choose "Oracle Database" from...

A quick search turned up a ton of information...

Oracle Connection Type (SSRS)

Data Sources supported by SSRS

How to add an Oracle data source in SSRS

Did you, by chance, drop a Matrix into your report design surface instead of a Tablix? Try them side by side to see the difference.

You don't do anything different. The combination of the partition scheme and function determine the partition the record will be written to. SQL Server handles all that for you....

It appears that Steve Jones (the guy that runs this show... I mean website) wrote several articles about tSQLt. This is the first one[/url]. Try reading some of...

I think the one migration/upsizing path that is not available is from PowerBI Desktop to SSAS.... so of course, that's what I did. Just seems strange that you can...

Will do. I guess I'm still a serious noob when it comes to DAX... just getting my head around the way it works is hard!!!

I was thinking I should just...

Bummer. That's what I was afraid of.

What do you do if the model is missing a measure or two and maybe some useful calculated columns? Call the developer, because...

Looks like this should do it...

http://stackoverflow.com/questions/11301383/automatically-drop-and-recreate-current-indexes

EXEC sp_MSforEachTable 'ALTER INDEX ALL ON ? DISABLE'

and

EXEC sp_MSforEachTable 'ALTER INDEX ALL ON ? REBUILD'

is all you need if you want to do it for...

Open SSMS.

Right-click the Databases folder in Object Explorer. One of the options is ATTACH. It should prompt you for file locations of the data and Log files

Do you mean a primary key?

did you not try attaching them? (Don't forget the log files).

Okay... having added a bunch of references about partitioning, read this one[/url] first... It's Gail Shaw's... (don't know why I didn't start there!). Be sure you understand what partitioning...

Is there a good beginner book on Multi-Dimensional / Tabular? I've been playing with DAX for a while (and I'm still terrible at it!)

Especially one that covers security/RLS.