Forum Replies Created

Viewing 15 posts - 16 through 30 (of 54 total)

  • RE: Best all-round monitoring tool for

    Hmm - could be lots of cores. Just checking now.

    It has 16 cores which I believe are spread across 4 CPUs, so maybe not that dangerous.

  • RE: Best all-round monitoring tool for

    I guess that cost is probably not an issue as you have just one server?

    That's true - that server has a huge number of CPUs in it though so per-CPU...

  • RE: Finding New Years Eve

    Just to be picky, it actually won't work after the 28th Jan due to that dateadd of a month in there 😛

    Happy new year

    Kev

  • RE: DECLARE - 1

    Vikas Pathak (10/4/2012)


    I want to know how much space my variable occupied after assigning the values to that variable?

    That's not how it works. When you assign the value 'xyz' to...

  • RE: DECLARE - 1

    rmechaber (10/3/2012)


    follow recommended practice and always specify a data length, and this issue disappears. But maybe that's the lesson of the day.

    I completely agree. Code that assumes default behaviour...

  • RE: DECLARE - 1

    rmechaber (10/3/2012)


    The CAST('xyz' AS VARCHAR) works the same as the initial DECLARE: if no length is specified for a VARCHAR, it defaults to 1.

    Rich

    But that suggests that running

    SELECT LEN(CAST('xyz'...

  • RE: DECLARE - 1

    Praveena-487125 (10/3/2012)


    Got to know that by default it takes the length as 1 if the size is not declared. Thank you....

    However, I still did not get the difference between...

  • RE: Transactions

    I also mused over the interpretation of 'success' before choosing my answer, and selected the wrong interpretation (I thought 'success' meant successfully rolling back.)

    However I also got it wrong on...

  • RE: Protecting Data

    SanDroid (10/19/2011)

    Totally did not get the reference of Rougue to Rouge.

    That would certainly make my comments seem very strange 🙂

  • RE: Protecting Data

    SanDroid (10/19/2011)

    If those style of comments were made during the interview I am certain I would be OK... 😛 :hehe:

    Confused...

  • RE: Protecting Data

    Miles Neale (10/19/2011)


    Kevin Gill (10/19/2011)


    SanDroid (10/19/2011)


    Kevin Gill (10/19/2011)


    Just to answer one of your points, I'm not worried about rouge developers, as they're easy to spot by their colouring, and we...

  • RE: Protecting Data

    SanDroid (10/19/2011)


    Kevin Gill (10/19/2011)


    Just to answer one of your points, I'm not worried about rouge developers, as they're easy to spot by their colouring, and we just avoid employing red...

  • RE: Protecting Data

    Just to answer one of your points, I'm not worried about rouge developers, as they're easy to spot by their colouring, and we just avoid employing red people. 🙂

  • RE: That case filter

    I have to agree with the dissenters. I wasn't looking for a mistake and I too decided that it was testing an insert where it was conditional on rows earlier...

  • RE: Fun with IDENTITY - Part II

    UMG Developer (10/8/2010)


    I almost didn't notice, and was think this is exactly the same as the question from a few days ago...

    I only tend to log on and answer...

Viewing 15 posts - 16 through 30 (of 54 total)