Viewing 15 posts - 31 through 45 (of 221 total)
I'm sorry, but I just don't understand what is being asked here.
November 10, 2020 at 10:02 am
Doh!
Didn't spot the start at 1 condition. More coffee!
November 4, 2020 at 1:21 pm
Yep. I think this stems from the how the original character wasn't an actual question mark, but rather an extended character, which the font used to present the question couldn't...
November 3, 2020 at 7:46 am
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
Viewing 15 posts - 31 through 45 (of 221 total)