As far as I know, R services are part of SQL Server 2016, which is now in beta (yeah, I know, it's officially called CTP). It has not yet been...

Here are my thougts, based on the query, the execution plan you posted, and the comments. I have not looked at the CREATE TABLE / CREATE INDEX script; it is...

UPDATE SomeTable

SET SomeColumn = 'domain2\John'

WHERE SomeColumn = 'domain1\John';

If I am still misunderstanding you, then please post your question in a more precise form. No "table something...

Just responding to the above without digging any deeper into the problem (so perhaps I...

Raghavendra Mudugal (2/12/2016)

---

From the answer section, it says - "Restore the differential backup from Friday night at 8pm".

I have one doubt - do we have to install the diff-backup of...

The login failed error message that SQL Server returns to the client is vague by design (to prevent hackers exploiting the information they are given).

You might find more information on...

curious_sqldba (2/12/2016)

---

I have a script which basically scripts out all the users along with permissions needed, my script will spit a script that should be executed to grant permissions. My...

I have limited SSIS experience, but I do know that it comes with Oracle connectors. So you should not have any issue connecting to Oracle, getting data out, and combining...

I disagree with Grumpy's first suggestion. Oracle may not "need" the AS for a table alias (and neither does SQL Server), but including it in my opinion greatly increases readability...

No need to install any additional components.

Creating a linked server and using openquery are standard features in SQL Server.

(You do obviously need access to SQL Server, and you need credentials...

Should be possible using OPENQUERY.

Documentation: https://msdn.microsoft.com/en-us/library/ms188427.aspx.

Heh! I was...

Someone, please tell me it's them and not me...

Since you are unwilling to provide the very simple answer we...

First the most important question (if it has already been asked, I have overlooked it): How much time does this query currently take, and how fast do you need it...