Forum Replies Created

Viewing 15 posts - 241 through 255 (of 848 total)

  • RE: SQL Server 2012 service accounts

    Thomas Abraham (10/25/2013)


    Didn't know the answer. But, FALSE seemed a reasonable guess, as that's what I would expect. Hard to see why they would recommend using specific user accounts.

    +1

  • RE: Date Functions

    Nice, easy one. I'm surprised this function hadn't come up in a question before now.

  • RE: Slowly Changing Dimension Transformations

    steve.jacobs (10/22/2013)


    KWymore (10/22/2013)


    L' Eomot Inversé (10/22/2013)


    Remarkably easy for a 2 point question.

    Agreed, maybe it was marked for 2 points because we don't get a lot of DW-specific questions? Had it...

  • RE: Slowly Changing Dimension Transformations

    L' Eomot Inversé (10/22/2013)


    Remarkably easy for a 2 point question.

    Agreed, maybe it was marked for 2 points because we don't get a lot of DW-specific questions? Had it been an...

  • RE: Slowly Changing Dimension Transformations

    Very easy and relevant question for me as I do a lot of ETL and DW work.

  • RE: Space missing in SELECT statement

    Fun question. Thanks Ashish.

  • RE: ISNUMERIC(varchar)

    Two days in a row of easy questions. Didn't have to think long on this one! 🙂

    As for why many special characters show up as numeric, it has to do...

  • RE: Transaction

    Easy one! Thanks for submitting.

  • RE: Field Lengths

    Thanks for the question Steve! I know a number of developers who have probably never used datalength. It is good to see questions around functions that aren't used every day.

  • RE: What happens to a variable after COMMIT or ROLLBACK

    Thanks for an easy 2 pointer!

  • RE: Hekaton

    I was just reading about this the other day as well. Very timely question. Other than the columnstore index changes, I can't think of what else is changing offhand for...

  • RE: Filestream data

    Easy one for a Friday. Thanks Steve!

  • RE: Analyzing Dangerous Settings in SQL Server

    I think adding the list of dangerous settings with short explanations to the text of your post would make this a better article. While that information does reside in the...

  • RE: wildcards

    I am so glad I got to the QoTD late today. Easy one. Thanks Steve!

  • RE: Behavior of trigger

    SQLRNNR (9/10/2013)


    L' Eomot Inversé (9/10/2013)


    KWymore (9/10/2013)


    mtassin (9/10/2013)


    Jeff.MSSqlSage (9/10/2013)


    You guys certainly have an interesting definition of what defines "basics".

    I don't think an undocumented feature of the ALTER TRIGGER functionality qualifies as...

Viewing 15 posts - 241 through 255 (of 848 total)