Forum Replies Created

Viewing 15 posts - 7,501 through 7,515 (of 9,725 total)

  • RE: Page Splitting

    Give us the exact wording of your error message.

    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 17, 2010 at 8:52 am

    #1223079

  • RE: Query takes too long to run

    Also, a row count would be nice. If you've got a wide, long table, that could take a long time no matter how well optimized your query 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 17, 2010 at 8:45 am

    #1223070

  • RE: collation issue

    I believe, in some instances, you can make changes in the GUI that T-SQL does not enable you to make. You can try using the GUI, but don't be surprised...

    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 17, 2010 at 8:43 am

    #1223066

  • RE: Merge replication and subscription configured, by can't modify subsciption tables

    It's been a while since I've played with replication, but I'll give this a shot.

    How is your replication set up? Do you have Updating Subscribers? If not, chances are 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.

    September 17, 2010 at 8:41 am

    #1223062

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

    What service pack are you running?

    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 17, 2010 at 8:28 am

    #1223045

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (9/17/2010)

    ...Of course, I'm a big nerd so I see "She-Crab" and figure it is a new Marvel superhero/villain.

    Wrong line. Dark Horse has that one. @=)

    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 17, 2010 at 8:09 am

    #1223022

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (9/17/2010)

    Brandie Tarvin (9/17/2010)

    Speaking of crab, the restaurants in Jacksonville have some of the best She-Crab soup.

    And I'm not a big fan of seafood. But, boy are these...

    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 17, 2010 at 7:43 am

    #1222997

  • RE: D: drive is full and transaction log is full

    GilaMonster (9/17/2010)

    Ninja's_RGR'us (9/17/2010)

    Talk about your catch 22... especially since 90% of the shrink question seems to happen when you're out of space in the file / drive :w00t:.

    My personal favourite...

    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 17, 2010 at 7:32 am

    #1222978

  • RE: Are the posted questions getting worse?

    Speaking of crab, the restaurants in Jacksonville have some of the best She-Crab soup.

    And I'm not a big fan of seafood. But, boy are these soups YUMMY.

    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 17, 2010 at 7:29 am

    #1222975

  • RE: D: drive is full and transaction log is full

    GilaMonster (9/17/2010)

    Brandie Tarvin (9/17/2010)

    You can't shrink other databases while the disk is full. SQL Server requires space in which to do the shrinking, in which to add markers or throw...

    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 17, 2010 at 7:21 am

    #1222962

  • RE: Are the posted questions getting worse?

    Paul White NZ (9/17/2010)

    WayneS (9/17/2010)

    He (or his puppets) are back... http://www.sqlservercentral.com/Forums/Topic987879-9-1.aspx

    That's just very sad - and disappointing too. 🙁

    What's worse is he isn't even trying to sound different.

    But, yes,...

    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 17, 2010 at 7:19 am

    #1222960

  • RE: Today's Random Word!

    Sun

    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 17, 2010 at 6:08 am

    #1222914

  • RE: Winzip use in SSIS

    WayneS (9/16/2010)

    You're sure you're running wzzip, and not winzip32?

    I was running winzip32 originally. Now I'm running wzunzip (I'm extracting files). Is that the wrong .exe?

    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 17, 2010 at 6:06 am

    #1222913

  • RE: D: drive is full and transaction log is full

    GilaMonster (9/16/2010)

    hallhome, please for now switch any user databases on that server into simple recovery model if they're not already.

    Dumb question time. Please forgive.

    If the disk is full (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.

    September 17, 2010 at 6:02 am

    #1222909

  • RE: D: drive is full and transaction log is full

    sqlbuddy123 (9/16/2010)

    1. Free up some space on D drive and see that if the DB recovers. This may include shrinking other databases to free up some space.

    Someone may have already...

    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 17, 2010 at 5:53 am

    #1222904

Viewing 15 posts - 7,501 through 7,515 (of 9,725 total)