Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 45,376 through 45,390 (of 66,712 total)

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

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 1

Apparently lots of people are on holiday at RG, so things moving slow.

I think football season has caused issues, though I'm keeping an eye out.

I may spend some time tomorrow or Tues trying to write a job that will kill the posts that are for "Live Stream Online" or some similar phrases. Might help.

andrew gothard SSChampion Points: 12314 More actions · Answer 2

Ed Wagner (8/22/2014)
Lynn Pettis (8/22/2014)
And Mr. Celko is back with his baseball bat. :Whistling:
In more than one thread. :Whistling:
Hey, don't forget that it's an ANSI baseball bat that conforms to standard 802.11.BR549.4219-2R94000-6.1-11(B).

'No member of the Corps should ever report for active duty in a ginger toupee.'?

I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.

venoym SSCarpal Tunnel Points: 4161 More actions · Answer 3

Evil Kraig F (8/29/2014)
Anybody with a solid level of experience in Service Broker able to help someone out? He's new to the site but he's definitely providing what we need and is competent. It's an intriguing puzzle, but I just don't have time to dig that deeply into it immediately.
http://www.sqlservercentral.com/Forums/FindPost1608456.aspx

I weighed in on it. It's a feature of the RECEIVE command, it only grabs the first conversation_handle, not just the first 1000 messages. You can alter it by using a WHERE clause, but it might still simply grab the first conversation each loop. I ran into this a while back when I had a queue of over 1 million messages. It would sit and process 30 messages at a time instead of the 500 that performance monitoring said was the most efficient.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

Anyone feel up to some trigger fun?

http://www.sqlservercentral.com/Forums/Topic1609279-1292-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

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 5

GilaMonster (9/1/2014)
Anyone feel up to some trigger fun?
http://www.sqlservercentral.com/Forums/Topic1609279-1292-1.aspx

Not certain there was a comprehension of the punchline:-P

😎

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 6

Lynn Pettis (8/22/2014)
And Mr. Celko is back with his baseball bat. :Whistling:
In more than one thread. :Whistling:

Now he has put the bat aside and instead taken up the lynching of any beginners

😎

Luis Cazares SSC Guru Points: 183706 More actions · Answer 7

Eirikur Eiriksson (9/1/2014)
Lynn Pettis (8/22/2014)
And Mr. Celko is back with his baseball bat. :Whistling:
In more than one thread. :Whistling:
Now he has put the bat aside and instead taken up the lynching of any beginners
😎

I'm tempted to report some posts as spam for promoting himself without giving any valuable help.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

TomThomson SSC Guru Points: 104773 More actions · Answer 8

Luis Cazares (9/1/2014)
Eirikur Eiriksson (9/1/2014)
Lynn Pettis (8/22/2014)
And Mr. Celko is back with his baseball bat. :Whistling:
In more than one thread. :Whistling:
Now he has put the bat aside and instead taken up the lynching of any beginners
😎
I'm tempted to report some posts as spam for promoting himself without giving any valuable help.

When I see a post like that I get furious. I regard it as unacceptable behaviour in any civilised forum. Celko does it far too often.

I've succumbed to the temptation and reported it as both spam and unacceptable abuse.

But he doesn't always get it completely wrong as he did in that thread; his contribution to triggers for auditing thread raised a serious point about legal requirements for auditing.

Tom

venoym SSCarpal Tunnel Points: 4161 More actions · Answer 9

TomThomson (9/1/2014)
Luis Cazares (9/1/2014)
Eirikur Eiriksson (9/1/2014)
Lynn Pettis (8/22/2014)
And Mr. Celko is back with his baseball bat. :Whistling:
In more than one thread. :Whistling:
Now he has put the bat aside and instead taken up the lynching of any beginners
😎
I'm tempted to report some posts as spam for promoting himself without giving any valuable help.
When I see a post like that I get furious. I regard it as unacceptable behaviour in any civilised forum. Celko does it far too often.
I've succumbed to the temptation and reported it as both spam and unacceptable abuse.
But he doesn't always get it completely wrong as he did in that thread; his contribution to triggers for auditing thread raised a serious point about legal requirements for auditing.

I actually had to comment on that Tom. It is not illegal to audit changes in a DB (as far as I know, but Europeans can be weird). Change auditing is not the entirety of a legal requirement for all views (i.e. SELECT's) though, you would have to take additional steps.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 10

And once again the SSC Silver Spoons are out and available, even mine.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 11

Curious how the code that our silver spooner posted even worked. After declaring all the variables I still have a bunch of red squiggly lines.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 12

Lynn Pettis (9/2/2014)
Curious how the code that our silver spooner posted even worked. After declaring all the variables I still have a bunch of red squiggly lines.

Those are just there for decoration...they don't mean anything, do they? The statement "I keep getting a syntax error" couldn't possibly be related to the squiggly lines.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 13

Lynn Pettis (9/2/2014)
Curious how the code that our silver spooner posted even worked. After declaring all the variables I still have a bunch of red squiggly lines.

Total lack of comprehension, SSP's paycheck should be funding our after work pint and beer popsicles

😎

Ed Wagner SSC Guru Points: 287026 More actions · Answer 14

Eirikur Eiriksson (9/2/2014)
Lynn Pettis (9/2/2014)
Curious how the code that our silver spooner posted even worked. After declaring all the variables I still have a bunch of red squiggly lines.
Total lack of comprehension, SSP's paycheck should be funding our after work pint and beer popsicles
😎

Also lacking is the ability to read what is posted and right in front of them.

You get beer popsicles provided? :w00t:

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 15

Ed Wagner (9/2/2014)
Eirikur Eiriksson (9/2/2014)
Lynn Pettis (9/2/2014)
Curious how the code that our silver spooner posted even worked. After declaring all the variables I still have a bunch of red squiggly lines.
Total lack of comprehension, SSP's paycheck should be funding our after work pint and beer popsicles
😎
Also lacking is the ability to read what is posted and right in front of them.
You get beer popsicles provided? :w00t:

Unfortunately the contractually provided beer popsicles are limited to 3 per hour, but high quality naturally frozen Dortmunder only, which is a plus;-)

😎