Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 62,356 through 62,370 (of 66,712 total)

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

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

Lynn Pettis - Wednesday, September 26, 2018 8:58 AM
Who has the Crystal Ball?

That would be me. See the problem is that the front end doesn't know what the back end is doing, and probably doesn't even realize the back end is searching for a toilet.

@=)

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.

DesNorton SSC-Insane Points: 24387 More actions · Answer 2

Brandie Tarvin - Wednesday, September 26, 2018 8:54 AM
When I was in college, I remember a cast party at someone's house where a participant stuck a bottle of Everclear into the freezer for at least 10 minutes, possibly more. Then pulled it out and poured shots. The idea was the time in the freezer supposedly gave it a little more of a kick. I took one sip, didn't like it. But the whole thing spawned a conversation about how Everclear doesn't ever freeze and would make the perfect fuel for one's car if it was the middle of winter and the driver had run out of gas.
I tell this story because of this: https://www.washingtonpost.com/news/voraciously/wp/2018/09/26/everclear-wants-you-to-think-its-a-craft-cocktail-ingredient-good-luck-with-that/?noredirect=on&utm_term=.4322969685f7
So, yeah. Let's have cocktail hour with the stuff that will run your car. That makes PERFECT sense.

A much prettier little shot .... Jellyfish Shot

How to post data/code on a forum to get the best help.

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

DesNorton - Wednesday, September 26, 2018 9:05 AM
Brandie Tarvin - Wednesday, September 26, 2018 8:54 AM
When I was in college, I remember a cast party at someone's house where a participant stuck a bottle of Everclear into the freezer for at least 10 minutes, possibly more. Then pulled it out and poured shots. The idea was the time in the freezer supposedly gave it a little more of a kick. I took one sip, didn't like it. But the whole thing spawned a conversation about how Everclear doesn't ever freeze and would make the perfect fuel for one's car if it was the middle of winter and the driver had run out of gas.
I tell this story because of this: https://www.washingtonpost.com/news/voraciously/wp/2018/09/26/everclear-wants-you-to-think-its-a-craft-cocktail-ingredient-good-luck-with-that/?noredirect=on&utm_term=.4322969685f7
So, yeah. Let's have cocktail hour with the stuff that will run your car. That makes PERFECT sense.
A much prettier little shot .... Jellyfish Shot

THAT is awesome!

I want to make one just to see it do that. Who cares about drinking it.

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.

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

Eirikur Eiriksson - Wednesday, September 26, 2018 7:48 AM
Ray K - Tuesday, September 25, 2018 1:50 PM
YES!!! YES!!! YES!!! YES!!! YES!!! YES!!! YES!!! YES!!! THIS A BILLION TIMES YES!!! +10000000000000
This is why I am so passionate about the SQL Saturday presentations that I do. I preach documentation. Documentation is the ugly but critical stepchild when it comes to technology. I even have a 'blog article where I refer to it as the "Rodney Dangerfield of technical professions. It gets absolutely no respect. Nobody wants to do it, but your organization is doomed to failure without it.
Documentation does not have to be the Ugly Duckling of development, but only if it is an integral part of it. The abstraction of code generation from the development process, is of course a key factor, as if a developer has to write both, there will be difference in priorities and it doesn't take a genius to figure out which of those will be ignored.
😎
Are you by any chance in Pittsburgh for SQL Saturday this weekend?

Unfortunately, no. I had originally applied to speak, but Boston came up, and I decided for the sake of my sanity that back-to-back weekends was a bit much.

Too bad, because I was looking forward to making the trip to Pittsburgh. 🙁

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

jasona.work SSC Guru Points: 50117 More actions · Answer 5

I know I've made similar comments before, but it's almost amazing how good it feels to accomplish something as simple as creating a SSIS package to check if a table exists, then create it if needed, then import audit files to the table.

So far, it works in my lab, this weekend will be the test of fire on one of my QAs...

Michael L John One Orange Chip Points: 27056 More actions · Answer 6

Ray K - Tuesday, September 25, 2018 1:50 PM
YES!!! YES!!! YES!!! YES!!! YES!!! YES!!! YES!!! YES!!! THIS A BILLION TIMES YES!!! +10000000000000
This is why I am so passionate about the SQL Saturday presentations that I do. I preach documentation. Documentation is the ugly but critical stepchild when it comes to technology. I even have a 'blog article where I refer to it as the "Rodney Dangerfield of technical professions. It gets absolutely no respect. Nobody wants to do it, but your organization is doomed to failure without it.

There is no need for documentation when you are Agile, correct? If so, we are VERY Agile!

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

Phil Parkin SSC Guru Points: 246965 More actions · Answer 7

