Forum Replies Created

Viewing 15 posts - 9,226 through 9,240 (of 9,720 total)

  • RE: Domains and Schemas

    B_Boy,

    I use Erwin by Computer Associates.

    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.

    December 3, 2007 at 8:19 am

    #756504

  • RE: Domains and Schemas

    Ah. Unfortunately, I have never done a diagram on MS Visio before so I can't answer your question.

    Has anyone else used Visio for diagramming dbs?

    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.

    December 3, 2007 at 7:48 am

    #756482

  • RE: Domains and Schemas

    B_Boy,

    What software are you using for your diagram? Erwin?

    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.

    December 3, 2007 at 6:40 am

    #756449

  • RE: Domains and Schemas

    Absolutely. Well, you can use one to show the primary key & foreign key stuff. Not sure about the other constraints. But I'm pretty sure you can...

    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.

    December 3, 2007 at 6:25 am

    #756442

  • RE: Format Ints with commas?

    Markus,

    What topic did you search in BOL to find the above? I couldn't find it no matter what I tried.

    Thanks,

    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.

    December 3, 2007 at 6:08 am

    #756436

  • RE: Format Ints with commas?

    Thanks, Markus! Worked like a charm. @=)

    Is there a weblink or a BOL topic that I can search to see all the different types of format codes one can...

    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.

    December 3, 2007 at 5:33 am

    #756419

  • RE: Very high spikes in Current disk Queue Length

    The first question you should ask of everyone who has access to the server is "What has changed?". This might help you pinpoint the problem faster. I'm assuming...

    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.

    November 30, 2007 at 4:18 am

    #755877

  • RE: Finding Analysis Services in SQL 2000

    Well, gosh darnit! Now I have to go begging up to Corporate (who has outlawed new SQL 2000 installs) and see if they will give me a copy of...

    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.

    November 29, 2007 at 7:32 am

    #755427

  • RE: VARCHAR(1000) vs. VARCHAR(MAX)

    Microsoft seems to have their documentation mixed up. Here's where I got my information:

    Books Online - Index Search - pages [SQL Server], about pages

    Page Types:

    Data

    Data rows with all...

    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.

    November 29, 2007 at 7:30 am

    #755426

  • RE: Changing Career Gears

    I have to agree with Timothy. It depends on what your employer of choice is looking for.

    I originally used the cert material as a method of learning the basics...

    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.

    November 29, 2007 at 6:40 am

    #755393

  • RE: Finding Analysis Services in SQL 2000

    I just tried running through the installation of SQL Server 2000 Developer. I tried adding components to my existing install of the SQL Server. There was nothing there...

    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.

    November 29, 2007 at 6:22 am

    #755378

  • RE: Finding Analysis Services in SQL 2000

    Well, the service is definitely installed on the server, but my client tools can't seem to access it. Do I need to install AS on my desktop to get...

    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.

    November 29, 2007 at 5:09 am

    #755347

  • RE: Changing Career Gears

    You're correct there. The closest I got was when I started creating MS Access databases for various things while I worked for the records management firm. I was the...

    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.

    November 29, 2007 at 4:59 am

    #755339

  • RE: Finding Analysis Services in SQL 2000

    Markus,

    Thank you. That explains why I'm confused. I'm using the client tools on my desktop and should have gone straight to the source. @=)

    Thanks again!

    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.

    November 29, 2007 at 4:46 am

    #755328

  • RE: Finding Analysis Services in SQL 2000

    Loner,

    I'm trying to figure out if it's already installed, though. How do I do that?

    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.

    November 29, 2007 at 4:24 am

    #755319

Viewing 15 posts - 9,226 through 9,240 (of 9,720 total)