Forum Replies Created

Viewing 15 posts - 496 through 510 (of 673 total)

  • RE: SSIS Properties

    Tom.Thomson (2/2/2011)


    One can only wonder whether the authors are doing their best to confuse!

    The MSDN/BOL/Etc.. says:

    "However, you cannot use the /ConfigFile option to replace configured values that you also specified...

  • RE: SQLCLR

    OCTom (2/1/2011)


    I thought checking BOL was cheating just like running code first... :hehe:

    Many people think that... 😉

    I was told checking your answer is called being able to show your work....

  • RE: SQLCLR

    bitbucket-25253 (2/1/2011)


    Tom.Thomson (2/1/2011)


    Andrew Watson-478275 (2/1/2011)


    Koen (da-zero) (2/1/2011)


    A bit easy though, as you can guess the answer just by looking at the names of the DMV. 🙂

    I'm obviously too suspicious. ...

  • RE: Data Driven Subscription

    Some of you might find this interesting.

    When you search the local SQL Help file for "SSRS null data provider" the results point to online documentation only.

    Another instance where Google can...

  • RE: Data Driven Subscription

    Nice easy question. This was not always available in the early re-release SSRS. Being able to preload a large report into Cache is a big deal.

  • RE: sys.objects

    cengland0 (1/25/2011)


    SanDroid (1/25/2011)


    Nice question. Obviously several people might learn something since "System base table" answer was almost as popular as the correct answer. 😎

    Yup, that's the one I selected...

  • RE: sys.objects

    Nice question. Obviously several people might learn something since "System base table" answer was almost as popular as the correct answer. 😎

  • RE: Corruption Detection

    Tom.Thomson (1/24/2011)


    Another potential issue is physical deterioration of the media.

    Tom, this is a wonderfull point. I had forgotten about all the times restore from tape backup...

  • RE: Corruption Detection

    GilaMonster (1/24/2011)


    Steve Jones - SSC Editor (1/24/2011)


    You calculate a checksum across the page. When you read the page, you recalculate the checksum. If it doesn't match the value stored in...

  • RE: Corruption Detection

    Steve Jones - SSC Editor (1/24/2011)


    The disk might receive "1234567" from SQL Server and for some reason, as it writes the bytes on disk, it writes 1234566". The...

  • RE: Corruption Detection

    Steve Jones - SSC Editor (1/24/2011)


    Corruption usually occurs from some hardware issue. A voltage fluctuation, a bad driver, some anomaly that cases the bits written to disk to be incorrect.

    I...

  • RE: Corruption Detection

    GilaMonster (1/24/2011)


    SanDroid (1/24/2011)


    What caused this to happen? How did you discover and recover from it?

    Errr...??? I'm saying how it behaves, not describing a situation I encountered. I can manufacture an...

  • RE: Corruption Detection

    Nice easy question for a nice easy number.

  • RE: Corruption Detection

    GilaMonster (1/24/2011)


    Torn page wouldn't notice that 10 bytes within the page were overwritten (unless those 10 included one set of torn page bits), checksum will.

    This sounds like an interesting...

  • RE: Restore

    Steve Jones - SSC Editor (1/20/2011)


    SanDroid (1/20/2011)


    That is understood an not relevant in the least to my point.

    The question was the types of restore supported, not the restore commands supported....

Viewing 15 posts - 496 through 510 (of 673 total)