as per the article if all indexes are on the same PS it will work.

But you need to consider is that some indexes that are non partitioned may have been...

in order to do the switch you need to drop the non partitioned indexes and recreate them afterwards

see https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-table-transact-sql?view=sql-server-2017 and go to the switch partition description

does look like the same question with changed details that you posted before https://www.sqlservercentral.com/forums/topic/sql-server-2012-data-column-used-for-7-different-languages

have a look at https://www.sqlservercentral.com/articles/mail-fails-with-sqlcmd-error

IT removing Outlook from the server was the correct thing to do - Outlook is not a server component, is not supported from Microsoft while running on a server as...

with linked server you can join all 3 sources - but DO NOT DO IT!!!

As you read it and mentioned on your post it will copy the data from the...

I decided to try to push some buttons on this, and sent an email to the relevant European commissioner, saying The latest "upgrade" of the Microsoft  Winows 10...

In other news, what do you do when 2 CLI languages for your OS's isn't enough: Introduce a third: https://devblogs.microsoft.com/commandline/introducing-windows-terminal/ I admit I haven't read too far into...

following article from Solomon Rutzky probably what you looking for https://sqlquantumleap.com/2018/02/15/safely-and-easily-use-high-level-permissions-without-granting-them-to-anyone-server-level/

His CLR related posts are really a must read for anyone that needs to allow users to use "higher privilege"...

Although it is one of those things that experienced people would frown upon, its purpose is to ensure that the one being interviewed knows how to deal with conditional flows...

Thom - VS 2017 now has a Data tools options as part of its install  but unfortunately MS messed it up and the default SSDT VS 2017 setup only installs...

from the documentation

Install Analysis Services, Integration Services, and Reporting Services tools

To install AS, IS, and RS project support, run the SSDT standalone installer.

https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-2017#ssdt-for-vs-2017-standalone-installer

you need to install the correct components from Oracle client - if your workstation is 64 bit you need both 64 and 32 bit Oracle client.

when installing (Custom installation) you...

your company should contact Microsoft and/or one of their vendors and ask for that info.

Regarding SQL server yes they do need to pay for it - MSDN SQL Server can't...

cross post from another forum https://www.tek-tips.com/viewthread.cfm?qid=1794041 - reply posted there.