Forum Replies Created

Viewing 15 posts - 7,096 through 7,110 (of 9,715 total)

  • RE: tempdb woes - space not freeing up during SP

    I take it you weren't running into issues before you started processing on a batch level?

    What else is running when you're doing this?

    TempDB holds the result sets of your...

    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.

    October 25, 2010 at 10:16 am

    #1241718

  • RE: GeoCode with Bing Using an SP/Function

    So far as I know, MS Bing is not native to SQL Server, so does not have any procs designed for it. If there's an add-on or extended proc 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.

    October 25, 2010 at 10:09 am

    #1241711

  • RE: insert if not exists, if it does insert into another table

    I don't even understand the poll.

    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.

    October 25, 2010 at 10:07 am

    #1241706

  • RE: HELP IN MODIFYING STORED PROCS

    Also look up the following in Books Online:

    ALTER PROCEDURE

    CREATE PROCEDURE

    DROP PROCEDURE

    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.

    October 25, 2010 at 10:06 am

    #1241704

  • RE: Today's Random Word!

    It's not a prestige thing for me. It's a "be nice to have a door to shut when people are having an impromptu conference right outside your workspace (at 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.

    October 25, 2010 at 10:04 am

    #1241703

  • RE: SQL Server 2008 (non-R2 version) question

    Thanks, Gail. I just wasn't sure if R2 was being treated as a separate version or as the "upgrade" to the regular 2k8.

    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.

    October 25, 2010 at 9:58 am

    #1241698

  • RE: Read glolal settings of server vs Database

    Datetime settings usually default to what is set in your server / database collations. That's what you need to check.

    Not quite sure how to check it off the top 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.

    October 25, 2010 at 9:34 am

    #1241687

  • RE: Team Foundation Server

    Do you have a workspace mapped to your local drive?

    If not, you need to define your workspace, map it to your local drive. If you already have a folder where...

    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.

    October 25, 2010 at 9:32 am

    #1241683

  • RE: BULK INSERT not working

    Chances are the comma is what's making the insert not work properly. You need to either regenerate your csv file with different delimiters, regenerated it with text qualifiers (so 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.

    October 25, 2010 at 9:27 am

    #1241676

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (10/25/2010)

    If the [fish] market is closed, just steal it from a bear.

    I seen that movie. It did not end well.

    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.

    October 25, 2010 at 9:03 am

    #1241647

  • RE: Today's Random Word!

    Forget about all that. He has an office.

    Oooohhhh.

    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.

    October 25, 2010 at 7:32 am

    #1241567

  • RE: Are the posted questions getting worse?

    Grant Fritchey (10/25/2010)

    george sibbald (10/24/2010)

    I'm interested, why use SSIS for backup plans? That does seem an unnecessary extra layer to me. I presume you mean outside of the maintenance plans....

    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.

    October 25, 2010 at 5:53 am

    #1241516

  • RE: SSIS Insert Violation of PRIMARY KEY constraint during insert on SSIS

    You're very welcome. We're glad you figured it out.

    Thanks for posting your solution. That will help other people in the future.

    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.

    October 25, 2010 at 5:34 am

    #1241497

  • RE: Today's Random Word!

    biscuit

    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.

    October 25, 2010 at 5:33 am

    #1241495

  • RE: "Sysadmin required" - A question

    George,

    Apply patches is a good one. I forgot about that. If you think of anything more, please let me know.

    I've got SQL Configuration and Surface Area Configuration down, but...

    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.

    October 25, 2010 at 5:16 am

    #1241492

Viewing 15 posts - 7,096 through 7,110 (of 9,715 total)