Forum Replies Created

Viewing 15 posts - 1 through 15 (of 25 total)

  • RE: SQL Server Agent Roles

    It was too easy.... thought it was a trick question :ermm:

  • RE: Taking a Sabbatical

    Sorry for jumping into this conversation late. You see, I left my job last April as the project was coming to an end, and decided that it was 'now or...

  • RE: Creating an Indexed View

    bitbucket-25253 (3/30/2011)


    CONGRATULATIONS

    Thanks!

  • RE: Creating an Indexed View

    Well, things seem to have quieted down now, so I'd like to thank all for playing and appreciate the comments, including the constructive criticism 🙂

    Sorry about the typo in the...

  • RE: Creating an Indexed View

    bitbucket-25253 (3/30/2011)


    Are these meant to stump or "accidental" - note that all the indexes have the same name as the name of the correct answers index.

    So if I...

  • RE: Creating an Indexed View

    Carlo Romagnano (3/30/2011)


    The correct answer is "None of the above"

    http://msdn.microsoft.com/en-us/library/ms188783.aspx

    Tables must be referenced by two-part names, schema.tablename, in the view definition.

    I want back my points.

    Sorry about that - I must...

  • RE: Creating an Indexed View

    dioscoredes (3/30/2011)


    As an Oracle OCP the hardest part of the exam for me is to learn the way the question setter wants the question answered. With our questioner-of-the-day...

  • RE: Creating an Indexed View

    Koen Verbeeck (3/30/2011)


    Nice question, but the answer is confusing. The first index should be a unique clustered index, but you can add more non-clustered indexes later on.

    http://msdn.microsoft.com/en-us/library/ms191432.aspx

    Sorry I wasn't more...

  • RE: Creating an Indexed View

    bitbucket-25253 (3/29/2011)


    The link to the supporting documentation did not work, at least not for me ,,, came back with 404 error.

    Sorry about that - I lost the last character during...

  • RE: Extracting Extended Properties

    Great article/ series! Makes me want to start documenting my databases! 😛 (Yea, I'm way behind on that)

    Your first image depicting the sys.extended_properties view looks different from mine. I'm running...

  • RE: Extended Properties Introduction

    ACinKC (3/17/2011)


    I created an Excel/VBA solution for my current gig that read in the metadata for the tables and columns into a workbook (one worksheet per table) [...] It's a...

  • RE: LOB Data

    Well, that's one of the plusses to getting in to the office late... the radio buttons were already changed to check boxes by the time I answered the QotD. 😛

    As...

  • RE: Script all data of a table

    I think I'm the only rider on the small schoolbus for this one... but I'm missing something. Can someone give some examples of when you would need to use this...

  • RE: Point-in-time restore

    SanDroidTrue Story: The exam questions are filled with contradictions and odd errors also. They are peer reviewed (no really) a lot like these questions are. We would sometimes agree...

  • RE: Point-in-time restore

    Yes, it's very frustrating trying to study for the exams when the study guides are wrought with errors and contradictions. I wish those things were peer reviewed. However, these SSC...

Viewing 15 posts - 1 through 15 (of 25 total)