Forum Replies Created

Viewing 15 posts - 46 through 60 (of 233 total)

  • Reply To: Estimate a count

    Jeff Moden wrote:

    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...

    Just because you're right doesn't mean everybody else is wrong.

    June 1, 2020 at 6:48 pm

    #3759200

  • Reply To: Estimate a count

    Good question to showcase a new feature!

    From a BI/DS perspective, this is potentially very useful for data profiling.

    Just because you're right doesn't mean everybody else is wrong.

    June 1, 2020 at 9:11 am

    #3759001

  • Reply To: A chart of costs in R

    Had to take a wild guess here, as Unit_Cost doesn't seem to be available in the data frame...

    Just because you're right doesn't mean everybody else is wrong.

    May 27, 2020 at 7:21 am

    #3757628

  • Reply To: Counting the Groups in R

    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.

    Just because you're right doesn't mean everybody else is wrong.

    May 13, 2020 at 8:28 am

    #3751079

  • Reply To: Bad Error Handling

    Great question (albeit a tad nefarious!)

    And this is precisely why both semi-colons and AS for aliases should always be used!

    Just because you're right doesn't mean everybody else is wrong.

    April 30, 2020 at 7:22 am

    #3747575

  • Reply To: @@CURSOR_ROWS -m Flag

    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.

    Just because you're right doesn't mean everybody else is wrong.

    March 31, 2020 at 11:21 am

    #3739239

  • Reply To: More Memory Optimized Table Limitations

    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.

    Just because you're right doesn't mean everybody else is wrong.

    March 19, 2020 at 7:37 am

    #3735515

  • Reply To: Backing Up Some Log

    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...

    Just because you're right doesn't mean everybody else is wrong.

    March 16, 2020 at 9:41 am

    #3734637

  • Reply To: The SQLCMD GO

    Carlo Romagnano wrote:

    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...

    Just because you're right doesn't mean everybody else is wrong.

    March 13, 2020 at 4:24 pm

    #3734136

  • Reply To: The SQLCMD GO

    Carlo Romagnano wrote:

    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...

    Just because you're right doesn't mean everybody else is wrong.

    March 13, 2020 at 4:08 pm

    #3734127

  • Reply To: The SQLCMD GO

    IMHO wrote:

    Yeah, definitely in SQLCMD mode.  I use it alot. I tried

    !! GO

    as well.

    Confirmed. I went ahead and tried the same as you. In SSMS you get...

    • This reply was modified 6 years, 2 months ago by Rune Bivrin.

    Just because you're right doesn't mean everybody else is wrong.

    March 13, 2020 at 3:26 pm

    #3734101

  • Reply To: The SQLCMD GO

    IMHO wrote:

    I get an error when I use !!GO:

    'Go' is not recognized as an internal or external command,
    operable program or batch file.

    But i can use:

    Just because you're right doesn't mean everybody else is wrong.

    March 13, 2020 at 3:13 pm

    #3734093

  • Reply To: The SQLCMD GO

    DOH!

    I read that article right up to the line preceeding the one with the pertinent information.

    Now I must finish my coffee!

    Just because you're right doesn't mean everybody else is wrong.

    March 13, 2020 at 7:13 am

    #3733923

  • Reply To: Capitalize the name

    Good question! Can we expect one for proper next? 🙂

    Just because you're right doesn't mean everybody else is wrong.

    March 11, 2020 at 7:33 am

    #3733092

  • Reply To: The Triple Update

    Jeff Moden wrote:

    Heh... I wonder how many people actually got this question right without having to run the code?

    I've been using a related technique to emulate STRING_AGG, so it wasn't that...

    Just because you're right doesn't mean everybody else is wrong.

    March 10, 2020 at 12:04 pm

    #3732770

    • Viewing 15 posts - 46 through 60 (of 233 total)