Forum Replies Created

Viewing 15 posts - 1,291 through 1,305 (of 3,348 total)

  • RE: Columnstore Index metadata

    Thanks, all, for the kind words!

    And while I realize that this may be perceived as a trick question, that was not my intention - I submitted this question to point...

  • RE: What are your five most common T-SQL commands

    Grant Fritchey (8/26/2015)


    Ed Wagner (8/26/2015)


    Hugo Kornelis (8/26/2015)


    GilaMonster (8/26/2015)


    Gazareth (8/26/2015)


    But probably the most common: DELCARE left left left backspace left C 😛

    In that case, mine would be SEELCT left left backspace...

  • RE: What are your five most common T-SQL commands

    GilaMonster (8/26/2015)


    Gazareth (8/26/2015)


    But probably the most common: DELCARE left left left backspace left C 😛

    In that case, mine would be SEELCT left left backspace left L :hehe:

    Interesting. My "favorite" typo...

  • RE: What are your five most common T-SQL commands

    Here are the ones I think I use the most:

    1:

    BEGIN TRAN;

    go

    go

    ROLLBACK TRAN;

    go

    (after that, I type something in between the two "go" lines. But I always start with this and then...

  • RE: Changing Schedules

    Good question. I don't think many people are aware of this alternative method to change schedules. (And it can be handy to know it exists in edge cases where you...

  • RE: columnstore index maxdop

    I am happy to see questions about columnstore indexes, because I really love this feature. (I love everything that makes SQL Server go faster, actually).

    But I am not happy to...

  • RE: SSIS Conditional Split Expressions

    I almost got this wrong, because upon first reading of the question I thought this was about an execution plan operator.

    Luckily, I remembered that the operator that the description would...

  • RE: Real to Float

    Sean Lange (8/12/2015)


    wedneyyuri (8/12/2015)


    Good question.

    So, what's the correct way to do the conversion?

    DECLARE @real REAL= 43.39061;

    SELECT @real

    SELECT CONVERT(FLOAT, @real)

    SELECT CAST(@REAL AS...

  • RE: Print a nvarchar variable

    Mighty (8/11/2015)


    Toreador (8/11/2015)


    "however, you have to append in increments with each increment less than or equal to 4000"

    Not true.

    +1

    Not sure where that assumption is coming from. Seems incorrect to me...

  • RE: Polybase SQL Server 2016

    julienchappel 38298 (7/22/2015)


    Sorry but the response of the Which server collations are supported in Polybase SQl Server 2016 in SQLServercental is wrong or they don't read MSDN. The correct answer...

  • RE: SET vs. SELECT

    vdkolekar (7/21/2015)


    Tricky question

    Sorry I didn't understand it clearly.

    Why both of below queries give Null Values.

    DECLARE @a INT=0;

    DECLARE @b-2 INT=0;

    SET @a = (select 1 where 1=2);

    SELECT @b-2 = (select 1 where...

  • RE: Database Mirroring Restrictions

    Carlo Romagnano (7/17/2015)


    Hugo Kornelis (7/16/2015)


    Koen Verbeeck (7/15/2015)


    Meh, who cares about mirroring

    Perhaps, everyone who does not have the budget for Enterprise Edition?

    From BOL:

    If you are running an edition of SQL Server...

  • RE: Drop a temporal table

    Koen Verbeeck (7/16/2015)


    Richard Warr (7/16/2015)


    Koen Verbeeck (7/16/2015)


    Hmmm, people have actually selected "drop the database". :w00t:

    That would certainly achieve the stated goal.

    Plus some other ones.......

    If the goal is to leave the...

  • RE: Database Mirroring Restrictions

    Koen Verbeeck (7/15/2015)


    Meh, who cares about mirroring

    Perhaps, everyone who does not have the budget for Enterprise Edition?

  • RE: SQL for 8-year-old Math…But Be Careful of Implicit Type Conversion

    Rusxs (7/15/2015)


    The original question was using each number just once, so 1/3 + 2/3 = 1, though correct, is not applicable here as it won't happen.

    1/3 + 4/6

Viewing 15 posts - 1,291 through 1,305 (of 3,348 total)