Are the posted questions getting worse?
-
Jeff Moden (6/1/2015)
Maybe it's just me. I might be getting too old for this business. [/url]three words too many 😀
-
Steve Jones - SSC Editor (6/3/2015)
Jeff Moden (6/1/2015)
Maybe it's just me. I might be getting too old for this business. [/url]three words too many 😀
3 words? So he should have said: "Me, I might be getting too old for this business." 😛
Alvin Ramard
Memphis PASS Chapter[/url]All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
-
So I'm curious about this (I'm trying to understand how SSC works):
Then the comment is not there...
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."-- Itzik Ben-Gan 2001
-
Luis Cazares (6/3/2015)
Eirikur Eiriksson (6/3/2015)
SQLRNNR (6/3/2015)
Lynn Pettis (6/2/2015)
SMH...Why would the person who wrote the procedure ask on a public forum why his procedure is returning a value of -6 when executed?
Just tell the OP that he needs to whip the cream longer!
My guess is that the OP doesn't have the ability to "read" the code, if he did he wouldn't have asked in the first place.
😎
BTW: probably a negated authentication failed error number (6)
The fun part is that the OP wrote the code. But maybe, he's able to write code but he's not able to read it. :hehe:
If you think that's strange you clearly have no experience of security designed by public servants (aka government bureaucrats).
Tom
-
TomThomson (6/3/2015)
Luis Cazares (6/3/2015)
Eirikur Eiriksson (6/3/2015)
SQLRNNR (6/3/2015)
Lynn Pettis (6/2/2015)
SMH...Why would the person who wrote the procedure ask on a public forum why his procedure is returning a value of -6 when executed?
Just tell the OP that he needs to whip the cream longer!
My guess is that the OP doesn't have the ability to "read" the code, if he did he wouldn't have asked in the first place.
😎
BTW: probably a negated authentication failed error number (6)
The fun part is that the OP wrote the code. But maybe, he's able to write code but he's not able to read it. :hehe:
If you think that's strange you clearly have no experience of security designed by public servants (aka government bureaucrats).
I'm sure the really, really sensitive stuff (such as the IRS systems) are very secure.:hehe:
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."-- Itzik Ben-Gan 2001
-
Alan.B (6/3/2015)
So I'm curious about this (I'm trying to understand how SSC works):
Then the comment is not there...
There are a bunch of them by him. He has been banned. It appears he can post but then the post is wiped from the site.
But the image does raise another interesting thing. Last Post By: By
Does that strike anyone else else as odd odd?
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 (6/3/2015)
Alan.B (6/3/2015)
So I'm curious about this (I'm trying to understand how SSC works):
Then the comment is not there...
There are a bunch of them by him. He has been banned. It appears he can post but then the post is wiped from the site.
But the image does raise another interesting thing. Last Post By: By
Does that strike anyone else else as odd odd?
Yes it does. I got an email notification that he posted to a topic I'm subscribed to, but the link results in the page displaying an error, just like the Last Reply link on the Recent Posts page. His profile still exists with the same picture. So perhaps this is a case where he can login and post whatever he wants, but the details don't appear...only the summary info. Just a guess on my part.
-
Eirikur Eiriksson (6/3/2015)
Luis Cazares (6/3/2015)
Eirikur Eiriksson (6/3/2015)
SQLRNNR (6/3/2015)
Lynn Pettis (6/2/2015)
SMH...Why would the person who wrote the procedure ask on a public forum why his procedure is returning a value of -6 when executed?
Just tell the OP that he needs to whip the cream longer!
My guess is that the OP doesn't have the ability to "read" the code, if he did he wouldn't have asked in the first place.
😎
BTW: probably a negated authentication failed error number (6)
The fun part is that the OP wrote the code. But maybe, he's able to write code but he's not able to read it. :hehe:
I rest my case!
😎
Another case of grabbing code off the internet and implementing it without understanding, from the sounds of it.
-
Ed Wagner (6/3/2015)
SQLRNNR (6/3/2015)
Alan.B (6/3/2015)
So I'm curious about this (I'm trying to understand how SSC works):
Then the comment is not there...
There are a bunch of them by him. He has been banned. It appears he can post but then the post is wiped from the site.
But the image does raise another interesting thing. Last Post By: By
Does that strike anyone else else as odd odd?
Yes it does. I got an email notification that he posted to a topic I'm subscribed to, but the link results in the page displaying an error, just like the Last Reply link on the Recent Posts page. His profile still exists with the same picture. So perhaps this is a case where he can login and post whatever he wants, but the details don't appear...only the summary info. Just a guess on my part.
In which case the site code should be changed to read the Last Post before the banned post so that it can properly display the last post that anyone is able to read.
-
Brandie Tarvin (6/4/2015)
Ed Wagner (6/3/2015)
SQLRNNR (6/3/2015)
Alan.B (6/3/2015)
So I'm curious about this (I'm trying to understand how SSC works):
Then the comment is not there...
There are a bunch of them by him. He has been banned. It appears he can post but then the post is wiped from the site.
But the image does raise another interesting thing. Last Post By: By
Does that strike anyone else else as odd odd?
Yes it does. I got an email notification that he posted to a topic I'm subscribed to, but the link results in the page displaying an error, just like the Last Reply link on the Recent Posts page. His profile still exists with the same picture. So perhaps this is a case where he can login and post whatever he wants, but the details don't appear...only the summary info. Just a guess on my part.
In which case the site code should be changed to read the Last Post before the banned post so that it can properly display the last post that anyone is able to read.
That could have some performance implications. I don't know the structure, but it could mean a subquery is needed to exclude the banned users from the TOP 1 returned with the topic summary row.
-
Ed Wagner (6/4/2015)
Brandie Tarvin (6/4/2015)
Ed Wagner (6/3/2015)
SQLRNNR (6/3/2015)
Alan.B (6/3/2015)
So I'm curious about this (I'm trying to understand how SSC works):
Then the comment is not there...
There are a bunch of them by him. He has been banned. It appears he can post but then the post is wiped from the site.
But the image does raise another interesting thing. Last Post By: By
Does that strike anyone else else as odd odd?
Yes it does. I got an email notification that he posted to a topic I'm subscribed to, but the link results in the page displaying an error, just like the Last Reply link on the Recent Posts page. His profile still exists with the same picture. So perhaps this is a case where he can login and post whatever he wants, but the details don't appear...only the summary info. Just a guess on my part.
In which case the site code should be changed to read the Last Post before the banned post so that it can properly display the last post that anyone is able to read.
That could have some performance implications. I don't know the structure, but it could mean a subquery is needed to exclude the banned users from the TOP 1 returned with the topic summary row.
Should be as simple as
..TOP(1)...
WHERE POST.VISIBLE = TRUE;
😎
-
*sigh*
I swear some people don't actually want help.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
GilaMonster (6/4/2015)
*sigh*I swear some people don't actually want help.
Oh they want help, but the only help they want is the final solution. They don't want to have to do anything more than copy and paste.
Alvin Ramard
Memphis PASS Chapter[/url]All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
-
GilaMonster (6/4/2015)
*sigh*I swear some people don't actually want help.
If you're not supplying one of those little white jackets that tie in the back, then no. I don't want help.
A cubicle with padded walls would be nice too.
-
GilaMonster (6/4/2015)
*sigh*I swear some people don't actually want help.
I was so wanting a link here to see what you're talking about. Oh well, I'll have to live with the disappointment.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2
Viewing 15 posts - 48,781 through 48,795 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply