Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 54,631 through 54,645 (of 66,712 total)

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

Ray K SSC-Dedicated Points: 31164 More actions · Answer 1

Brandie Tarvin (6/17/2016)
Further proof that anyone believing in the power of zero MUST be crazy. @=) (duck)

+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 2

Ray K (6/17/2016)
Brandie Tarvin (6/17/2016)
Further proof that anyone believing in the power of zero MUST be crazy. @=) (duck)
Zero, my hero!

HA! I forgot about that.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 3

Well, my navigations through the world of VSTS are complete, or at least, working.

As much as I like the system, finding information and understanding exactly what's happening is hard. I think they're rev'ing so much that everyone's thoughts, blogs, howtos, etc, get out of date, even the ones that somehow get to the top of the Google rankings.

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

Steve Jones - SSC Editor (6/17/2016)
Well, my navigations through the world of VSTS are complete, or at least, working.
As much as I like the system, finding information and understanding exactly what's happening is hard. I think they're rev'ing so much that everyone's thoughts, blogs, howtos, etc, get out of date, even the ones that somehow get to the top of the Google rankings.

Sorry, end of a long week, brain dead, no desire to even Google what VSTS is.

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

Lynn Pettis (6/17/2016)
Steve Jones - SSC Editor (6/17/2016)
Well, my navigations through the world of VSTS are complete, or at least, working.
As much as I like the system, finding information and understanding exactly what's happening is hard. I think they're rev'ing so much that everyone's thoughts, blogs, howtos, etc, get out of date, even the ones that somehow get to the top of the Google rankings.
Sorry, end of a long week, brain dead, no desire to even Google what VSTS is.

From their site:

Visual Studio Team Services
Services for teams to share code, track work, and ship software – for any language, all in a single package.
It’s the perfect complement to your IDE.

Visual Studio Team Services
Cloud collaboration tools for teams
It’s not an IDE, it’s everything else. Visual Studio Team Services provides a set of cloud-powered collaboration tools that work with your existing IDE or editor, so your team can work effectively on software projects of all shapes and sizes.

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

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

Luis Cazares (6/17/2016)
Lynn Pettis (6/17/2016)
Steve Jones - SSC Editor (6/17/2016)
Well, my navigations through the world of VSTS are complete, or at least, working.
As much as I like the system, finding information and understanding exactly what's happening is hard. I think they're rev'ing so much that everyone's thoughts, blogs, howtos, etc, get out of date, even the ones that somehow get to the top of the Google rankings.
Sorry, end of a long week, brain dead, no desire to even Google what VSTS is.
From their site:
Visual Studio Team Services
Services for teams to share code, track work, and ship software – for any language, all in a single package.
It’s the perfect complement to your IDE.
Visual Studio Team Services
Cloud collaboration tools for teams
It’s not an IDE, it’s everything else. Visual Studio Team Services provides a set of cloud-powered collaboration tools that work with your existing IDE or editor, so your team can work effectively on software projects of all shapes and sizes.

Thank you.

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 7

Luis got it.

Essentially the online version of TFS. Has VCS, build, release, work tracking, etc. It's really slick, and I like it. It's the equivalent of TFS Server 2015 Update 2 right now.

Some stuff works great, some is hard to navigate, some unintuitive, but it's cool. Will demo it Tues at my webinar: https://attendee.gotowebinar.com/register/4656533273549833218

JustMarie SSCertifiable Points: 7771 More actions · Answer 8

Michael L John (6/16/2016)
I'm sorry, this post infuriates me.
Integer division was taught within the first three weeks of my first programming class in my first semester of school.

To be a bit compassionate they probably didn't even think about data type precedence. Excel does implicit conversions for you and if that's what he's used to using (I'm being compassionate remember?) then not seeing why an explicit conversion is necessary is kind of understandable.

Then again there's this thing called MSDB that has answers to things like "Why won't my two numbers give me a decimal result when I divide them?" so I can't be too compassionate.

And yes. This has come back to bite me more than a few times when I was being lazy.

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

JustMarie (6/20/2016)
Michael L John (6/16/2016)
I'm sorry, this post infuriates me.
Integer division was taught within the first three weeks of my first programming class in my first semester of school.
To be a bit compassionate they probably didn't even think about data type precedence. Excel does implicit conversions for you and if that's what he's used to using (I'm being compassionate remember?) then not seeing why an explicit conversion is necessary is kind of understandable.
Then again there's this thing called MSDB that has answers to things like "Why won't my two numbers give me a decimal result when I divide them?" so I can't be too compassionate.
And yes. This has come back to bite me more than a few times when I was being lazy.

I think you mean MSDN. 😉 Nonetheless, your point is valid.

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

JustMarie SSCertifiable Points: 7771 More actions · Answer 10

