Forum Replies Created

Viewing 15 posts - 17,881 through 17,895 (of 19,560 total)

  • RE: Fast normalization of a denormalized data source, using surrogate IDs

    Thanks for the article. Nice idea and well written.

    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

    January 25, 2010 at 4:00 pm

    #1108441

  • RE: Are the posted questions getting worse?

    jcrawf02 (1/25/2010)

    CirquedeSQLeil (1/25/2010)

    jcrawf02 (1/25/2010)

    So since cloud computing is the answer, do you (anyone, not just Gus) agree with this statement?

    Clouds push complexity to the background and allow users to focus...

    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

    January 25, 2010 at 3:42 pm

    #1108437

  • RE: Declarative Data Integrity

    Thanks bitbucket for providing yet another QoTD.

    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

    January 25, 2010 at 3:40 pm

    #1108436

  • RE: Are the posted questions getting worse?

    jcrawf02 (1/25/2010)

    So since cloud computing is the answer, do you (anyone, not just Gus) agree with this statement?

    Clouds push complexity to the background and allow users to focus on what...

    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

    January 25, 2010 at 3:31 pm

    #1108433

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (1/25/2010)

    Hello...

    Hello...

    Is this thing on?

    Nope. Try the turbo button.

    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

    January 25, 2010 at 3:26 pm

    #1108430

  • RE: Tempdb is full

    Sourav-657741 (1/25/2010)

    The weekly update stats job was running.

    i would keep looking at it. I can't imagine a weekly update stats job bloating your database like that all by itself....

    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

    January 25, 2010 at 3:11 pm

    #1108420

  • RE: Where are you?

    crookj (1/25/2010)

    CirquedeSQLeil (1/23/2010)

    D.Oc (1/23/2010)

    CirquedeSQLeil (1/23/2010)

    Jeff Moden (1/23/2010)

    Detroit. We have Lions here, too, but they have no teeth. 😉

    There's a lot more than just teeth that your lions don't have...

    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

    January 25, 2010 at 3:08 pm

    #1108419

  • RE: Are the posted questions getting worse?

    for all the threadheads - some may have noticed already, I have created a twitter account (sqlrnnr). I will probably write a blog post about the reasons why real...

    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

    January 25, 2010 at 1:33 pm

    #1108371

  • RE: Are the posted questions getting worse?

    GilaMonster (1/25/2010)

    Think I've found the crystal ball... Doesn't seem to be showing much though.

    Thanks Gail - now that is really useful. 😀

    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

    January 25, 2010 at 1:31 pm

    #1108369

  • RE: We'll go no more a' tibbling

    For what it's worth, I don't use Hungarian notation - unless in OO languages (do it there since it seems to be a common practice). I prefer to keep...

    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

    January 25, 2010 at 1:30 pm

    #1108368

  • RE: What is StreamInsight and why does it matter?

    Thanks for the article discussing this product from MS. PriceTag is hefty - and to some would only be pocketchange. Difficult price to manage for some. Then...

    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

    January 25, 2010 at 1:20 pm

    #1108364

  • RE: temp database

    Likely causes for increased size in your tempdb are:

    Poorly written SQL that uses tempdb heavily. Transaction is probably still ongoing.

    Index rebuilds

    The most likely cause is the Poorly written 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

    January 25, 2010 at 1:16 pm

    #1108360

  • RE: Urgent development question

    GilaMonster (1/25/2010)

    Greg Edwards-268690 (1/25/2010)

    Just a thought...

    If this is development, you may want to review the design.

    Absolutely. Comma-delimited lists in a column are a violation of 1st Normal Form and...

    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

    January 25, 2010 at 12:47 pm

    #1108340

  • RE: Poor performance while using Union/Intersect on bulk data

    You're welcome. Glad to be of assistance.

    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

    January 25, 2010 at 10:54 am

    #1108289

  • RE: implementing double take

    Here is a nice resource for your questions

    http://www.doubletake.com/ENGLISH/RESOURCES/Pages/default.aspx

    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

    January 25, 2010 at 10:32 am

    #1108279

Viewing 15 posts - 17,881 through 17,895 (of 19,560 total)