Forum Replies Created

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

  • RE: Log File is MASSIVE

    roelofsleroux (11/25/2009)

    Hahaha!

    Gila you sound like Doomsday Prophet. This is South Africa. The only natural disaster we know of so far is a flood 21 years ago that destroyed a town....

    November 25, 2009 at 7:57 am

    #1084045

  • RE: Are the posted questions getting worse?

    Alvin Ramard (11/25/2009)

    Roy Ernest (11/25/2009)

    I sometimes feel that the thread rules us... We dont rule the thread anymore. It has evolved itself into a controlling being

    To the new folks in...

    November 25, 2009 at 7:41 am

    #1084020

  • 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...

    November 25, 2009 at 7:38 am

    #1084015

  • 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...

    November 25, 2009 at 7:36 am

    #1084011

  • RE: Problem with UNION ALL

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

    November 25, 2009 at 7:33 am

    #1084007

  • 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...

    November 25, 2009 at 7:31 am

    #1084001

  • 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...

    November 25, 2009 at 7:28 am

    #1083998

  • 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...

    November 25, 2009 at 7:14 am

    #1083989

  • 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...

    November 25, 2009 at 6:48 am

    #1083961

  • 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...

    November 25, 2009 at 6:22 am

    #1083933

  • 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...

    November 25, 2009 at 6:21 am

    #1083932

  • 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...

    November 24, 2009 at 10:45 am

    #1083587

  • 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...

    November 24, 2009 at 8:51 am

    #1083509

  • 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?

    November 23, 2009 at 11:34 am

    #1083087

  • 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...

    November 23, 2009 at 9:19 am

    #1083005

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