Viewing 15 posts - 1,996 through 2,010 (of 2,701 total)
IF you have SQL Enterprise AND software assurance you can leave the components at 2016 level and install an instance of 2017 PBIRS on the same licensed server and that...
June 4, 2019 at 4:14 pm
you have been asking around this already see https://www.sqlservercentral.com/forums/topic/sql-server-2012-data-column-used-for-7-different-languages - you either do not know exactly what you need or you do not understand the answers given.
SQL Server does not...
June 1, 2019 at 7:21 pm
and I'm not even sure the code is doing what they expect
just a small example.
the following inline query is summing the value of the outside table and has a group...
May 24, 2019 at 8:17 am
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...
May 24, 2019 at 8:01 am
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
May 24, 2019 at 7:08 am
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
May 23, 2019 at 10:12 pm
May 23, 2019 at 7:42 pm
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...
May 17, 2019 at 9:52 pm
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...
May 17, 2019 at 5:08 pm
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...
May 14, 2019 at 11:01 pm
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...
May 11, 2019 at 9:52 am
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"...
May 6, 2019 at 1:46 pm
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...
April 22, 2019 at 10:55 pm
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...
April 21, 2019 at 7:20 pm
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.
April 21, 2019 at 9:04 am
Viewing 15 posts - 1,996 through 2,010 (of 2,701 total)