Viewing 15 posts - 121 through 135 (of 180 total)
Hi,
The first problem you will bump into is that is impossible to restore backup of 2016 on an earlier version of SQL Server.
The only way to have...
December 21, 2017 at 4:06 pm
Check this document - http://download.microsoft.com/download/D/2/0/D20E1C5F-72EA-4505-9F26-FEF9550EFD44/SSAS_Failover_Cluster_V4.docx
December 19, 2017 at 7:01 pm
mcahren - Sunday, December 17, 2017 11:00 AMAny ideas?
Parameter sniffing doesn't work for the second query. There are several ways to...
December 17, 2017 at 1:02 pm
TABLOCKX is a shorter version of (TABLOCK, XLOCK).
December 14, 2017 at 6:46 pm
In my case the result is consistent, I used this script:
declare @Paper
December 14, 2017 at 4:20 pm
Accordingly with the official documentation there is no difference:
TABLOCK
Specifies that the acquired lock is applied at the table level. The type of lock that...
December 14, 2017 at 4:04 pm
December 11, 2017 at 7:06 pm
It doesn't work on versions 13.0.4435 and 13.0.1601. So I would say that correct answer is "You cannot do this with STRING_SPLIT()."
My points are:
1. It is not...
December 11, 2017 at 4:11 pm
December 1, 2017 at 11:03 am
KJKKPSI - Wednesday, November 22, 2017 6:44 AM...It is not working with standard OLAP or Tabular connections...
Hi, check this article -...
November 23, 2017 at 5:33 pm
You can try Data Viewers - https://docs.microsoft.com/en-us/sql/integration-services/troubleshooting/debugging-data-flow
November 23, 2017 at 4:11 pm
November 22, 2017 at 1:04 pm
Hi,
The Standard tier in Azure supports databases up to 1Tb in size. If your database will grow you may need to switch to the Premium tire which is much...
November 21, 2017 at 3:49 pm
bmg002 - Thursday, November 16, 2017 8:26 AMFrom my understanding, UNMASK is a database level permission.
It is the database level permission indeed:
https://docs.microsoft.com/en-us/sql/t-sql/statements/grant-schema-permissions-transact-sql
November 16, 2017 at 2:51 pm
Hi,
You have partition function for the 6 values, so you have 7 ranges. In this case you need a partition scheme with 7 partitions.
Check the Microsoft...
November 16, 2017 at 2:44 pm
Viewing 15 posts - 121 through 135 (of 180 total)