Are the posted questions getting worse?

  • I posted a question here: http://www.sqlservercentral.com/Forums/Topic1357535-2799-1.aspx?Update=1 about automating file downloads in SQL Server. I would appreciate any help or suggestions or even just "This is How We Do It."

    Thanks, ..

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

  • Anyone feel up to helping here?: http://www.sqlservercentral.com/Forums/Topic1358758-391-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Anybody have any ideas? I can't find much myself.

  • GilaMonster (9/13/2012)


    Anyone feel up to helping here?: http://www.sqlservercentral.com/Forums/Topic1358758-391-1.aspx

    We'll see. I hope I can be of help.

    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

  • SQLRNNR (9/13/2012)


    GilaMonster (9/13/2012)


    Anyone feel up to helping here?: http://www.sqlservercentral.com/Forums/Topic1358758-391-1.aspx

    We'll see. I hope I can be of help.

    He's in over his head...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • That seems to be the case. Maybe we recommend hiring a consultant?:-D

    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

  • Do we recommend the consultant before or after someone posts "Take the database offline. Delete all the .MDF and .LDF files. Recreate only the .MDF and .LDF files that you want to keep and bring the database back online." ?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Tangently related to the post under discussion, I've found there are a lot of rookie writers who think that when you tell them "this won't work" that you are not talking about them, because obviously "this" worked for someone else, so they should be able to get away with doing "this" even though more experienced writers, agents, editors and publishing professionals are telling them that "this" doesn't work.

    For instance, we were discussing the penchant for new writers to post their work on their blog for free. And a bunch of us kept saying, "Don't do that. You're giving away your first publishing rights and a lot of houses will never buy your book if it's available elsewhere for free." But the rookie in question insisted that there were several people who got high-dollar publishing contracts for the stuff they put up on their blog. I don't remember all the examples he cited, but Julie & Julia was one of them.

    He completely missed the point that all the examples he cited were authors who never intended their blogs to become books. They were writing on a subject they felt passionate about and happened to get book offers based on that fact.

    Which goes back to the whole "Well, someone posted this advice, so it must be geniune and correct, because it worked for someone. Why should I not listen to it?" syndrome.

    How do we fix that perception? And how do we make people understand that a solution that works in one circumstance may not work in other circumstances and generally is not appropriate to universal application?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Anyone get the increasing feeling people are looking for the 'eazy button'?

    Case in point:

    "I read through those articles [on index column ordering], but I still want a formula that tells me what columns go first in an index"

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • GilaMonster (9/14/2012)


    Anyone get the increasing feeling people are looking for the 'eazy button'?

    Case in point:

    "I read through those articles [on index column ordering], but I still want a formula that tells me what columns go first in an index"

    Pff, a formula for that is easy!

    Column A should always go first in an index, possibly followed by B and C, etc...

    The number of columns in your index < the number of columns in your table

    Where A, B, C, etc... are columns that appear anywhere in your table that, when indexed, provide a performance boost.

    🙂

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • I couldn't find an answer to this guy's question: http://www.sqlservercentral.com/Forums/Topic1359181-391-1.aspx?

    I always thought that "," and "CROSS JOIN" were identical, but he found a case where they aren't. "," generates a column-binding error while "CROSS JOIN" doesn't.

    Anyone with any better answers want to chime in on it?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • Stefan Krzywicki (9/14/2012)


    GilaMonster (9/14/2012)


    Anyone get the increasing feeling people are looking for the 'eazy button'?

    Case in point:

    "I read through those articles [on index column ordering], but I still want a formula that tells me what columns go first in an index"

    Pff, a formula for that is easy!

    Column A should always go first in an index, possibly followed by B and C, etc...

    The number of columns in your index < the number of columns in your table

    Where A, B, C, etc... are columns that appear anywhere in your table that, when indexed, provide a performance boost.

    🙂

    You're doing it wrong.

    DBCC Timewarp (# of columns / (pi * # of tables) + 8 )

    The 8 is there because everyone knows there are 8 KB per page.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Brandie Tarvin (9/14/2012)


    Stefan Krzywicki (9/14/2012)


    GilaMonster (9/14/2012)


    Anyone get the increasing feeling people are looking for the 'eazy button'?

    Case in point:

    "I read through those articles [on index column ordering], but I still want a formula that tells me what columns go first in an index"

    Pff, a formula for that is easy!

    Column A should always go first in an index, possibly followed by B and C, etc...

    The number of columns in your index < the number of columns in your table

    Where A, B, C, etc... are columns that appear anywhere in your table that, when indexed, provide a performance boost.

    🙂

    You're doing it wrong.

    DBCC Timewarp (# of columns / (pi * # of tables) + 8 )

    The 8 is there because everyone knows there are 8 KB per page.

    I always thinks DBCC Timewarp is secret and I shouldn't be spreading it around on the forums.

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • Stefan Krzywicki (9/14/2012)


    Brandie Tarvin (9/14/2012)


    Stefan Krzywicki (9/14/2012)


    GilaMonster (9/14/2012)


    Anyone get the increasing feeling people are looking for the 'eazy button'?

    Case in point:

    "I read through those articles [on index column ordering], but I still want a formula that tells me what columns go first in an index"

    Pff, a formula for that is easy!

    Column A should always go first in an index, possibly followed by B and C, etc...

    The number of columns in your index < the number of columns in your table

    Where A, B, C, etc... are columns that appear anywhere in your table that, when indexed, provide a performance boost.

    🙂

    You're doing it wrong.

    DBCC Timewarp (# of columns / (pi * # of tables) + 8 )

    The 8 is there because everyone knows there are 8 KB per page.

    I always thinks DBCC Timewarp is secret and I shouldn't be spreading it around on the forums.

    Nah. It's secret now, but since it won't be secret when the year 1900 roles around again, it's okay to post details. In the past-future-imperfect tense, of course.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • GSquared (9/14/2012)


    Stefan Krzywicki (9/14/2012)


    Brandie Tarvin (9/14/2012)


    Stefan Krzywicki (9/14/2012)


    GilaMonster (9/14/2012)


    Anyone get the increasing feeling people are looking for the 'eazy button'?

    Case in point:

    "I read through those articles [on index column ordering], but I still want a formula that tells me what columns go first in an index"

    Pff, a formula for that is easy!

    Column A should always go first in an index, possibly followed by B and C, etc...

    The number of columns in your index < the number of columns in your table

    Where A, B, C, etc... are columns that appear anywhere in your table that, when indexed, provide a performance boost.

    🙂

    You're doing it wrong.

    DBCC Timewarp (# of columns / (pi * # of tables) + 8 )

    The 8 is there because everyone knows there are 8 KB per page.

    I always thinks DBCC Timewarp is secret and I shouldn't be spreading it around on the forums.

    Nah. It's secret now, but since it won't be secret when the year 1900 roles around again, it's okay to post details. In the past-future-imperfect tense, of course.

    Excellent, so from then on I will be about to have been going to done so.

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

Viewing 15 posts - 37,816 through 37,830 (of 66,738 total)

You must be logged in to reply to this topic. Login to reply