Forum Replies Created

Viewing 15 posts - 256 through 270 (of 848 total)

  • RE: Behavior of trigger

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

    I don't know why or...

  • RE: CASE vagaries

    Miles Neale (9/9/2013)


    Ross.M (9/9/2013)


    Steve Jones - SSC Editor (9/9/2013)


    I have updated the answers and awarded back points.

    I was just about to say, don't know what everyone is talking about, the...

  • RE: ACID Properties Question

    Nice question about fundamentals. Thanks!

  • RE: Holiday Breaks

    It's now up to 73% correct. Do you think it will top out at 77%?

  • RE: Between & Collation

    tilew-948340 (8/28/2013)


    Good question. Thanks.

    I have a question (can't try it myself for now): in the case that the _CS option is not specified, "SQL Server considers the uppercase and lowercase...

  • RE: NTILE

    I've only ever used NTILE once and it was for a reporting request where they wanted a customer list and only wanted part of the customer base ranked by certain...

  • RE: SQL Server Tables

    I really wasn't expecting this much discussion around this question! But thanks for the humor and insights. Makes for enjoyable reading in between "real" work. 😀

  • RE: Transaction Trio

    Thankfully I don't use enough table variables to have ever run into this scenario. Good information to know. Thanks for the question!

  • RE: Clean Data

    sqlnaive (8/20/2013)


    I tried going through some of the docs but couldn't get it. Can someone brief me about what it does ??? Or any link providing the DQS functionality in...

  • RE: Clean Data

    I got my choices backwards, oh well. Thanks for the question around a newer feature.

  • RE: User with total points more than 30000?

    I knew there was a level above SSC Champion but wasn't sure of the exact classification until I looked up some blog posts. I didn't even think to check the...

  • RE: Should He Stay or Should He Go?

    After reading the article, I chose the path of giving Eric another chance through the use of a performance plan. Mainly because it didn't sound like a formal review with...

  • RE: SSIS 2012 -SSISDB

    I learned something with this question but had to do some extra interpretation to get the intended answers. I think it would have been better had the author avoided the...

  • RE: Expressions

    Very nice question. Challenging, but still fun. Thanks!

  • RE: Exists

    Nice question and discussion. Thanks twin.

Viewing 15 posts - 256 through 270 (of 848 total)