Forum Replies Created

Viewing 15 posts - 16,156 through 16,170 (of 22,211 total)

  • RE: Log File is MASSIVE

    GilaMonster (11/25/2009)


    Atul DBA (11/25/2009)


    As your log file is very huge, and it is required to Truncate the log file for proper utilization of disk space, you need to stop the...

  • RE: Log File is MASSIVE

    roelofsleroux (11/25/2009)


    Gila the reason we use mirrors is because this is for a stock exchange trading application.

    If the database fails for some reason, the mirror kick in. If there is...

  • RE: Problem with UNION ALL

    Nope. It's going to execute them one after the other and combine the data.

  • RE: Hugh Performance Gap Between SELECT And INSERT

    Without looking at the efficiency of the query, it's pretty easy to explain why you would see a difference between these two. A SELECT statement just pulls the data. When...

  • RE: Index on Table with 2 Columns Millions of Rows

    However, once you have a set based process (and yes, please do this first), yes, usually when doing large scale data loads I've found that dropping the index and recreating...

  • RE: Where do I start?????

    To a degree you're going to get what you pay for. You can bounce around the internet and you're going to find fantastic articles and blog posts, but they're not...

  • RE: Rant of the Day

    I wasn't aware that using the correct data type for a given value was "old fashioned"... well, OK, with all the horrific tables coming out of these ORM tools, maybe...

  • RE: Are the posted questions getting worse?

    Bru Medishetty (11/24/2009)


    john.arnott (11/24/2009)


    Despite the freewheeling atmosphere, you should also be aware that some of the top practitioners of MS-SQL, including several honored by MS as "MVP"s hang out...

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (11/24/2009)


    Bob Hovious 24601 (11/24/2009)


    Welcome to The Thread, Les!! 😀

    In order to avoid redundancy and repetition and redundancy, we have established an informal rule that newcomers first...

  • RE: Are the posted questions getting worse?

    Bob Hovious 24601 (11/24/2009)


    I just took the liberty of calling ProActive and asked directly how Barry was doing. Although they obviously couldn't share details, it appears that he...

  • RE: Are the posted questions getting worse?

    Bob Hovious 24601 (11/24/2009)


    I sent Barry a message through LinkedIn last week asking how he was doing. Never got a reply. I haven't seen any...

  • RE: Are the posted questions getting worse?

    john.arnott (11/23/2009)


    I'd always heard that Irish Coffee was the perfect food as it comprises all of the major food groups:

    Alcohol

    Sugar

    Caffeine

    I can't help myself

    Where's the beef?

  • RE: query plan vs JOIN

    GilaMonster (11/23/2009)


    Grant Fritchey (11/23/2009)


    Yep. Gail nailed it (shocking I'm sure).

    Just finished writing a blog post on 'optimal' join types. Virtually a copy-paste from blog to forum.

    Excellent. I'm still catching up...

  • RE: query plan vs JOIN

    Yep. Gail nailed it (shocking I'm sure).

    With absolutely nothing to differentiate them, the engine is going to pick one... it has to. But you never know, there might be a...

  • RE: Are the posted questions getting worse?

    Alvin Ramard (11/23/2009)


    Grant Fritchey (11/23/2009)


    I had a decent rib eye at a steak house in Gettysburg on Friday after a 10+ mile hike with the Scouts covering about 2/3 of...

Viewing 15 posts - 16,156 through 16,170 (of 22,211 total)