Forum Replies Created

Viewing 15 posts - 7,441 through 7,455 (of 9,725 total)

  • RE: Today's Random Word!

    re-freakin'-fraction. @=)

    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.

    September 22, 2010 at 5:41 am

    #1225473

  • RE: How Do I resolve SSMS 'is busy" issue

    Okay, I'm going to ask again. What service pack (and version) of SQL Server are you running?

    EDIT: And how much RAM are you running on the machine you're working from?...

    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.

    September 22, 2010 at 5:37 am

    #1225471

  • RE: Problem with Linked Server to Excel

    jspatz (9/21/2010)

    I might be confused but I was figuring since I was using 64 bit sql server on a 64 bit os, that driver had to be the 64 bit...

    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.

    September 22, 2010 at 5:36 am

    #1225470

  • RE: Problem with Linked Server to Excel

    fenwicc (9/21/2010)

    check your cluster configuration. The security on the file share needs to be set up using the cluster administration tool.

    If this is NOT what you checked when you...

    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.

    September 22, 2010 at 5:35 am

    #1225469

  • RE: Best practices are really the best (fastest) solution?

    Query tuning depends a lot on your database structure and the types of queries you're using. If you want generic advice, check out Books Online and pretty much every book...

    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.

    September 21, 2010 at 10:25 am

    #1225024

  • RE: How to move tables, indexes & Logs from one disk to another disk drive

    CirquedeSQLeil (9/21/2010)

    d.qureshi (9/21/2010)

    Hello Brandie,

    Thank you for your kind advice.

    So there is no way to move a table and its data from one physical disk location to different physical disk location...

    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.

    September 21, 2010 at 10:18 am

    #1225015

  • RE: Are the posted questions getting worse?

    I've found Excel only causes a few minor issues and as long as you know how to work around them, it's not that big of a deal.

    It's figuring out 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.

    September 21, 2010 at 8:20 am

    #1224869

  • RE: sql 2005 (32bit) on Windows Server 2003 (64bit) AWE enable?

    george sibbald (9/21/2010)

    @brandie

    sorry, was not ignoring you, just taking a different viewpoint.

    Different viewpoints are good. Even moreso when the documentation proves 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.

    September 21, 2010 at 8:08 am

    #1224846

  • RE: GetDate() not working

    I actually have had errors in the past on this. Even posted a request for help on this forum about it at some point, but no one was able 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.

    September 21, 2010 at 7:44 am

    #1224818

  • RE: Are the posted questions getting worse?

    jcrawf02 (9/21/2010)

    Finally! The perfect database tool! :w00t:

    http://spreadsheets.about.com/od/datamanagementinexcel/ss/080608_database.htm

    If they find your body stuff into a Microsoft Office box, they'll know I was the guilty party...

    @THWACK!

    😛

    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.

    September 21, 2010 at 6:56 am

    #1224758

  • RE: logshipping not working properly

    Okay, how many different backup jobs (and what types) do you have going on with the failing database?

    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.

    September 21, 2010 at 6:18 am

    #1224727

  • RE: Best practices are really the best (fastest) solution?

    Jeff Moden (9/20/2010)

    The second most important part of optimizing is to know how long [font="Arial Black"]each part [/font]took using the old way and how long it takes using the new...

    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.

    September 21, 2010 at 6:14 am

    #1224721

  • RE: Today's Random Word!

    Scope change

    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.

    September 21, 2010 at 6:11 am

    #1224720

  • RE: FTP

    Have you tested the email without the attachment? Used DBMail manually in SSMS?

    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.

    September 21, 2010 at 6:09 am

    #1224719

  • RE: Problem with Linked Server to Excel

    Is the Linked Server in the SSMS GUI? Check the security tab on it and let me know what the set up 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.

    September 21, 2010 at 6:08 am

    #1224717

Viewing 15 posts - 7,441 through 7,455 (of 9,725 total)