Forum Replies Created

Viewing 15 posts - 1,621 through 1,635 (of 1,988 total)

  • RE: can I safely use top n for select/delete in a while loop?

    Chances are in your case yes they would operate on the same row but that's by no means guaranteed unless you specify more criteria and definitely not something you would...

  • RE: T-SQL interview Questions

    abhishek_300 (7/28/2015)


    Thanks Gila monster for your comments .However for interviews people do not ask simple question on SQL hence you are seeing unrealistic example.

    There's no reason an interview question can't...

  • RE: Is It Worth Writing Unit Tests?

    Just out of curiosity how do people feel about the concept of rapid development as it relates to unit testing since the concept of small individual separate components is pretty...

  • RE: Is Skynet Coming?

    jckfla (7/24/2015)

    Essentially, added function doesn't make a product better, more productive, or more useful automatically. One of the reasons why I've been slowly steering away from Windows for at-home...

  • RE: Is It Worth Writing Unit Tests?

    ZZartin (7/23/2015)


    peter-757102 (7/23/2015) solution.

    The reasoning that it's a small step from testing to unit tests I cannot subscribe to.

    Some factors that are needed to make the step are:

    * Persisting and...

  • RE: Is It Worth Writing Unit Tests?

    peter-757102 (7/23/2015) solution.

    The reasoning that it's a small step from testing to unit tests I cannot subscribe to.

    Some factors that are needed to make the step are:

    * Persisting and organizing...

  • RE: Is It Worth Writing Unit Tests?

    peter-757102 (7/23/2015)


    ZZartin (7/23/2015)


    Shouldn't a better question be, can you write code perfectly on the first try 100% of the time?

    If the answer is anything other than a definitely yes then...

  • RE: Is It Worth Writing Unit Tests?

    Shouldn't a better question be, can you write code perfectly on the first try 100% of the time?

    If the answer is anything other than a definitely yes then yes you...

  • RE: array variables in sql server?

    Nope, but you can always make a temp table with an identity column 😀

  • RE: Migrate DTS package(SQL 2000) to SQL 2014

    You might be stuck redeveloping them. I don't even think the DTS migration wizard exists in SQL Server 2014(microsoft gave you something like 12 years to migrate them or...

  • RE: Today's Random Word!

    SQLRNNR (7/21/2015)


    cow

    Pie

  • RE: Server-side vs App-side

    rmechaber (7/17/2015)


    TheSQLGuru (7/17/2015)


    rmechaber (7/17/2015)


    Another perspective: do you actually need to store the subtotal in the OrderHeader table?

    This could be computed on-the-fly using views or stored procedures from the actual order...

  • RE: Would You Pay To Wear Jeans?

    Hmm... I would probably be insulted if the company I was working for tried to charge me to dress a certain way. If there's a dress code there's a...

  • RE: Server-side vs App-side

    Another side of this is that if for whatever reason you need to change the calculation you're using if you store it on the top level record you would then...

  • RE: DBA work management

    What are the typical daily tasks you get? Are they development related, are they administration tasks?

    Typically what I've prefered is that for development related tasks whoever developed it(or inherited...

Viewing 15 posts - 1,621 through 1,635 (of 1,988 total)