Are the posted questions getting worse?

Question

Post reply

Are the posted questions getting worse?

Viewing 15 posts - 57,541 through 57,555 (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

Is this a little backwards or is it just me?

Staples has an online coupon that gives $50 off a Dell PC if you purchase a Dell Monitor.

That used to be the other way around, didn't 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.

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

Brandie Tarvin - Friday, February 24, 2017 12:24 PM
Is this a little backwards or is it just me?
Staples has an online coupon that gives $50 off a Dell PC if you purchase a Dell Monitor.
That used to be the other way around, didn't it?

Maybe they expect less coupons redeemed this way.

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 3

Brandie Tarvin - Friday, February 24, 2017 11:53 AM
jasona.work - Friday, February 24, 2017 10:04 AM
Well, this could have some interesting implications for sysadmins: https://www.theregister.co.uk/2017/02/23/michael_thomas_appeals_conviction/
"I was authorized to trash my employer's network, sysadmin tells court"
Regardless of whether the guy wins or loses his appeal...
Ouch. That is really going to cause issues in a lot of places.

Interesting. Must be a Progressive lawyer with no common sense. I can see changes in employment agreements whether he wins or loses. Companies will want to protect themselves regardless of the outcome of the appeal. If I were a business owner or C-level employee I would do what was reasonably needed to protect the business.

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

On something completely different, I was just looking at an internal database built by a developer. If I posted this database schema here you would see Mr. Celko galloping in on his white horse. Every table has a primary key with the name "id".
Actually, I can see his point on this one as I am looking at this database.

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

Lynn Pettis - Friday, February 24, 2017 1:14 PM
Brandie Tarvin - Friday, February 24, 2017 11:53 AM
jasona.work - Friday, February 24, 2017 10:04 AM
Well, this could have some interesting implications for sysadmins: https://www.theregister.co.uk/2017/02/23/michael_thomas_appeals_conviction/
"I was authorized to trash my employer's network, sysadmin tells court"
Regardless of whether the guy wins or loses his appeal...
Ouch. That is really going to cause issues in a lot of places.
Interesting. Must be a Progressive lawyer with no common sense. I can see changes in employment agreements whether he wins or loses. Companies will want to protect themselves regardless of the outcome of the appeal. If I were a business owner or C-level employee I would do what was reasonably needed to protect the business.

I read through the first 30-40 pages of the appeal that was filed and sure enough it consistently refers to the words "without authorization". Simply because this person had the security clearance to do these things it is clear that this person was acting with retribution and attempt to hurt their business. The steps taken while are clearly part of the every day doings add up to nothing short of premeditated malice. It makes things so vague that it will have a large impact on the contracts that employee and employer have to negotiate. Truly sad that this was even allowed to be filed, even more pathetic is I have a gut feeling this guy is going to walk away from this.

_______________________________________________________________

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/

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

Lynn Pettis - Friday, February 24, 2017 1:19 PM
On something completely different, I was just looking at an internal database built by a developer. If I posted this database schema here you would see Mr. Celko galloping in on his white horse. Every table has a primary key with the name "id".
Actually, I can see his point on this one as I am looking at this database.

Having every table with a primary key name of id is one of the things that I totally agree with Joe on. It is just awful. It forces one of my biggest pet peeves in data design which is a single piece of information (column) having different names across the system. And everything being id forces that for sure. If it is a PersonID it should be a PersonID in every single table. Sure it makes Person.PersonID a little redundant but better than weird predicates like "p.ID = someOtherTable.PersonID". 😀

_______________________________________________________________

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 7

Sean Lange - Friday, February 24, 2017 1:30 PM
Lynn Pettis - Friday, February 24, 2017 1:19 PM
On something completely different, I was just looking at an internal database built by a developer. If I posted this database schema here you would see Mr. Celko galloping in on his white horse. Every table has a primary key with the name "id".
Actually, I can see his point on this one as I am looking at this database.
Having every table with a primary key name of id is one of the things that I totally agree with Joe on. It is just awful. It forces one of my biggest pet peeves in data design which is a single piece of information (column) having different names across the system. And everything being id forces that for sure. If it is a PersonID it should be a PersonID in every single table. Sure it makes Person.PersonID a little redundant but better than weird predicates like "p.ID = someOtherTable.PersonID". 😀

Sean, I am actually agreeing with you and Joe on this, just that if I posted he'd ride in on his white horse and beat me over the head.

Also, I have a feeling this may have been partly done through the tool they used to build the database and application code. I may be wrong, however.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

Lynn Pettis - Tuesday, October 11, 2016 1:26 PM
Ever get the feeling that you are being used to do someone else's job for free?

Hahahaha - all the time.

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

Ed Wagner - Wednesday, October 12, 2016 7:55 AM
Sean Lange (10/12/2016)
Grant Fritchey (10/12/2016)
jasona.work (10/12/2016)
Now this sounds like it has an interesting story behind it...
Grant Fritchey (10/12/2016)
I'm the guy who helped a developer send porn to our client list (I didn't clean up prod data before supplying it to the dev team, a lot of very long meetings followed).
(Original topic over here, if you're interested)
That's about the whole story. I was supplying production data to the devs, as per usual. We didn't have a policy in place to clean the data first and it was early in my career as a DBA. Said developer had a sense of humor. He was testing email automation through one of our apps and used the email addresses in the database. He sent a porn picture as his test. Insane, long-*** meetings followed. Huzzah!
Well accidents do happen like forgetting to cleanse the data. But sending porn through the company email system, even as a joke, is wholly inexcusable. That would be grounds for instant termination in any company I have worked for. I can only imagine the meetings afterwards and the communications sent to your customers/clients. :w00t:
Yeah - definite grounds for termination. I must admit that's one reason to anonymize test data that I never even considered.

LMAO
:hehe:

I wonder how many other times this has happened?

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

Sean Lange - Thursday, October 13, 2016 7:49 AM
WOW...http://www.sql-datatools.com/2016/05/sql-queries-tuning-and-optimization.htmlThis is supposed to be a list of things to do to optimize queries. While some of these are valid most of them lack context or explanation. And some of them are just plain awful. :sick:

I know it is really old, but I am catching up.

Did you notice the paypal on it asking for donations?

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

Lynn Pettis - Thursday, October 20, 2016 8:16 AM
Brandie Tarvin (10/20/2016)
jasona.work (10/20/2016)
Brandie Tarvin (10/20/2016)
I don't quite feel your pain, but I'm in the midst of migrating a handful of DBs to a new server. One is ~134GB of data, the DBs are all TDE'ed, and I don't have (and couldn't get in the time available) enough room on the source server to run a backup to. So I'm backing up across the network to the new server...At least I've got an all-day window to do this, but it gets boring watching the percentages...
Tell me about it. I've had to do that before. And then, right at the last minute, the backup fails because of a network error.
I swear, if you've jinxed me on this...I have a very particular set of skills, skills I have acquired over a very long career. Skills that make me a nightmare for people like you. If you un-jinx me right now, you will never hear from me again. But if you leave me jinxed, I will find you, and I will feed you to the hippo.:hehe:
Ummm. Oh, wait. I still have a pork chop launcher... BRING IT ON!:w00t:
Watch it, you two, or I'll have to let the Hippo deal with you both!

The hippo is back!

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

Chad Crawford - Friday, October 28, 2016 1:32 PM
Well, the summit has been good to me this year. I participated in many good sessions, including those by Grant, Gail, Wayne and Hugo (you all did GREAT! 6.0/5.0 stars :cool:). If I missed anyone on the thread who presented, let me know - when I get the downloads I plan to watch several that I was not able to attend.Chad

Chad forgot to mention his presentation that week!!!!

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

TomThomson SSC Guru Points: 104773 More actions · Answer 13

Ed Wagner - Thursday, February 16, 2017 12:45 PM
Lynn Pettis - Thursday, February 16, 2017 11:44 AM
Ed Wagner - Wednesday, February 15, 2017 5:30 PM
Alas, the berating and general abuse continues. Resistance is not futile. Must...resist.
Do I ask where?
https://www.sqlservercentral.com/Forums/FindPost1858856.aspx
I failed to resist. :crazy:

That is actually quite a useful post from JOE - it gives a pretty clear picture of some of the holes you'll fall into if you insist on one true lookup table. It pushes some of the deplorable aspects of the SQL standards too, but in a fairly harmless manner in the context of the rest of the post. And unlike many of Joe's posts, the idea that it might be a good idea to provide code in standard SQL is put as a polite request instead of as an insulting rant. He should be encouraged to post like this instead of using his adopted style of ranting.

Tom

TomThomson SSC Guru Points: 104773 More actions · Answer 14

GilaMonster - Friday, February 24, 2017 2:10 AM
Steve Jones - SSC Editor - Thursday, February 23, 2017 4:05 PM
It's cold and snowy. That's the reason.
Overcast, raining and cold. And it's still summer here. 🙁

28C on the beach this aftenoon, nice cool breeze, it's still winter here. 🙂

Tom

SQLRNNR SSC Guru Points: 281334 More actions · Answer 15

Steve Jones - SSC Editor - Tuesday, November 22, 2016 9:50 AM
Have to drop this here, since I'm proud.My son completed his Board of Review last night to earn his Eagle Scout rank. It's been a long journey, but he's finally done.

Late I know.

Welcome to the Eagle's Nest.

Congrats to Mom and Dad just as much to your son!

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