jasona.work - Thursday, September 27, 2018 12:29 PM
I know I've made similar comments before, but it's almost amazing how good it feels to accomplish something as simple as creating a SSIS package to check if a table exists, then create it if needed, then import audit files to the table.
So far, it works in my lab, this weekend will be the test of fire on one of my QAs...

Doesn't DDL like this cause a conflict with your VCS?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 8

Jeff Moden - Monday, September 24, 2018 1:51 PM
Eirikur Eiriksson - Monday, September 24, 2018 10:33 AM
Here is a safer version for varchar(8000),
😎
USE TEEST; GO SET NOCOUNT ON; GO ALTER FUNCTION dbo.ITVFN_SPLIT_8K_STRING_JSON ( @INPUT_STRING VARCHAR(8000) ,@DELIMITER VARCHAR(250) ) RETURNS TABLE WITH SCHEMABINDING AS RETURN ( SELECT Y AS Item from OPENJSON ( '[{"Y":"' + REPLACE(STRING_ESCAPE(@INPUT_STRING,'json'),@DELIMITER,'"},{"Y":"') + '"}]' ) WITH (Y VARCHAR(8000) '$.Y') ); GO
I'll try to convert the document into an article on the flights to an from Pittsburgh next weekend when I'm meeting up with some of the regulars here 😉
Check for performance. I've seen several such JSON splitters and then someone compares against DelimitedSplit8K and the new built in splitter function and the JSON is reportedly a whole lot slower.
[EDIT] Might have even been you. I just noticed the post you made on the subject above. :blush:

Yeah - the built-in splitter was mediocre (considering it is built-in 😛 ). Besides - the syntax is REALLY finnicky.

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

drew.allen SSC Guru Points: 76988 More actions · Answer 9

Michael L John - Thursday, September 27, 2018 12:40 PM
Ray K - Tuesday, September 25, 2018 1:50 PM
YES!!! YES!!! YES!!! YES!!! YES!!! YES!!! YES!!! YES!!! THIS A BILLION TIMES YES!!! +10000000000000
This is why I am so passionate about the SQL Saturday presentations that I do. I preach documentation. Documentation is the ugly but critical stepchild when it comes to technology. I even have a 'blog article where I refer to it as the "Rodney Dangerfield of technical professions. It gets absolutely no respect. Nobody wants to do it, but your organization is doomed to failure without it.
There is no need for documentation when you are Agile, correct? If so, we are VERY Agile!

This is a logical fallacy called "Affirming the consequent."

Drew

J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 10

Michael L John - Thursday, September 27, 2018 12:40 PM
Ray K - Tuesday, September 25, 2018 1:50 PM
YES!!! YES!!! YES!!! YES!!! YES!!! YES!!! YES!!! YES!!! THIS A BILLION TIMES YES!!! +10000000000000
This is why I am so passionate about the SQL Saturday presentations that I do. I preach documentation. Documentation is the ugly but critical stepchild when it comes to technology. I even have a 'blog article where I refer to it as the "Rodney Dangerfield of technical professions. It gets absolutely no respect. Nobody wants to do it, but your organization is doomed to failure without it.
There is no need for documentation when you are Agile, correct? If so, we are VERY Agile!

Don't mix agile and volatile, two different things!
😎

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 11

Meeting friends in person for the first time, truly humbled!
😎

Resting on the shoulders of giants!

Ed, Michael and Jeff, thanks for the hospitality!

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 12

It was an absolute pleasure to meet you in person, Eirikur! Thanks for making the trip!

Sorry about my pictures... I actually was smiling! 😀

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

jasona.work SSC Guru Points: 50117 More actions · Answer 13

Phil Parkin - Thursday, September 27, 2018 12:44 PM
Doesn't DDL like this cause a conflict with your VCS?

How could it, the VCS hasn't shipped yet...

In all honesty, we don't have a VCS in my area. We're mostly concerned with providing the SQL Server service to the customers, who have their own VCS on their end for their applications / databases. What I'm looking to do is import the server-wide audit files to make it easier to query them when needed, without pulling them in at the time I need to look through them.

Michael L John One Orange Chip Points: 27056 More actions · Answer 14

Eirikur Eiriksson - Sunday, September 30, 2018 6:36 PM
Meeting friends in person for the first time, truly humbled!
😎

Resting on the shoulders of giants!

Ed, Michael and Jeff, thanks for the hospitality!

The pleasure was all mine!

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

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

Eirikur Eiriksson - Sunday, September 30, 2018 6:36 PM
Meeting friends in person for the first time, truly humbled!
😎

Resting on the shoulders of giants!

Ed, Michael and Jeff, thanks for the hospitality!

Thanks to Mike for the tour of Pittsburgh, even though it was a bit crazy at times. 😉
Eirikur, it was great to meet you in person. I feel honored that you'd make such a long trip. It was a very good weekend, but certainly not long enough.

Have a safe trip home, my friend.

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