Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 57,721 through 57,735 (of 66,712 total)

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

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 1

I came out of that interview raging and absolutely incredulous, but it gave me a good story to tell at the interview I had that afternoon, and I got that job, so I can laugh about it now :).

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 2

In other news, does anybody know a workaround to the issue of not being able to query otherFacsimileTelephoneNumber from AD through a linked server in SQL Server? I can get loads of other attributes (surname, department, job title etc) but unfortunately not this one (and Googling suggests there's probably no way round). It doesn't sound very important in 2017 I realise, but my company stores a different value in that field and I need to get it out.

Thanks.

Here's the error message:

Msg 7346, Level 16, State 2, Line 2

Cannot get the data of the row from the OLE DB provider "ADSDSOObject" for linked server "xxxxxx". Could not convert the data value due to reasons other than sign mismatch or overflow.

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

Sorry, I'm not sorry, for the snide remark to Mr. Celko that I just made.

David Burrows SSC Guru Points: 65142 More actions · Answer 4

Beatrix Kiddo - Wednesday, March 15, 2017 8:14 AM
In other news, does anybody know a workaround to the issue of not being able to query otherFacsimileTelephoneNumber from AD through a linked server in SQL Server? I can get loads of other attributes (surname, department, job title etc) but unfortunately not this one (and Googling suggests there's probably no way round). It doesn't sound very important in 2017 I realise, but my company stores a different value in that field and I need to get it out.
Thanks.
Here's the error message:
Msg 7346, Level 16, State 2, Line 2
Cannot get the data of the row from the OLE DB provider "ADSDSOObject" for linked server "xxxxxx". Could not convert the data value due to reasons other than sign mismatch or overflow.

We do not populate that field so my query just returns nulls.
I suspect you may have a container with data that is incompatible.
I suggest you run the query without that field and then with, to find the container causing the problem and get someone to find out what is in the field in AD, which may give you the cause of the error.

Far away is close at hand in the images of elsewhere.
Anon.

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

I was looking for a reference to reply on a thread and found this article: https://narenin.blogspot.com/2011/08/definition-of-pseudo-cursor_09.html
It had exactly what I was looking for and the style seemed familiar. When googling the first sentence, it all became clear. I wonder what percentage of the entries on that blog are original.

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

Alan Burstein SSC Guru Points: 61141 More actions · Answer 6

Luis Cazares - Wednesday, March 15, 2017 12:32 PM
I was looking for a reference to reply on a thread and found this article: https://narenin.blogspot.com/2011/08/definition-of-pseudo-cursor_09.htm
It had exactly what I was looking for and the style seemed familiar. When googling the first sentence, it all became clear. I wonder what percentage of the entries on that blog are original.

Haha. I just checked...

"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 SSC Guru Points: 183706 More actions · Answer 7

Alan.B - Wednesday, March 15, 2017 12:37 PM
Luis Cazares - Wednesday, March 15, 2017 12:32 PM
I was looking for a reference to reply on a thread and found this article: https://narenin.blogspot.com/2011/08/definition-of-pseudo-cursor_09.htm
It had exactly what I was looking for and the style seemed familiar. When googling the first sentence, it all became clear. I wonder what percentage of the entries on that blog are original.
Haha. I just checked...

Copy-paste problem
https://narenin.blogspot.com/2011/08/definition-of-pseudo-cursor_09.html

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

Sean Lange SSC Guru Points: 286590 More actions · Answer 8

Alan.B - Wednesday, March 15, 2017 12:37 PM
Luis Cazares - Wednesday, March 15, 2017 12:32 PM
I was looking for a reference to reply on a thread and found this article: https://narenin.blogspot.com/2011/08/definition-of-pseudo-cursor_09.htm
It had exactly what I was looking for and the style seemed familiar. When googling the first sentence, it all became clear. I wonder what percentage of the entries on that blog are original.
Haha. I just checked...

Here is the actual link. https://narenin.blogspot.com/2011/08/definition-of-pseudo-cursor_09.html

_______________________________________________________________

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/

Lowell SSC Guru Points: 323518 More actions · Answer 9

I'm never surprised when this happens;
seven months ago, a sharp reader noticed a copy paste of one of mine: i don't care personally, it wasn't rocket science to script it out, but it did take a bit of work. he should say "i found this script, cannot remember where" at least.

https://gallery.technet.microsoft.com/scriptcenter/Script-to-Scipt-out-14a19eda

and here's mine:
http://www.sqlservercentral.com/Forums/Topic982618-391-1.aspx

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Sean Lange SSC Guru Points: 286590 More actions · Answer 10

Lowell - Wednesday, March 15, 2017 12:56 PM
I'm never surprised when this happens;
seven months ago, a sharp reader noticed a copy paste of one of mine: i don't care personally, it wasn't rocket science to script it out, but it did take a bit of work. he should say "i found this script, cannot remember where" at least.
https://gallery.technet.microsoft.com/scriptcenter/Script-to-Scipt-out-14a19eda
and here's mine:
http://www.sqlservercentral.com/Forums/Topic982618-391-1.aspx

Agreed. I have my own snippet database that I maintain. It is a home grown solution that I wrote a few years ago. One of the data points in there is a spot so I can track the origin of a given technique or whatever. Of course I have no blog or published articles but if I ever do, I can at least give a nod or perhaps even full credit to the original author.

_______________________________________________________________

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/

Lowell SSC Guru Points: 323518 More actions · Answer 11

Sean Lange - Wednesday, March 15, 2017 12:50 PM
Alan.B - Wednesday, March 15, 2017 12:37 PM
Luis Cazares - Wednesday, March 15, 2017 12:32 PM
I was looking for a reference to reply on a thread and found this article: https://narenin.blogspot.com/2011/08/definition-of-pseudo-cursor_09.htm
It had exactly what I was looking for and the style seemed familiar. When googling the first sentence, it all became clear. I wonder what percentage of the entries on that blog are original.
Haha. I just checked...
Here is the actual link. https://narenin.blogspot.com/2011/08/definition-of-pseudo-cursor_09.html

same guy, this link
https://narenin.blogspot.com/2011/05/sample-sql-cursor-example.html
is a copy of this one:
http://www.kodyaz.com/articles/cursor.aspx

Pretty sure you guys are right, nothing on his blocg is his own creations.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

Luis Cazares - Wednesday, March 15, 2017 12:32 PM
I was looking for a reference to reply on a thread and found this article: https://narenin.blogspot.com/2011/08/definition-of-pseudo-cursor_09.html
It had exactly what I was looking for and the style seemed familiar. When googling the first sentence, it all became clear. I wonder what percentage of the entries on that blog are original.

Knew the actual author as soon as I read dust bunnies.

Alan Burstein SSC Guru Points: 61141 More actions · Answer 13

Lowell - Wednesday, March 15, 2017 1:32 PM
Sean Lange - Wednesday, March 15, 2017 12:50 PM
Alan.B - Wednesday, March 15, 2017 12:37 PM
Luis Cazares - Wednesday, March 15, 2017 12:32 PM
I was looking for a reference to reply on a thread and found this article: https://narenin.blogspot.com/2011/08/definition-of-pseudo-cursor_09.htm
It had exactly what I was looking for and the style seemed familiar. When googling the first sentence, it all became clear. I wonder what percentage of the entries on that blog are original.
Haha. I just checked...
Here is the actual link. https://narenin.blogspot.com/2011/08/definition-of-pseudo-cursor_09.html
same guy, this link
https://narenin.blogspot.com/2011/05/sample-sql-cursor-example.html
is a copy of this one:
http://www.kodyaz.com/articles/cursor.aspx
Pretty sure you guys are right, nothing on his blocg is his own creations.

Wow

"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

Jeff Moden SSC Guru Points: 1004362 More actions · Answer 14

Alan.B - Wednesday, March 15, 2017 3:01 PM
Lowell - Wednesday, March 15, 2017 1:32 PM
Sean Lange - Wednesday, March 15, 2017 12:50 PM
Alan.B - Wednesday, March 15, 2017 12:37 PM
Luis Cazares - Wednesday, March 15, 2017 12:32 PM
I was looking for a reference to reply on a thread and found this article: https://narenin.blogspot.com/2011/08/definition-of-pseudo-cursor_09.htm
It had exactly what I was looking for and the style seemed familiar. When googling the first sentence, it all became clear. I wonder what percentage of the entries on that blog are original.
Haha. I just checked...
Here is the actual link. https://narenin.blogspot.com/2011/08/definition-of-pseudo-cursor_09.html
same guy, this link
https://narenin.blogspot.com/2011/05/sample-sql-cursor-example.html
is a copy of this one:
http://www.kodyaz.com/articles/cursor.aspx
Pretty sure you guys are right, nothing on his blocg is his own creations.
Wow

I left the blog owner a message on that link. I will be following through with Google if he doesn't not comply in the reasonable time that I've given him. I also covered the blatant plagiarism of his other posts and gave him an ultimatum there, as well.

Thanks for bringing this up on the thread.

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

Alan Burstein SSC Guru Points: 61141 More actions · Answer 15

Jeff Moden - Wednesday, March 15, 2017 8:49 PM
Alan.B - Wednesday, March 15, 2017 3:01 PM
Lowell - Wednesday, March 15, 2017 1:32 PM
Sean Lange - Wednesday, March 15, 2017 12:50 PM
Alan.B - Wednesday, March 15, 2017 12:37 PM
Luis Cazares - Wednesday, March 15, 2017 12:32 PM
I was looking for a reference to reply on a thread and found this article: https://narenin.blogspot.com/2011/08/definition-of-pseudo-cursor_09.htm
It had exactly what I was looking for and the style seemed familiar. When googling the first sentence, it all became clear. I wonder what percentage of the entries on that blog are original.
Haha. I just checked...
Here is the actual link. https://narenin.blogspot.com/2011/08/definition-of-pseudo-cursor_09.html
same guy, this link
https://narenin.blogspot.com/2011/05/sample-sql-cursor-example.html
is a copy of this one:
http://www.kodyaz.com/articles/cursor.aspx
Pretty sure you guys are right, nothing on his blocg is his own creations.
Wow
I left the blog owner a message on that link. I will be following through with Google if he doesn't not comply in the reasonable time that I've given him. I also covered the blatant plagiarism of his other posts and gave him an ultimatum there, as well.
Thanks for bringing this up on the thread.

It's an old blog (no new posts in 5+ years) from some guy India. I suspect you won't hear back. Fortunately it's on Blogger (Google) and Google is pretty good about dealing with this type of thing. If you go to Blogger.com's Terms of Use page(link below) , there's a link to "report abuse"... Google will then remove the blog post and even take down the blog and/or disable his blogger account. I'd just report them.

https://www.blogger.com/content.g?hl=en

"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