Post reply

Are the posted questions getting worse?

  • September 26, 2011 at 1:52 pm

    #1386776

    Jack Corbett (9/26/2011)

    So where is everybody? No messages over the weekend and only 2 today?

    I know the Summit isn't for a few more weeks so that can't be the reason. SQLRally Nordic isn't going on now is it?

    Aw, man! You woke the crickets.

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

  • September 26, 2011 at 1:53 pm

    #1386780

    I spent the weekend as a 'lost weekend'. My hydration is still recovering. :doze:

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

  • September 26, 2011 at 2:09 pm

    #1386791

    Stefan Krzywicki (9/26/2011)

    Jack Corbett (9/26/2011)

    So where is everybody? No messages over the weekend and only 2 today?

    I know the Summit isn't for a few more weeks so that can't be the reason. SQLRally Nordic isn't going on now is it?

    Aw, man! You woke the crickets.

    Sorry. The Thread keeps me entertained when I wait on a process to finish at the office. Plus, when there is no activity I worry about the other Threadizens.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • September 26, 2011 at 2:10 pm

    #1386793

    Evil Kraig F (9/26/2011)

    I spent the weekend as a 'lost weekend'. My hydration is still recovering. :doze:

    Since I haven't done those activities in many years I can't relate anymore. I spent most of the weekend working because a client had major problems on Friday and I was trying to help them solve them. Of course they were off doing their own thing as well, so much of what I researched and learned was wasted on them, but valuable to me.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • September 26, 2011 at 2:15 pm

    #1386796

    Spent the weekend mostly doing misc chores and family stuff. Replaced a barn light, patched some cement, buried a irrigation hose, lots of work.

    And unwired for the most part. Did spend a couple hours Sun am working on my talk for SQL Inspire

  • September 26, 2011 at 2:25 pm

    #1386807

    /soapbox on

    Boy I must be on of the few conservatives on here...the amazon article was thought provoking but I find the author's stance does not align with my own. By his line of thought companies achieve better results when economic decisions are guilt-driven instead of by self-interest. There is a lot of guilt laden verbiage in that article that demonstrates it is more shock value than factual.

    …boxes reach me so fast and the prices are so low. And what the story revealed about Amazon could be said of the country, too: that on the road to high and glorious things, it somehow let go of decency . (Oh, the guilt)

    … witnessing a fraying of the bonds of empathy, decency, common purpose. It is becoming a country in which people more than disagree. They fail to see each other. (Oh, the guilt)

    …when a company like Amazon, with such resources to its name, treats vulnerable people so badly just because it can. (Oh, the guilt)

    …companies like Amazon operate as though it never it occurred to them that it could have been them crawling through the aisles. (Oh, the guilt)

    …What is creeping into the culture is simple dehumanization, a failure to imagine the lives others lead. (Oh, the guilt)

    …decency, that great American virtue, falls away. (Oh, the guilt)

    My own feeling is that the greatest American virtue is the enlightened self-interest (accommodated by free & open markets and the rule of law) that deliver the best products and services at the lowest prices.

    …boxes reaching me so fast and prices that are so low

    is a GOOD THING!!

    It is our resulting prosperity that permits us the luxury of having people, like the author, who can make a livelihood out of worrying the "frayed bonds of decency".

    /soapbox off

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • September 26, 2011 at 2:33 pm

    #1386815

    For those who are interested, SQL Server MVP Deep Dives 2 is now available for pre-order and MEAP (early access to some chapters) and will be launched during PASS Summit.

    http://www.manning.com/delaney/

    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

  • September 26, 2011 at 3:08 pm

    #1386838

    euhm did you know the SQLEngine now performs checkpointing by database ? ( apparently ever since SQL2005 )

    Which db would you need to checkpoint (flush) for the sqlserver errorlog to be able to cycle ?

    master only or would it need all db to be flushed ?

    Once more a day I learned something new about the turf I thrive on :w00t:

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • September 26, 2011 at 3:12 pm

    #1386843

    ALZDBA (9/26/2011)

    Which db would you need to checkpoint (flush) for the sqlserver errorlog to be able to cycle ?

    master only or would it need all db to be flushed ?

    The SQL error log has nothing to do with checkpoints. It's not even stored in a database. (for good reason, SQL needs to write to the error log before it starts any of the databases up.)

    To cycle the error log

    EXEC sp_cycle_errorlog

    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

  • September 26, 2011 at 6:47 pm

    #1386890

    Sean Lange (9/26/2011)

    /soapbox on

    Boy I must be on of the few conservatives on here...the amazon article was thought provoking but I find the author's stance does not align with my own. By his line of thought companies achieve better results when economic decisions are guilt-driven instead of by self-interest. There is a lot of guilt laden verbiage in that article that demonstrates it is more shock value than factual.

    …boxes reach me so fast and the prices are so low. And what the story revealed about Amazon could be said of the country, too: that on the road to high and glorious things, it somehow let go of decency . (Oh, the guilt)

    … witnessing a fraying of the bonds of empathy, decency, common purpose. It is becoming a country in which people more than disagree. They fail to see each other. (Oh, the guilt)

    …when a company like Amazon, with such resources to its name, treats vulnerable people so badly just because it can. (Oh, the guilt)

    …companies like Amazon operate as though it never it occurred to them that it could have been them crawling through the aisles. (Oh, the guilt)

    …What is creeping into the culture is simple dehumanization, a failure to imagine the lives others lead. (Oh, the guilt)

    …decency, that great American virtue, falls away. (Oh, the guilt)

    My own feeling is that the greatest American virtue is the enlightened self-interest (accommodated by free & open markets and the rule of law) that deliver the best products and services at the lowest prices.

    …boxes reaching me so fast and prices that are so low

    is a GOOD THING!!

    It is our resulting prosperity that permits us the luxury of having people, like the author, who can make a livelihood out of worrying the "frayed bonds of decency".

    /soapbox off

    I have to ask... have you ever worked in a warehouse or on a production line?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • September 27, 2011 at 12:24 am

    #1386940

    GilaMonster (9/26/2011)

    ALZDBA (9/26/2011)

    Which db would you need to checkpoint (flush) for the sqlserver errorlog to be able to cycle ?

    master only or would it need all db to be flushed ?

    The SQL error log has nothing to do with checkpoints. It's not even stored in a database. (for good reason, SQL needs to write to the error log before it starts any of the databases up.)

    To cycle the error log

    EXEC sp_cycle_errorlog

    Then how does one explain a errorlog not to cycle for 10 days after the exec sp_cycle_errorlog and doing just that after a checkpoint on all databases ??

    Do you happen to know how I can copy/paste a link to twitter. :blush:

    @sql_r posted a tweet on #sqlhelp

    #sqlhelp error log won't recycle,same as goo.gl/jDcha. ran sysinternals, sqlserver.exe has 2 open handles. any fix? thanks.

    sql_r

    to which I eventually replied to try checkpointing sqlserver. Apparently that did the trick for him.

    ( btw I hinted checkpoint because that had done the trick for me a couple of year ago and was recorded in my little checklist 😎 )

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • September 27, 2011 at 3:16 am

    #1386989

    ALZDBA (9/27/2011)

    GilaMonster (9/26/2011)

    ALZDBA (9/26/2011)

    Which db would you need to checkpoint (flush) for the sqlserver errorlog to be able to cycle ?

    master only or would it need all db to be flushed ?

    The SQL error log has nothing to do with checkpoints. It's not even stored in a database. (for good reason, SQL needs to write to the error log before it starts any of the databases up.)

    To cycle the error log

    EXEC sp_cycle_errorlog

    Then how does one explain a errorlog not to cycle for 10 days after the exec sp_cycle_errorlog and doing just that after a checkpoint on all databases ??

    No idea. I'd have to examine the situation further before coming to any conclusions.

    The error log is not part of any database, hence a checkpoint can't affect the error log directly. The error log is in a series of text files. All a checkpoint does is write the dirty portions of the data files to disk. Messages in the error log go directly into the file (I've used text editors before to watch the error log change).

    It could be there were other factors involved. Some unknown factor was preventing a cycle and the checkpoint removed that factor. Without examining the situation, can't say.

    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

  • September 27, 2011 at 6:33 am

    #1387088

    Jack Corbett (9/26/2011)

    So where is everybody? No messages over the weekend and only 2 today?

    I know the Summit isn't for a few more weeks so that can't be the reason. SQLRally Nordic isn't going on now is it?

    Sunday may very well have been the best day in my life so far, but it didn't involve anything that would make sense in The Thread.

    - 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

  • September 27, 2011 at 6:37 am

    #1387095

    Sean Lange (9/26/2011)

    /soapbox on

    Boy I must be on of the few conservatives on here...the amazon article was thought provoking but I find the author's stance does not align with my own. By his line of thought companies achieve better results when economic decisions are guilt-driven instead of by self-interest. There is a lot of guilt laden verbiage in that article that demonstrates it is more shock value than factual.

    …boxes reach me so fast and the prices are so low. And what the story revealed about Amazon could be said of the country, too: that on the road to high and glorious things, it somehow let go of decency . (Oh, the guilt)

    … witnessing a fraying of the bonds of empathy, decency, common purpose. It is becoming a country in which people more than disagree. They fail to see each other. (Oh, the guilt)

    …when a company like Amazon, with such resources to its name, treats vulnerable people so badly just because it can. (Oh, the guilt)

    …companies like Amazon operate as though it never it occurred to them that it could have been them crawling through the aisles. (Oh, the guilt)

    …What is creeping into the culture is simple dehumanization, a failure to imagine the lives others lead. (Oh, the guilt)

    …decency, that great American virtue, falls away. (Oh, the guilt)

    My own feeling is that the greatest American virtue is the enlightened self-interest (accommodated by free & open markets and the rule of law) that deliver the best products and services at the lowest prices.

    …boxes reaching me so fast and prices that are so low

    is a GOOD THING!!

    It is our resulting prosperity that permits us the luxury of having people, like the author, who can make a livelihood out of worrying the "frayed bonds of decency".

    /soapbox off

    It's a pretty fair bet that some people would assume I'm a pretty rabid conservative. On the other hand, there are plenty who think I'm a radical liberal.

    I disagree with the author of the article about a bunch of things, and am pretty sure it's "spun" (I'd use the word "lies", but it's not PC), but I would agree with Steve that unfettered materialism is just as much of a problem as total authoritarianism.

    - 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

  • September 27, 2011 at 7:53 am

    #1387166

    Jeff Moden (9/26/2011)

    Sean Lange (9/26/2011)

    /soapbox on

    ....

    /soapbox off

    I have to ask... have you ever worked in a warehouse or on a production line?

    No I have never worked a production line. I am however not unfamiliar with hard labor. I am in fact in my second career because I decided I didn't want so much physical labor anymore. I was previously a chef, which is certainly a young person's job unless you go the executive route which I had no desire to do. I like to keep my hands in things and pushing pencils to do executive work is not my thing.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Viewing 15 posts - 30,316 through 30,330 (of 66,712 total)

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