Viewing 15 posts - 31 through 45 (of 218 total)
Also, for SQL Server 2019, you should use ALTER SERVER CONFIGURATION SET PROCESS AFFINITY CPU=;
The sp_configure option will be deprecated.
October 19, 2020 at 7:29 am
Do you have a short example or suggestion of when data profiling can withstand a per element tolerance of +/- 2 percent other than polls?
Quite honestly, I can't be...
June 1, 2020 at 6:48 pm
Good question to showcase a new feature!
From a BI/DS perspective, this is potentially very useful for data profiling.
June 1, 2020 at 9:11 am
Had to take a wild guess here, as Unit_Cost doesn't seem to be available in the data frame...
May 27, 2020 at 7:21 am
Interesting question.
As an R novice, it's extremely difficult to deduce from the referenced documentation that COUNT can do this. None of the (rather terse) examples outline this simple use.
May 13, 2020 at 8:28 am
Great question (albeit a tad nefarious!)
And this is precisely why both semi-colons and AS for aliases should always be used!
April 30, 2020 at 7:22 am
Well, I managed to guess how the author arrived at what was designated as the correct answer. But clearly, that is a gross misunderstanding of the cited article from BOL.
March 31, 2020 at 11:21 am
A bit iffy, this one. Change tracking cannot be enabled on a database that contains In-Memory OLTP objects. And CDC is only available from CU15 and up.
March 19, 2020 at 7:37 am
Read the question, and thought: I'm not going to touch this with a ten-foot pole, until it has been reviewed. The discussion bears this out...
On a side note: It used...
March 16, 2020 at 9:41 am
Sorry for [semi]colon 🙂
It's all right for error, because GO is a batch separator: @x is declared in the first batch and not in the second. It's the same...
March 13, 2020 at 4:24 pm
A semicolumn is missing after the two exclamation mark.
Here's from BOL:
Supported SQLCMD Syntax
The Database Engine Query Editor supports the following SQLCMD script keywords:
[!!:]GO[count]
Except that's a colon, not a semi-colon...
March 13, 2020 at 4:08 pm
Yeah, definitely in SQLCMD mode. I use it alot. I tried
!! GOas well.
Confirmed. I went ahead and tried the same as you. In SSMS you get...
March 13, 2020 at 3:26 pm
DOH!
I read that article right up to the line preceeding the one with the pertinent information.
Now I must finish my coffee!
March 13, 2020 at 7:13 am
Good question! Can we expect one for proper next? 🙂
March 11, 2020 at 7:33 am
Viewing 15 posts - 31 through 45 (of 218 total)