Forum Replies Created

Viewing 15 posts - 7,291 through 7,305 (of 9,720 total)

  • RE: Today's Random Word!

    mbricker-600840 (10/6/2010)

    Tom.Thomson (10/6/2010)

    Brandie Tarvin (10/6/2010)

    CirquedeSQLeil (10/6/2010)

    Wow, SSC is all about milestones this week.

    This thread is about to break 3000 posts too.

    Post for the sake of bumping the post #. @=)

    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.

    October 6, 2010 at 12:28 pm

    #1232941

  • RE: Are the posted questions getting worse?

    Lately I have found that more posters actually have a problem with their expected result sets because they forgot (or didn't know) what they should be expecting. That it's not...

    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 6, 2010 at 12:27 pm

    #1232939

  • RE: Query not returning the right amount of records.

    kbnyny (10/6/2010)

    I have a query that is not pull all the data that it should be pulling. It should return 170 records. Before i added on Table SOP30300 I was...

    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 6, 2010 at 12:26 pm

    #1232938

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (10/6/2010)

    The main reason I want to shove him off onto his own instance of his own database on his own server is that we already have performance problems...

    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 6, 2010 at 11:53 am

    #1232896

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (10/6/2010)

    Brandie Tarvin (10/6/2010)

    Stefan Krzywicki (10/6/2010)

    Wow, loading data into Access from SQL Server through SSIS is a Royal PITA.

    Really? I haven't had any problems with it. What's your issue?

    EDIT:...

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

    #1232862

  • RE: Today's Random Word!

    CirquedeSQLeil (10/6/2010)

    Wow, SSC is all about milestones this week.

    This thread is about to break 3000 posts too.

    Post for the sake of bumping the post #. @=)

    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 6, 2010 at 11:14 am

    #1232843

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (10/6/2010)

    Wow, loading data into Access from SQL Server through SSIS is a Royal PITA.

    Really? I haven't had any problems with it. What's your issue?

    EDIT: Sorry. Thought you were...

    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 6, 2010 at 11:10 am

    #1232840

  • RE: Are the posted questions getting worse?

    Chris Morris-439714 (10/6/2010)

    Somehow, for reasons long ago forgotten, Post Count has been set up as the unusual datatype NUMERIC(6,0).

    Numeric instead of Integar? Bad cowboy! Doesn't he know that extra byte...

    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 6, 2010 at 8:54 am

    #1232655

  • RE: Today's Random Word!

    Ray K (10/6/2010)

    crookj (10/6/2010)

    Chris Morris-439714 (10/5/2010)

    Giant carnivorous mice

    Vorpal Bunny - Quest for the Holy Grail.

    Holy Hand Grenade of Antioch

    ...And thou shalt count to three. Not to four, which is greater...

    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 6, 2010 at 8:51 am

    #1232646

  • RE: Database Goes Missing

    Greg Edwards-268690 (10/6/2010)

    I'd also check security for who has access.

    Best piece of advice on this thread yet.

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

    #1232465

  • RE: How to truncate log file in SQL Server 2005

    GilaMonster (10/6/2010)

    Brandie Tarvin (10/6/2010)

    I do have to ask this. You have full database backups scheduled, but it's not backing up the MDF file?

    How do you know it's not backing...

    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 6, 2010 at 5:35 am

    #1232394

  • RE: How to truncate log file in SQL Server 2005

    liewsb (10/6/2010)

    We have a schedule job to do a full backup on the database, but not these two file, i.e. MDF and LDF files. How to create a transaction log...

    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 6, 2010 at 5:18 am

    #1232381

  • RE: How to truncate log file in SQL Server 2005

    Definitely follow Gail's advice. She's rescued more databases than the Humane Society has rescued pets.

    FYI: If you're not doing transaction log backups and you're in FULL or Bulk-Logged recovery model,...

    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 6, 2010 at 5:16 am

    #1232380

  • RE: Are the posted questions getting worse?

    GilaMonster (10/6/2010)

    Does anyone think my response here was over-the-top? http://www.sqlservercentral.com/Forums/FindPost999124.aspx

    No. I find it professional and well-reasoned. It is the correct and necessary response to the question.

    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 6, 2010 at 5:13 am

    #1232377

  • RE: Are the posted questions getting worse?

    In regards to another post / thread:

    Here's the latest SQL Server version list, including 2k8 R2.

    And for those who don't like clicky links: http://www.sqlteam.com/article/sql-server-versions

    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 6, 2010 at 5:03 am

    #1232368

Viewing 15 posts - 7,291 through 7,305 (of 9,720 total)