Forum Replies Created

Viewing 15 posts - 9,331 through 9,345 (of 9,715 total)

  • RE: How to get Resultset in the order of Items given in IN clause

    Andras is correct. You can't order by the order in an IN clause. You can order by column ordinal positions, but since these are row results, that doesn't...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Business Intelligence Developer Certification

    Ben,

    I'm not trying to flame, but your "definition" bugs me, so I find myself needing to respond.

    Have you actually read Microsoft's NDA and their EULA regarding their certification tests? ...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Business Intelligence Developer Certification

    Not according to Microsoft.

    And not according to the thousands of teachers who at Elementary, Junior High, Senior High, College and University institutions across the United States. Using a...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Editing a post

    WHHHAAAAAAAAAAAAAAATTTTT? You have higher priority items on your list... like keeping the forums running, publishing articles and protecting the site from DOS attacks and such???? Say it ain't...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Microsoft BI Certifications or Why SQL is a 4-Letter Word

    Really? Because I heard from someone else that they can if, and only if, they are pointing out errors on the exam. But I have no direct experience...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Microsoft BI Certifications or Why SQL is a 4-Letter Word

    Adam,

    Theoretically, you might be right, but in the past I've actually seen an exam where they gave me an example of a database in Simple recovery mode and started off...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Microsoft BI Certifications or Why SQL is a 4-Letter Word

    Becase as long as you pass, you pass, regardless of the exam version. @=)

    And if you make a note on the Betas (or an exam) about a problem being wrong...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Microsoft BI Certifications or Why SQL is a 4-Letter Word

    Ditto to Adam's post.

    When I was still working retail / customer service, I created Access databases to track my supply orders and other items. I didn't need to do...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: How insert opetation will work in Database Snapshot?

    Honestly, I'm not sure if the snapshot "empties" or is deleted completely once you restore. The best way for you to find out the answer, though, is to test...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Time Zone issue

    Oddly enough, when I was searching yesterday, I could not find the "Forum Settings" Box no matter where I searched on my account or in Control Panel. Yet, today,...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Business Intelligence Developer Certification

    V,

    I appreciate the link to Amazon and Microsoft (I didn't know about those books), but...

    You'd better amend your post. TestKing, Pass4Sure and BrainDump are all brain dump sites and...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Business Intelligence Developer Certification

    There are no books yet for these exams (I've been looking), but this article was recently published on the site. It might help you out:

    http://www.sqlservercentral.com/articles/Business+Intelligence/61369/

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: I Need Full Info of MCTS(70-431) exam,Please give me Tutorial and Hints.

    Richard,

    Are you aiming too high? I don't know. It depends on your retention level and your ability to learn. If you learn quick and retain for a...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Large Table Setup

    Wow. 500+ million records? That's a LARGE table.

    I can tell you from experience that the more columns you have in a table that size, the harder it is...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: How insert opetation will work in Database Snapshot?

    You can't insert into a snapshot. All the snapshot does is "tag" the database at the time the snapshot is taken. Then, everytime something in the database changes,...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 15 posts - 9,331 through 9,345 (of 9,715 total)