Ed Wagner (6/20/2016)
JustMarie (6/20/2016)
Michael L John (6/16/2016)
I'm sorry, this post infuriates me.
Integer division was taught within the first three weeks of my first programming class in my first semester of school.
To be a bit compassionate they probably didn't even think about data type precedence. Excel does implicit conversions for you and if that's what he's used to using (I'm being compassionate remember?) then not seeing why an explicit conversion is necessary is kind of understandable.
Then again there's this thing called MSDB that has answers to things like "Why won't my two numbers give me a decimal result when I divide them?" so I can't be too compassionate.
And yes. This has come back to bite me more than a few times when I was being lazy.
I think you mean MSDN. 😉 Nonetheless, your point is valid.

D'oh! I blame Monday and lack of caffeine. And acronym overload. 😎

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

Sorry for the technical question in The Thread, but I just have to ask everyone around the water cooler what they think.

Does anyone else see a problem with the following code?

Create Trigger tr_TriggerName on dbo.OperationsSIGACTTable Instead Of Insert, Update

AS

Begin

Insert Into OperationsSIGACTTable (Col1, Col2, Summary, .... , ColN)

Select Col1, Col2, RemoveSpecialChars(Summary) , .... , ColN

From inserted i;

End

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

Lynn Pettis (6/20/2016)
Sorry for the technical question in The Thread, but I just have to ask everyone around the water cooler what they think.
Does anyone else see a problem with the following code?
Create Trigger tr_TriggerName on dbo.OperationsSIGACTTable Instead Of Insert, Update
AS
Begin
Insert Into OperationsSIGACTTable (Col1, Col2, Summary, .... , ColN)
Select Col1, Col2, RemoveSpecialChars(Summary) , .... , ColN
From inserted i;
End

Well I see there is a scalar function in there. I also have never been a big fan of (well ok actually it is something I really hate) silently changing input like that. IMHO you should never just decide to change input data except in some pretty rare situations.

_______________________________________________________________

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/

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

Sean Lange (6/20/2016)
Lynn Pettis (6/20/2016)
Sorry for the technical question in The Thread, but I just have to ask everyone around the water cooler what they think.
Does anyone else see a problem with the following code?
Create Trigger tr_TriggerName on dbo.OperationsSIGACTTable Instead Of Insert, Update
AS
Begin
Insert Into OperationsSIGACTTable (Col1, Col2, Summary, .... , ColN)
Select Col1, Col2, RemoveSpecialChars(Summary) , .... , ColN
From inserted i;
End
Well I see there is a scalar function in there. I also have never been a big fan of (well ok actually it is something I really hate) silently changing input like that. IMHO you should never just decide to change input data except in some pretty rare situations.

That is the least of the issues I think I see. What if this code is triggered by an UPDATE?

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

Lynn Pettis (6/20/2016)
Sean Lange (6/20/2016)
Lynn Pettis (6/20/2016)
Sorry for the technical question in The Thread, but I just have to ask everyone around the water cooler what they think.
Does anyone else see a problem with the following code?
Create Trigger tr_TriggerName on dbo.OperationsSIGACTTable Instead Of Insert, Update
AS
Begin
Insert Into OperationsSIGACTTable (Col1, Col2, Summary, .... , ColN)
Select Col1, Col2, RemoveSpecialChars(Summary) , .... , ColN
From inserted i;
End
Well I see there is a scalar function in there. I also have never been a big fan of (well ok actually it is something I really hate) silently changing input like that. IMHO you should never just decide to change input data except in some pretty rare situations.
That is the least of the issues I think I see. What if this code is triggered by an UPDATE?

Yeah that one too. Of course if you have turned off recursive triggers it at least won't crash the system. https://msdn.microsoft.com/en-us/library/bb522682.aspx

_______________________________________________________________

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/

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

Sean Lange (6/20/2016)
Lynn Pettis (6/20/2016)
Sean Lange (6/20/2016)
Lynn Pettis (6/20/2016)
Sorry for the technical question in The Thread, but I just have to ask everyone around the water cooler what they think.
Does anyone else see a problem with the following code?
Create Trigger tr_TriggerName on dbo.OperationsSIGACTTable Instead Of Insert, Update
AS
Begin
Insert Into OperationsSIGACTTable (Col1, Col2, Summary, .... , ColN)
Select Col1, Col2, RemoveSpecialChars(Summary) , .... , ColN
From inserted i;
End
Well I see there is a scalar function in there. I also have never been a big fan of (well ok actually it is something I really hate) silently changing input like that. IMHO you should never just decide to change input data except in some pretty rare situations.
That is the least of the issues I think I see. What if this code is triggered by an UPDATE?
Yeah that one too. Of course if you have turned off recursive triggers it at least won't crash the system. https://msdn.microsoft.com/en-us/library/bb522682.aspx

Instead of triggers don't fire recursively. An insert on the table fires the instead of the trigger, the insert inside the instead of trigger will not fire the instead of trigger again, so that isn't a problem.

Fun part, this is where they got this idea:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/1041e4b3-5f97-4996-a59f-481a08a5a24f/how-to-change-the-special-character-when-inserted-in-to-database?forum=transactsql