InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 08:11:30 GMT20http://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspxOK, this has gotten slightly out of hand and away from the purpose of the thread, which is discussion the question.I am closing the thread. The question had been edited, and if you have an issue later on with this question, please email the webmaster.It's good to point out an issue, and make a case for a change if you think there is a problem with the issue, but belaboring the point is not helpful. We do not monitor the questions in real time, and it might be hours before we respond to an issue.Saracasm, insults, pointed comments, and personal attacks on the author or posters are not really appropriate. Nor are repeated responses. Please step back from the keyboard if you feel the need and think about what you are writing. Most of the time the situation isn't helped.Fri, 12 Aug 2011 09:46:41 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspx[quote][b]Toreador (8/12/2011)[/b][hr][quote][b]cfradenburg (8/12/2011)[/b][hr][img]http://imgs.xkcd.com/comics/duty_calls.png[/img][/quote]Worth staying subscribed for :-)[/quote]Oh yeah - that cartoon is excellentFri, 12 Aug 2011 09:42:12 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspx[quote][b]WayneS (8/12/2011)[/b][hr][quote][b]Brandie Tarvin (8/12/2011)[/b][hr][quote][b]SanDroid (8/11/2011)[/b][hr] I am only a Microsoft Certified Trainer and Red Cross Volunteer.[/quote]Wow. I'm a Red Cross Volunteer too. I teach swimming. But I'm a little confused. How does Red Cross Volunteering sync with SQL Server again?Maybe I should write a QOTD with options for connecting the two... @=)[/quote]Why Brandie, it's obviously the need for CPR after encountering such sloppy practices (especially those dratted c.u.r.s.o.r.s) :w00t:[/quote]Don't forget the Heimlich maneuver which is oft necessary if eating and reading these forums:-DFri, 12 Aug 2011 09:40:28 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspx[quote][b]SanDroid (8/12/2011)[/b][hr][quote][b]WayneS (8/12/2011)[/b][hr][quote][b]Brandie Tarvin (8/12/2011)[/b][hr][quote][b]SanDroid (8/11/2011)[/b][hr] I am only a Microsoft Certified Trainer and Red Cross Volunteer.[/quote]Wow. I'm a Red Cross Volunteer too. I teach swimming. But I'm a little confused. How does Red Cross Volunteering sync with SQL Server again?Maybe I should write a QOTD with options for connecting the two... @=)[/quote]Why Brandie, it's obviously the need for CPR after encountering such sloppy practices (especially those dratted c.u.r.s.o.r.s) :w00t:[/quote]Nice one Wayne. LOL.. :cool:[/quote]Glad you liked it!Fri, 12 Aug 2011 09:09:37 GMTWayneShttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspx[quote][b]cfradenburg (8/12/2011)[/b][hr][img]http://imgs.xkcd.com/comics/duty_calls.png[/img][/quote]Worth staying subscribed for :-)Fri, 12 Aug 2011 09:07:24 GMTToreadorhttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspx[quote][b]cfradenburg (8/12/2011)[/b][hr][quote][b]SanDroid (8/12/2011)[/b][hr]You are right. I should stop randomly responding when others post posts about my posts and then repost. It is annoying and it takes away attention from the real subject.... D@#$ It... I just did it again... :hehe: :-P[/quote][img]http://imgs.xkcd.com/comics/duty_calls.png[/img]:-)[/quote]Best one ever! :w00t:Fri, 12 Aug 2011 09:01:57 GMTNinja's_RGR'ushttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspx[quote][b]SanDroid (8/12/2011)[/b][hr]You are right. I should stop randomly responding when others post posts about my posts and then repost. It is annoying and it takes away attention from the real subject.... D@#$ It... I just did it again... :hehe: :-P[/quote][img]http://imgs.xkcd.com/comics/duty_calls.png[/img]:-)Fri, 12 Aug 2011 08:30:23 GMTcfradenburghttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspxNice question and the script is also very nice, thank you.Regards,IulianFri, 12 Aug 2011 08:27:20 GMTIulian -207023http://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspx[quote][b]cfradenburg (8/12/2011)[/b][hr][quote][b]SanDroid (8/12/2011)[/b][hr]And your attitude and Rant is why more people do not say anything at all.What is the use of having an open forum or dicussion if the only thing anyone can post is "Nice question".BTW: Your entire Rant about me ranting was longer than any post I made.[/quote]The point of his post wasn't that you shouldn't say when there's a problem. Nor was it that you shouldn't post a long explanation of what the problem is. The point was that you took every opportunity to point the problem out again which is rather annoying. It's good when people point out what's wrong and explain why. It's bad when once that's been done on a thread it keeps happening. Whether it's one person doing it repeatedly or a lot of different people posting, "I want my point back," on the same thread. At that point it feels much less like, "This is wrong and people need to get the right information," and more, "This person did something wrong and it needs to be pointed at." Your first post was very constructive. After that it wasn't.[/quote]You are right. I should stop randomly responding when others post posts about my posts and then repost. It is annoying and it takes away attention from the real subject.... D@#$ It... I just did it again... :hehe: :-PFri, 12 Aug 2011 07:52:25 GMTSanDroidhttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspxWhere's that darn unsubscribe button? :blink:Fri, 12 Aug 2011 07:26:19 GMTNinja's_RGR'ushttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspx[quote][b]SanDroid (8/12/2011)[/b][hr]And your attitude and Rant is why more people do not say anything at all.What is the use of having an open forum or dicussion if the only thing anyone can post is "Nice question".BTW: Your entire Rant about me ranting was longer than any post I made.[/quote]The point of his post wasn't that you shouldn't say when there's a problem. Nor was it that you shouldn't post a long explanation of what the problem is. The point was that you took every opportunity to point the problem out again which is rather annoying. It's good when people point out what's wrong and explain why. It's bad when once that's been done on a thread it keeps happening. Whether it's one person doing it repeatedly or a lot of different people posting, "I want my point back," on the same thread. At that point it feels much less like, "This is wrong and people need to get the right information," and more, "This person did something wrong and it needs to be pointed at." Your first post was very constructive. After that it wasn't.Fri, 12 Aug 2011 07:19:42 GMTcfradenburghttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspx[quote][b]hakan.winther (8/12/2011)[/b][hr][quote]You are absolutely right. That was the point I was trying to Make with hakan.winther.For me any post here is about the QOTD etc... Anyone that thinks anything else is adding way to much emotion to the mix.[/quote]You were the one who brought it up, and my point is that there are a lot of volunteers at this site and they get a lot of complaint from many like you, and soon no one will volunteer anymore because of the complaints. I wouldn't post a question at this site because of this complaints.[/quote]I post nice question and compliment others more than I complain.I used to only post about the questions I liked and what I liked about them. However even then there where others that would disagree and post slightly less than hatefull responses to my nice comments.Glad you like to Volunteer and help others. Hope you keep doing so.Fri, 12 Aug 2011 07:09:27 GMTSanDroidhttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspx[quote][b]WayneS (8/12/2011)[/b][hr][quote][b]Brandie Tarvin (8/12/2011)[/b][hr][quote][b]SanDroid (8/11/2011)[/b][hr] I am only a Microsoft Certified Trainer and Red Cross Volunteer.[/quote]Wow. I'm a Red Cross Volunteer too. I teach swimming. But I'm a little confused. How does Red Cross Volunteering sync with SQL Server again?Maybe I should write a QOTD with options for connecting the two... @=)[/quote]Why Brandie, it's obviously the need for CPR after encountering such sloppy practices (especially those dratted c.u.r.s.o.r.s) :w00t:[/quote]Nice one Wayne. LOL.. :cool:Fri, 12 Aug 2011 07:02:40 GMTSanDroidhttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspx[quote]You are absolutely right. That was the point I was trying to Make with hakan.winther.For me any post here is about the QOTD etc... Anyone that thinks anything else is adding way to much emotion to the mix.[/quote]You were the one who brought it up, and my point is that there are a lot of volunteers at this site and they get a lot of complaint from many like you, and soon no one will volunteer anymore because of the complaints. I wouldn't post a question at this site because of this complaints.Fri, 12 Aug 2011 06:56:19 GMThakan.wintherhttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspx[quote][b]Brandie Tarvin (8/12/2011)[/b][hr][quote][b]SanDroid (8/11/2011)[/b][hr] I am only a Microsoft Certified Trainer and Red Cross Volunteer.[/quote]Wow. I'm a Red Cross Volunteer too. I teach swimming. But I'm a little confused. How does Red Cross Volunteering sync with SQL Server again?Maybe I should write a QOTD with options for connecting the two... @=)[/quote]Why Brandie, it's obviously the need for CPR after encountering such sloppy practices (especially those dratted c.u.r.s.o.r.s) :w00t:Fri, 12 Aug 2011 06:55:14 GMTWayneShttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspx[quote][b]SanDroid (8/12/2011)[/b][hr][quote][b]Brandie Tarvin (8/12/2011)[/b][hr][quote][b]SanDroid (8/11/2011)[/b][hr] I am only a Microsoft Certified Trainer and Red Cross Volunteer.[/quote]Wow. I'm a Red Cross Volunteer too. I teach swimming. But I'm a little confused. How does Red Cross Volunteering sync with SQL Server again?Maybe I should write a QOTD with options for connecting the two... @=)[/quote]You are absolutely right. That was the point I was trying to Make with hakan.winther.[/quote]Huh?You're the one who brought up the connection. Why did you bring it up if you agree that they don't have anything to do with each other?Fri, 12 Aug 2011 06:46:10 GMTBrandie Tarvinhttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspx[quote][b]Brandie Tarvin (8/12/2011)[/b][hr][quote][b]SanDroid (8/11/2011)[/b][hr] I am only a Microsoft Certified Trainer and Red Cross Volunteer.[/quote]Wow. I'm a Red Cross Volunteer too. I teach swimming. But I'm a little confused. How does Red Cross Volunteering sync with SQL Server again?Maybe I should write a QOTD with options for connecting the two... @=)[/quote]You are absolutely right. That was the point I was trying to Make with hakan.winther.For me any post here is about the QOTD etc... Anyone that thinks anything else is adding way to much emotion to the mix.Fri, 12 Aug 2011 06:41:48 GMTSanDroidhttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspx[quote][b]hakan.winther (8/12/2011)[/b][hr][quote][b]SanDroid (8/11/2011)[/b][hr][quote][b]hakan.winther (8/11/2011)[/b][hr][quote][b]SanDroid (8/10/2011)[/b][hr][quote][b]hakan.winther (8/10/2011)[/b][hr][quote][b]SanDroid (8/10/2011)[/b][hr][quote][b]SQLRNNR (8/10/2011)[/b][hr]I think this is a great question.[/quote]As would I if the error in the script did not cause the wrong result.It seems incorrect to give a point to those that did NOT carefully read and understood what the script was doing.[/quote]But you got more points from complaining then answering the question!I try to answer the question without testing the script to see if know the answer, (and to learn) and in this case i answered by experience and got the correct result.[/quote]FYI: Posting to the Forums does not give your points in the QOTD section. Posting to the Forums also does not affect your QOTD category averages. ;-)I used to only care about the overall score... but then someone pointed out that anybody can make a bunch of Forum posts that may or may not be correct.[/quote]You are right about the "importance" of the points, but personally I don't do it for the points or the right to brag about them. On the other hand, I am only at position 115 so my score doesn't show up on the score board. I do it to check my knowledge and to learn more.I do care about the point that I earn by helping others at ask.sqlservercentral.com and I think that it is more important points because you really make a difference by helping others. And I think that it's worth bragging about, but maybe its because I am at the 10:th on the "reputation" board. :)[/quote]Learning and helping others is very important. I am only a Microsoft Certified Trainer and Red Cross Volunteer. When teaching classes I do not give students labs or tests with scripts that give the wrong results. I expect the same in other forums that are open to discussion.[/quote]Red Cross Volunteer! Thank you for helping the world to be a better place to live in.[/quote]The point is, not of that matters. This discussion should be about the QOTD. If you want to discuss our feelings, lets meet somewhere and hold hands. :cool:Fri, 12 Aug 2011 06:35:11 GMTSanDroidhttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspx[quote][b]Lynn Pettis (8/11/2011)[/b][hr]SanDroid,I haven't been as active on the forums this past year. I'm curious if you have tried submitting a QotD? If not, perhaps it's time to give it a try.[/quote]I have. ;-)Fri, 12 Aug 2011 06:33:45 GMTSanDroidhttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspx[quote][b]Evil Kraig F (8/11/2011)[/b][hr][quote][b]SanDroid (8/11/2011)[/b][hr]Learning and helping others is very important. I am only a Microsoft Certified Trainer and Red Cross Volunteer. When teaching classes I do not give students labs or tests with scripts that give the wrong results. I expect the same in other forums that are open to discussion.[/quote]SanDroid, right or wrong in your analysis of the issue... a few things.1) A difference between: Microsoft Certified Trainer (Paid) and Red Cross Volunteer (Certified if doing training) QOTD submitter: Unpaid, uncertified, and trying to simply be helpful.2) A diatribe vs. a discussion You're becoming an embarassment to the SQL Community if they come to these boards, at the level of CELKO. You're already a running joke. Any question that comes out here that has any slightly off item you go into full-on rant mode. On your resume, do you list '18th place in QOTD's on SQL Server'? No? Then back off. Present your point, sure, but if you think there's humor or interest in your belligerant attitude, there isn't. Put your e-peen back in your pants, there's better ways to make your point then being an ***.3) Yes, you're right. I'm not saying you're not. There was a mistake in the script. Yes, there are circumstances where 'it depends'. In general these questions aren't meant to be run, though the script is there so we can understand it. It's to show you the question and for your brain to answer it, not your computer. Sure, I've gone back and run the scripts after the fact too, to see what was going on. If it adds to your knowledge, the QOTD did what it was meant to. 10 points here or there WILL NOT MATTER when you're dead, stop giving yourself a heart attack. Bring it up, make your point, and (I don't believe [i]I'm[/i] the one saying this) learn some tact.It's getting to the point that people are actually worried about submitting QOTDs because of reactions like yours. Chill dude.[/quote]And your attitude and Rant is why more people do not say anything at all.What is the use of having an open forum or dicussion if the only thing anyone can post is "Nice question".BTW: Your entire Rant about me ranting was longer than any post I made.Fri, 12 Aug 2011 06:31:54 GMTSanDroidhttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspx[quote][b]SanDroid (8/11/2011)[/b][hr] I am only a Microsoft Certified Trainer and Red Cross Volunteer.[/quote]Wow. I'm a Red Cross Volunteer too. I teach swimming. But I'm a little confused. How does Red Cross Volunteering sync with SQL Server again?Maybe I should write a QOTD with options for connecting the two... @=)Fri, 12 Aug 2011 05:38:56 GMTBrandie Tarvinhttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspx[quote][b]Evil Kraig F (8/11/2011)[/b][hr]It's getting to the point that people are actually worried about submitting QOTDs because of reactions like yours. Chill dude.[/quote]I'm not submitting any more. It's a fair bit of work to get a good question on a useful topic, with a well-written explanation and useful references and there's almost always someone whining that they read 'when' to mean 'sometime after' or similar.Articles are more work, but at least I don't have to worry too much about english language nitpicking.Fri, 12 Aug 2011 02:00:06 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspx[quote][b]SanDroid (8/11/2011)[/b][hr][quote][b]hakan.winther (8/11/2011)[/b][hr][quote][b]SanDroid (8/10/2011)[/b][hr][quote][b]hakan.winther (8/10/2011)[/b][hr][quote][b]SanDroid (8/10/2011)[/b][hr][quote][b]SQLRNNR (8/10/2011)[/b][hr]I think this is a great question.[/quote]As would I if the error in the script did not cause the wrong result.It seems incorrect to give a point to those that did NOT carefully read and understood what the script was doing.[/quote]But you got more points from complaining then answering the question!I try to answer the question without testing the script to see if know the answer, (and to learn) and in this case i answered by experience and got the correct result.[/quote]FYI: Posting to the Forums does not give your points in the QOTD section. Posting to the Forums also does not affect your QOTD category averages. ;-)I used to only care about the overall score... but then someone pointed out that anybody can make a bunch of Forum posts that may or may not be correct.[/quote]You are right about the "importance" of the points, but personally I don't do it for the points or the right to brag about them. On the other hand, I am only at position 115 so my score doesn't show up on the score board. I do it to check my knowledge and to learn more.I do care about the point that I earn by helping others at ask.sqlservercentral.com and I think that it is more important points because you really make a difference by helping others. And I think that it's worth bragging about, but maybe its because I am at the 10:th on the "reputation" board. :)[/quote]Learning and helping others is very important. I am only a Microsoft Certified Trainer and Red Cross Volunteer. When teaching classes I do not give students labs or tests with scripts that give the wrong results. I expect the same in other forums that are open to discussion.[/quote]Red Cross Volunteer! Thank you for helping the world to be a better place to live in.Fri, 12 Aug 2011 01:40:46 GMThakan.wintherhttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspxSanDroid,I haven't been as active on the forums this past year. I'm curious if you have tried submitting a QotD? If not, perhaps it's time to give it a try.Thu, 11 Aug 2011 19:14:29 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspx[quote][b]SQLRNNR (8/11/2011)[/b][hr][quote][b]Evil Kraig F (8/11/2011)[/b][hr][quote][b]SanDroid (8/11/2011)[/b][hr]Learning and helping others is very important. I am only a Microsoft Certified Trainer and Red Cross Volunteer. When teaching classes I do not give students labs or tests with scripts that give the wrong results. I expect the same in other forums that are open to discussion.[/quote]SanDroid, right or wrong in your analysis of the issue... a few things.1) A difference between: Microsoft Certified Trainer (Paid) and Red Cross Volunteer (Certified if doing training) QOTD submitter: Unpaid, uncertified, and trying to simply be helpful.2) A diatribe vs. a discussion You're becoming an embarassment to the SQL Community if they come to these boards, at the level of CELKO. You're already a running joke. Any question that comes out here that has any slightly off item you go into full-on rant mode. On your resume, do you list '18th place in QOTD's on SQL Server'? No? Then back off. Present your point, sure, but if you think there's humor or interest in your belligerant attitude, there isn't. Put your e-peen back in your pants, there's better ways to make your point then being an ***.3) Yes, you're right. I'm not saying you're not. There was a mistake in the script. Yes, there are circumstances where 'it depends'. In general these questions aren't meant to be run, though the script is there so we can understand it. It's to show you the question and for your brain to answer it, not your computer. Sure, I've gone back and run the scripts after the fact too, to see what was going on. If it adds to your knowledge, the QOTD did what it was meant to. 10 points here or there WILL NOT MATTER when you're dead, stop giving yourself a heart attack. Bring it up, make your point, and (I don't believe [i]I'm[/i] the one saying this) learn some tact.It's getting to the point that people are actually worried about submitting QOTDs because of reactions like yours. Chill dude.[/quote]Good thing you changed to Evil Kraig F prior to posting this ;-)[/quote]I have to agree. I don't think I'd have gotten away with this.Thu, 11 Aug 2011 18:56:47 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspx[quote][b]SQLRNNR (8/11/2011)[/b][hr]Good thing you changed to Evil Kraig F prior to posting this ;-)[/quote]That Craig dude is my 'good twin'. Can't stand him. He's too nice.Thu, 11 Aug 2011 17:04:10 GMTEvil Kraig Fhttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspx[quote][b]Evil Kraig F (8/11/2011)[/b][hr][quote][b]SanDroid (8/11/2011)[/b][hr]Learning and helping others is very important. I am only a Microsoft Certified Trainer and Red Cross Volunteer. When teaching classes I do not give students labs or tests with scripts that give the wrong results. I expect the same in other forums that are open to discussion.[/quote]SanDroid, right or wrong in your analysis of the issue... a few things.1) A difference between: Microsoft Certified Trainer (Paid) and Red Cross Volunteer (Certified if doing training) QOTD submitter: Unpaid, uncertified, and trying to simply be helpful.2) A diatribe vs. a discussion You're becoming an embarassment to the SQL Community if they come to these boards, at the level of CELKO. You're already a running joke. Any question that comes out here that has any slightly off item you go into full-on rant mode. On your resume, do you list '18th place in QOTD's on SQL Server'? No? Then back off. Present your point, sure, but if you think there's humor or interest in your belligerant attitude, there isn't. Put your e-peen back in your pants, there's better ways to make your point then being an ***.3) Yes, you're right. I'm not saying you're not. There was a mistake in the script. Yes, there are circumstances where 'it depends'. In general these questions aren't meant to be run, though the script is there so we can understand it. It's to show you the question and for your brain to answer it, not your computer. Sure, I've gone back and run the scripts after the fact too, to see what was going on. If it adds to your knowledge, the QOTD did what it was meant to. 10 points here or there WILL NOT MATTER when you're dead, stop giving yourself a heart attack. Bring it up, make your point, and (I don't believe [i]I'm[/i] the one saying this) learn some tact.It's getting to the point that people are actually worried about submitting QOTDs because of reactions like yours. Chill dude.[/quote]Good thing you changed to Evil Kraig F prior to posting this ;-)Thu, 11 Aug 2011 17:01:24 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspx[quote][b]SanDroid (8/11/2011)[/b][hr]Learning and helping others is very important. I am only a Microsoft Certified Trainer and Red Cross Volunteer. When teaching classes I do not give students labs or tests with scripts that give the wrong results. I expect the same in other forums that are open to discussion.[/quote]SanDroid, right or wrong in your analysis of the issue... a few things.1) A difference between: Microsoft Certified Trainer (Paid) and Red Cross Volunteer (Certified if doing training) QOTD submitter: Unpaid, uncertified, and trying to simply be helpful.2) A diatribe vs. a discussion You're becoming an embarassment to the SQL Community if they come to these boards, at the level of CELKO. You're already a running joke. Any question that comes out here that has any slightly off item you go into full-on rant mode. On your resume, do you list '18th place in QOTD's on SQL Server'? No? Then back off. Present your point, sure, but if you think there's humor or interest in your belligerant attitude, there isn't. Put your e-peen back in your pants, there's better ways to make your point then being an ***.3) Yes, you're right. I'm not saying you're not. There was a mistake in the script. Yes, there are circumstances where 'it depends'. In general these questions aren't meant to be run, though the script is there so we can understand it. It's to show you the question and for your brain to answer it, not your computer. Sure, I've gone back and run the scripts after the fact too, to see what was going on. If it adds to your knowledge, the QOTD did what it was meant to. 10 points here or there WILL NOT MATTER when you're dead, stop giving yourself a heart attack. Bring it up, make your point, and (I don't believe [i]I'm[/i] the one saying this) learn some tact.It's getting to the point that people are actually worried about submitting QOTDs because of reactions like yours. Chill dude.Thu, 11 Aug 2011 16:57:36 GMTEvil Kraig Fhttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspx[quote][b]hakan.winther (8/11/2011)[/b][hr][quote][b]SanDroid (8/10/2011)[/b][hr][quote][b]hakan.winther (8/10/2011)[/b][hr][quote][b]SanDroid (8/10/2011)[/b][hr][quote][b]SQLRNNR (8/10/2011)[/b][hr]I think this is a great question.[/quote]As would I if the error in the script did not cause the wrong result.It seems incorrect to give a point to those that did NOT carefully read and understood what the script was doing.[/quote]But you got more points from complaining then answering the question!I try to answer the question without testing the script to see if know the answer, (and to learn) and in this case i answered by experience and got the correct result.[/quote]FYI: Posting to the Forums does not give your points in the QOTD section. Posting to the Forums also does not affect your QOTD category averages. ;-)I used to only care about the overall score... but then someone pointed out that anybody can make a bunch of Forum posts that may or may not be correct.[/quote]You are right about the "importance" of the points, but personally I don't do it for the points or the right to brag about them. On the other hand, I am only at position 115 so my score doesn't show up on the score board. I do it to check my knowledge and to learn more.I do care about the point that I earn by helping others at ask.sqlservercentral.com and I think that it is more important points because you really make a difference by helping others. And I think that it's worth bragging about, but maybe its because I am at the 10:th on the "reputation" board. :)[/quote]Learning and helping others is very important. I am only a Microsoft Certified Trainer and Red Cross Volunteer. When teaching classes I do not give students labs or tests with scripts that give the wrong results. I expect the same in other forums that are open to discussion.Thu, 11 Aug 2011 06:46:46 GMTSanDroidhttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspxvery nice question!!! thanks!!!Living and learning!!!Thu, 11 Aug 2011 05:43:14 GMTrfr.ferrarihttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspxGreat question, thanks.Thu, 11 Aug 2011 01:32:09 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspx[quote][b]SanDroid (8/10/2011)[/b][hr][quote][b]hakan.winther (8/10/2011)[/b][hr][quote][b]SanDroid (8/10/2011)[/b][hr][quote][b]SQLRNNR (8/10/2011)[/b][hr]I think this is a great question.[/quote]As would I if the error in the script did not cause the wrong result.It seems incorrect to give a point to those that did NOT carefully read and understood what the script was doing.[/quote]But you got more points from complaining then answering the question!I try to answer the question without testing the script to see if know the answer, (and to learn) and in this case i answered by experience and got the correct result.[/quote]FYI: Posting to the Forums does not give your points in the QOTD section. Posting to the Forums also does not affect your QOTD category averages. ;-)I used to only care about the overall score... but then someone pointed out that anybody can make a bunch of Forum posts that may or may not be correct.[/quote]You are right about the "importance" of the points, but personally I don't do it for the points or the right to brag about them. On the other hand, I am only at position 115 so my score doesn't show up on the score board. I do it to check my knowledge and to learn more.I do care about the point that I earn by helping others at ask.sqlservercentral.com and I think that it is more important points because you really make a difference by helping others. And I think that it's worth bragging about, but maybe its because I am at the 10:th on the "reputation" board. :)Thu, 11 Aug 2011 00:36:57 GMThakan.wintherhttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspx[quote][b]OzYbOi d(-_-)b (8/10/2011)[/b][hr]great question. hope that the lesson isn't lost in all the kerfuffle... :-D :hehe:[/quote]I agree with you! There are so many databases with performance issues and if some of the issues can be solved this easy, then we can focus on more complex issues. On the other hand, you get a lot of happy clients when you can help them this easy. :)Thu, 11 Aug 2011 00:29:26 GMThakan.wintherhttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspxGood question.I thought about it for a while - and remembered previous discussions on SQLCentral about what a total disaster shrink is (unless you immediately follow it be reubuilding everything in sight) and picked the over 90 option.Wed, 10 Aug 2011 20:57:56 GMTL' Eomot Inverséhttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspx[quote][b]OzYbOi d(-_-)b (8/10/2011)[/b][hr]great question. hope that the lesson isn't lost in all the kerfuffle... :-D :hehe:[/quote]Can we have kerfuffles for breakfast, mummy dear, mummy dear....Wait that's wrong. :-PAnyway, great question. I guessed, thinking since the db was small, that the second choice would be the most likely. I too had no idea shrinking caused that much of an issue. Interesting to note that it's listed as a best practice in MSDN to turn autoshrink off. If that's the case, then why even offer it as an option?Wed, 10 Aug 2011 12:10:59 GMTpnewharthttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspxgreat question. hope that the lesson isn't lost in all the kerfuffle... :-D :hehe:Wed, 10 Aug 2011 11:21:29 GMTOzYbOi d(-_-)bhttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspx[quote][b]Steve Jones - SSC Editor (8/10/2011)[/b][hr]I have updated and corrected the script and included a create database statement. This does show fragmentation of .39% and 90+% if you run this in a newly created database with the defaults. If you have other objects in the database, it is possible that you will get other values.No attempt was made to trick people and in general we look to run questions on systems with basic defaults.I will award back points.[/quote]Thank you Steve!We have had some really neat tricky QOTD lately. Very inventive. The original script posted with this question would be another good one if you could explain what causes the behavior.Wed, 10 Aug 2011 11:10:04 GMTSanDroidhttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspx[quote][b]hakan.winther (8/10/2011)[/b][hr][quote][b]SanDroid (8/10/2011)[/b][hr][quote][b]SQLRNNR (8/10/2011)[/b][hr]I think this is a great question.[/quote]As would I if the error in the script did not cause the wrong result.It seems incorrect to give a point to those that did NOT carefully read and understood what the script was doing.[/quote]But you got more points from complaining then answering the question!I try to answer the question without testing the script to see if know the answer, (and to learn) and in this case i answered by experience and got the correct result.[/quote]FYI: Posting to the Forums does not give your points in the QOTD section. Posting to the Forums also does not affect your QOTD category averages. ;-)I used to only care about the overall score... but then someone pointed out that anybody can make a bunch of Forum posts that may or may not be correct.Wed, 10 Aug 2011 11:08:03 GMTSanDroidhttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspxDon't know that I deserve my point back, but thanks. I know that shrinking DB's is generally bad and had initially selected 90%. Then I decided to check my answer (e.g. - 'cheat') and got an error message associated with the create FirstTable statement being included with the GO batch and the fragmentation remained the same. When I "Corrected" the script the Fragmentation only increased to 12.5%. So, I really tricked myself by not trusting my instincts.Wed, 10 Aug 2011 10:53:34 GMTJ DBAhttp://www.sqlservercentral.com/Forums/Topic1157383-1222-1.aspx[quote][b]SanDroid (8/10/2011)[/b][hr][quote][b]SQLRNNR (8/10/2011)[/b][hr]I think this is a great question.[/quote]As would I if the error in the script did not cause the wrong result.It seems incorrect to give a point to those that did NOT carefully read and understood what the script was doing.[/quote]But you got more points from complaining then answering the question!I try to answer the question without testing the script to see if know the answer, (and to learn) and in this case i answered by experience and got the correct result.Wed, 10 Aug 2011 10:52:47 GMThakan.winther