Forum Replies Created

Viewing 15 posts - 8,956 through 8,970 (of 9,715 total)

  • RE: CTE doesn't update correctly

    Thanks, Matt. I appreciate the clarification.

    Looks interesting. I'm going to have to test this one and see if it does any better or quicker than what I eventually...

    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: CTE doesn't update correctly

    DOH! Found my error. I had t2.CalMonth - 1 and should have had t2.CalMonth + 1.

    I feel sooooo stupid.

    Thanks, guys. I appreciate it. As far as...

    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: CTE doesn't update correctly

    Okay, this doesn't appear to be a CTE problem so much as it is a confusing addition problem.

    ARGH.

    I've changed this to a WHILE loop only and it's still giving me...

    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: Mystery Subscription jobs appearing

    Oh, that's a horrible thought!

    I want to be able to see these jobs and know what each one does without opening them up and finding the report ID info. ...

    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: User Defined Function Execution

    I used to think that too, but actually no. The FROM clause is the one place where the UDF doesn't execute once per row.

    Remember that a UDF...

    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: SSRS 2005 - Report Page Layout Question

    Sounds like you need to incorporate your reports in a Dashboard tool.

    I know Crystal Excelsius does something similar to what you're talking about, but it usually uses Crystal reports instead...

    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: Should the DBA be a Local Administrator?

    Andrew said:

    I think thats great if you have the time, however as most have better things to do just identify what it is you need and leave it up to...

    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: SSRS 2005 - Report Page Layout Question

    The other suggestion will not give you a vertical split. It will give you a horizontal split. There is no way, that I am aware of, of doing...

    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: Should the DBA be a Local Administrator?

    The big thing, IMHO, is whether or not your job duties require that kind of access to the server.

    Where I work, the DBA team is responsible for the "soft" server...

    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: MCA: Database

    Besides - four weeks is the fastest they can grow your pod in....

    DUDE! Who told? We had to sign a conference call NDA regarding that information....

    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 to set the title of the report

    The "view report" button is a Microsoft program thing. I haven't heard of anyone being able to change the caption on it.

    Someone let me know if you've been able...

    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: Laptop

    I ditto the Vista issue. Learning a new OS while trying to learn SQL Server is NOT a good combination.

    As far as laptops go, I've got an older Sony...

    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: SQL 2008 sneak peek exam info

    Beta exams are invite only, as I understand. However, if you get a specific Microsoft e-newsletter, you can see where they make these announcements (and that is a sort...

    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: MCA: Database

    It's not for internal Microsoft people any more. Anyone who is an employee of a Microsoft Certified Partner (not just a gold partner) can now attend the Architect program....

    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: 70-444 exam format

    I think the format is the same as 443, but since I took 447 instead, I can't be positive.

    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 - 8,956 through 8,970 (of 9,715 total)