Forum Replies Created

Viewing 15 posts - 1,846 through 1,860 (of 7,483 total)

  • RE: Count on table with million data too slow

    GilaMonster (3/18/2015)


    Koen Verbeeck (3/18/2015)


    you can create a new non-clustered index on ID and GPSTime.

    This, assuming there aren't any other indexes which we haven't been shown

    No, better to just add...

  • RE: The Worst Comments

    ChrisM@Work (3/26/2015)


    mister.magoo (3/26/2015)


    ChrisM@Work (3/26/2015)


    Phil Parkin (3/26/2015)


    dwain.c (3/26/2015)


    Gary Varga (3/26/2015)


    dwain.c (3/25/2015)


    ...I beginning to think that when I wrote this article (based on a quotation from Jeff):

    Make it Work, Make it Fast,...

  • RE: The Worst Comments

    dwain.c (3/26/2015)


    Gary Varga (3/26/2015)


    dwain.c (3/25/2015)


    ...I beginning to think that when I wrote this article (based on a quotation from Jeff):

    Make it Work, Make it Fast, Make it Pretty[/url]

    Maybe I should...

  • RE: The Worst Comments

    Phil Parkin (3/13/2015)


    Going off on a slight tangent, what about bad error messages?

    I've just had this one in SSIS:

    Executing the query "exec ..." failed with the following error: "Package...

  • RE: Are There That Many GUIDs?

    How many of my databases have used GUIDs? A couple that I inherited did but they don't now, so none. Do I look at what my databases need...

  • RE: Are There That Many GUIDs?

    I'm feeling a bit of an idiot for responding to posts that were 5 years ago - oh, well, never mind. And thank heaven's for Paul with his insertion...

  • RE: Are There That Many GUIDs?

    Jeff Moden (10/27/2010)


    Paul White NZ (10/26/2010)


    So, does anyone know of an article that guarantees that ethernet addresses a globally unique because that's the only way such a guarantee could be...

  • RE: Are There That Many GUIDs?

    David Walker-278941 (10/12/2010)


    As for the "are there that many" question, it's interesting to use an identifier that is essentially infinite.

    Essentially infinite is way over the top. Maybe we...

  • RE: Are There That Many GUIDs?

    SanDroid (10/12/2010)


    One little known fact about the GUID generation algorithm is the user's network card MAC address is used as a base for the last group of GUID digits so...

  • RE: Efficiency

    A lot of people have suggested that there's some sort of conflict between efficiency and effectiveness, mostly suggesting that doing something ineffectively but fast is efficient. I don't agree...

  • RE: Efficiency

    skeleton567 (3/26/2015)


    Well, for you guys planning your retirement, I have one piece of advice. You need to plan on the ongoing expense of a bottle of your favorite wine...

  • RE: SQL Cop and SQLServerCentral

    Ray Herring (3/24/2015)


    Here are a couple of things to consider.

    When SQL2005 introduced VarChar(max) I encouraged Devs to adopt the new data type immediately and most did. Eventually, we decided...

  • RE: does anyone here still use database triggers?

    When used properly and well written, triggers are extremely useful; when used inappropiately they are awful; when written badly they are awful; when they are both used inappropriately and written...

  • RE: Deploy the Database First

    I'm a bit surprised that the editorial seems to suggest that separating database and app releases is something new, because in fact it's something that has been around and recognised...

  • RE: Deploy the Database First

    PHYData DBA (1/26/2015)


    Another reason why SELECT * from <any object> should never be used in application execution code.

    Nonsense. The only reason you ever need to ban SELECT * from...

Viewing 15 posts - 1,846 through 1,860 (of 7,483 total)