Forum Replies Created

Viewing 15 posts - 7,231 through 7,245 (of 9,715 total)

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (10/13/2010)


    I duuno how ,pls any1 explane

    There is just something I always find curious about posts like these. If English isn't the OP's first language,...

    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.

  • RE: Are the posted questions getting worse?

    Grant Fritchey (10/13/2010)


    I only agreed to write the book so I could say I was right about everything.

    Grant, Dude!

    I didn't know you were a science fiction author. @=)

    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.

  • RE: Subquery returned more than 1 value.

    CELKO (10/13/2010)


    Sahasam (10/12/2010)


    Thanks Craig. i am trying to debug into this code from long time.But i am unable to figure it out.

    You need to stop programming until you can 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.

  • RE: Are the posted questions getting worse?

    Alvin Ramard (10/13/2010)


    Celko strikes again.

    http://www.sqlservercentral.com/Forums/FindPost1003748.aspx

    Ticks me off that he tells the poor OP to stop programming when the OP clearly, in one line right above Celko's response, indicates that this...

    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.

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

    liewsb (10/13/2010)


    After shrinking, the file size is 15,768,960KB. The following is the output obtained:

    DbId FileId CurrentSize MinimumSize UsedPages EstimatedPages

    ------ ----------- -----------...

    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.

  • RE: Are the posted questions getting worse?

    Sorry, Jason. Call for sponsors is closed.

    However, on future SQL Saturday events, just click the sponsors page and 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.

  • RE: CPU from 1% to 100% for 8sec query on Prod. server only

    Oh, and before I forget... Have the stats on the table been updated at all since inception?

    And just how long have all your services been running?

    I don't recommend restarting...

    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.

  • RE: CPU from 1% to 100% for 8sec query on Prod. server only

    Is the query forcing recompiles? Or forcing the use of a specific execution plan each time (maybe the wrong execution plan)?

    This could still be a hardware or network issue. How...

    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.

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (10/12/2010)


    Brandie Tarvin (10/12/2010)


    CirquedeSQLeil (10/12/2010)


    GilaMonster (10/12/2010)


    3) Stabbing your team members in the back (figuratively) is not a good way of advancing your career. It doesn't take long for people 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.

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (10/12/2010)


    GilaMonster (10/12/2010)


    3) Stabbing your team members in the back (figuratively) is not a good way of advancing your career. It doesn't take long for people to figure out what's...

    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.

  • RE: Query tuning - avoid Case statement on this query

    Kit G (10/12/2010)


    RBF?

    You missed his earlier reference to it: "Really Bl00dy Fast"

    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.

  • RE: Are the posted questions getting worse?

    Another .sig-worthy quote.

    Chris Morris-439714 (10/12/2010)


    Never mind what the book says, what happens when you use it in anger against 75 million rows?

    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.

  • RE: Are the posted questions getting worse?

    Brandie holds out virtual chocolate-covered biltong. "I hear it makes everything better."

    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.

  • RE: Query tuning - avoid Case statement on this query

    Wait a sec... Read that page carefully.

    Brad states:

    Non-sargable search arguments in the WHERE clause, such as "IS NULL", "<>", "!=", "!>", "!<", "NOT", "NOT EXISTS", "NOT IN", "NOT LIKE", 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.

  • RE: Query tuning - avoid Case statement on this query

    Brad's article is written in 2007. So I'd think he'd have known about any SQL 2005 stuff.

    He does add that covering indexes might explain a seek instead of a...

    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.

Viewing 15 posts - 7,231 through 7,245 (of 9,715 total)