Forum Replies Created

Viewing 15 posts - 16,996 through 17,010 (of 19,560 total)

  • RE: Multi instance Multi CPU on Standard Edition 2005

    Standard Edition will support 4 physical CPU sockets, regardless of the number of cores in each CPU.

    Do you have 8 sockets, or 8 cores?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 25, 2010 at 11:15 am

    #1125127

  • RE: Database set to Full Recovery Model, but very small Transaction Log file

    Neil Thomas (2/25/2010)

    It's supposed to have been backed up as part of a system backup (hence somebodies decision not to take SQL backups) but that hasn't happened for a while.

    I...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 25, 2010 at 11:05 am

    #1125119

  • RE: how do we caompare the table structure in 2 databases

    RedGate SQL Compare is a useful utility for this.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 25, 2010 at 11:01 am

    #1125118

  • RE: Are the posted questions getting worse?

    Alvin Ramard (2/25/2010)

    VOIP.com

    I'm paying around $15/month (includes all taxes and fees) for 300 minutes. I use less than 10% of that.

    I just had an idea that maybe I should...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 25, 2010 at 10:15 am

    #1125094

  • RE: Today's Random Word!

    crookj (2/25/2010)

    CirquedeSQLeil (2/25/2010)

    pre-planning

    As we used to say in the Military.... (6 Ps)

    P - P - P - P - P - P

    (Prior Planning Prevents Piss Poor Performance)

    Joe

    Planning - yes

    But planning...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 25, 2010 at 10:03 am

    #1125088

  • RE: Are the posted questions getting worse?

    Alvin Ramard (2/25/2010)

    Jack Corbett (2/25/2010)

    Alvin,

    My organization uses Skype to Phone from international locations. It works okay as long as all that is going on is talking. If there...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 25, 2010 at 10:01 am

    #1125087

  • RE: Today's Random Word!

    pre-planning

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 25, 2010 at 9:06 am

    #1125047

  • RE: FizzBuzz

    WayneS (2/25/2010)

    CirquedeSQLeil (2/24/2010)

    WayneS (2/24/2010)

    FYI, Gianluca's unpivot works the fastest on my system (813ms), though Lynn's is right behind (833ms) - initial runs. But, when run repeatedly (and randomly), they actually...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 25, 2010 at 8:52 am

    #1125040

  • RE: A question on Data Types

    Nice question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 25, 2010 at 8:49 am

    #1125039

  • RE: FizzBuzz

    Jeff Moden (2/24/2010)

    reidres (2/24/2010)

    OK, I have run all four of the ones that are scalable/credible contenders and I have, for 150 000 000 rows using the COUNT (ALL xxxx) method...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 24, 2010 at 11:09 pm

    #1124761

  • RE: Data Dashboards

    Thanks Steve. Now i need to check out the app and start removing data 😉

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 24, 2010 at 11:08 pm

    #1124760

  • RE: Dude, Your Fly is Open

    Thanks Tim. This was a nice reminder on accepting and owning up to a mistake. It is not a pleasant situation to need to discuss a mistake with...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 24, 2010 at 11:05 pm

    #1124758

  • RE: FizzBuzz

    WayneS (2/24/2010)

    FYI, Gianluca's unpivot works the fastest on my system (813ms), though Lynn's is right behind (833ms) - initial runs. But, when run repeatedly (and randomly), they actually flip-flop back...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 24, 2010 at 10:06 pm

    #1124748

  • RE: Using copies of prod database on development servers

    Grumbling may happen. People will adjust - even if it takes a little longer to adjust than wanted. Deadlines may get pushed, but security and quality should carry...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 24, 2010 at 3:44 pm

    #1124653

  • RE: trying to return all tables except the system talbes from a given database

    BaldingLoopMan (2/24/2010)

    Testing cycle complete. CirquedeSQLeil’s savvy solution although a little unorthodox worked perfectly. Nice work. I now have a process that uses linked server to query n number of sql...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 24, 2010 at 3:40 pm

    #1124650

Viewing 15 posts - 16,996 through 17,010 (of 19,560 total)