March 29, 2017 at 8:26 am
Thom A - Wednesday, March 29, 2017 8:12 AMConcerning that someone who has probably created at least 100 topics on this forum is now asking what ISNULL, MAX and CAST "means".
Thom, I urgently need your help with something. Can you explain what SELECT is and why I need it?
:Whistling:
March 29, 2017 at 8:27 am
Thom A - Wednesday, March 29, 2017 8:12 AMConcerning that someone who has probably created at least 100 topics on this forum is now asking what ISNULL, MAX and CAST "means".
Not when you go and look at some of those 100 topics.
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
March 29, 2017 at 8:31 am
GilaMonster - Wednesday, March 29, 2017 8:27 AMThom A - Wednesday, March 29, 2017 8:12 AMConcerning that someone who has probably created at least 100 topics on this forum is now asking what ISNULL, MAX and CAST "means".Not when you go and look at some of those 100 topics.
True, but after 100 topics, "one" would hope that they have learned.
Too optimistic? 🙂
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 29, 2017 at 8:42 am
Thom A - Wednesday, March 29, 2017 8:31 AMToo optimistic? 🙂
Yes.
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
March 29, 2017 at 8:45 am
Brandie Tarvin - Wednesday, March 29, 2017 8:26 AMThom A - Wednesday, March 29, 2017 8:12 AMConcerning that someone who has probably created at least 100 topics on this forum is now asking what ISNULL, MAX and CAST "means".Thom, I urgently need your help with something. Can you explain what SELECT is and why I need it?
:Whistling:
Um, is it bad if I ran this in production a week ago:UPDATE ANNUALSALARY SET SALARY = 'POTATO';
The bosses were saying something today about there being problems with this weeks payroll and we might not get paid...
Does what I did have anything to do with it?
:crazy::hehe:
March 29, 2017 at 8:51 am
jasona.work - Wednesday, March 29, 2017 8:45 AMBrandie Tarvin - Wednesday, March 29, 2017 8:26 AMThom A - Wednesday, March 29, 2017 8:12 AMConcerning that someone who has probably created at least 100 topics on this forum is now asking what ISNULL, MAX and CAST "means".Thom, I urgently need your help with something. Can you explain what SELECT is and why I need it?
:Whistling:
Um, is it bad if I ran this in production a week ago:
UPDATE ANNUALSALARY SET SALARY = 'POTATO';The bosses were saying something today about there being problems with this weeks payroll and we might not get paid...
Does what I did have anything to do with it?
:crazy::hehe:
I think the fact that it didn't error is the biggest problem. WHOOP!
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
March 29, 2017 at 8:54 am
Grant Fritchey - Wednesday, March 29, 2017 8:51 AMjasona.work - Wednesday, March 29, 2017 8:45 AMBrandie Tarvin - Wednesday, March 29, 2017 8:26 AMThom A - Wednesday, March 29, 2017 8:12 AMConcerning that someone who has probably created at least 100 topics on this forum is now asking what ISNULL, MAX and CAST "means".Thom, I urgently need your help with something. Can you explain what SELECT is and why I need it?
:Whistling:
Um, is it bad if I ran this in production a week ago:
UPDATE ANNUALSALARY SET SALARY = 'POTATO';The bosses were saying something today about there being problems with this weeks payroll and we might not get paid...
Does what I did have anything to do with it?
:crazy::hehe:I think the fact that it didn't error is the biggest problem. WHOOP!
How the heck did you get into our database, Jason?
Grant, there's a perfectly reasonable explanation for why it didn't error. I needed to update some salaries to "BAZILLION" and the money datatypes don't go that high.
March 29, 2017 at 8:56 am
jasona.work - Wednesday, March 29, 2017 8:45 AMUm, is it bad if I ran this in production a week ago:UPDATE ANNUALSALARY SET SALARY = 'POTATO';
OH don't get me started on that. Someone was asked to update the name of someone last week, as it had been entered incorrectly. The SQL?UPDATE misys_users
SET surname = 'Lapine';
Yeah... That took that software off line for good 30 minutes. We were scrambling to work out why no one could login, and they finally piped up 20 minutes later to tell us they may have "made a mistake"... To add insult to injury, Lapine was also not the correct spelling. :pinch:
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 29, 2017 at 8:59 am
Brandie Tarvin - Wednesday, March 29, 2017 8:26 AMThom A - Wednesday, March 29, 2017 8:12 AMConcerning that someone who has probably created at least 100 topics on this forum is now asking what ISNULL, MAX and CAST "means".Thom, I urgently need your help with something. Can you explain what SELECT is and why I need it?
:Whistling:
Apparently, we have to blame SQL Prompt for this :hehe::hehe:
March 29, 2017 at 9:10 am
Thom A - Wednesday, March 29, 2017 8:56 AMjasona.work - Wednesday, March 29, 2017 8:45 AMUm, is it bad if I ran this in production a week ago:UPDATE ANNUALSALARY SET SALARY = 'POTATO';OH don't get me started on that. Someone was asked to update the name of someone last week, as it had been entered incorrectly. The SQL?
UPDATE misys_users
SET surname = 'Lapine';
Yeah... That took that software off line for good 30 minutes. We were scrambling to work out why no one could login, and they finally piped up 20 minutes later to tell us they may have "made a mistake"... To add insult to injury, Lapine was also not the correct spelling. :pinch:
HAHA!!! This reminds me of very first job as a dev. I had to update the employee table to change somebody's name. I ran a very similar update statement without a where clause that was supposed to disable one users account but instead disabled the whole table. To pour salt on the wound they had a trigger on that table that checked to see if the account was disabled and if so, it used some sp_OACreate stuff (sql 7) and disable their AD account. I managed to disable the entire company's AD accounts. Close to 5,000 employees nation wide. It was a bit of a nightmare to say the least that took almost two days for the whole IT staff to unravel.
_______________________________________________________________
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/
March 29, 2017 at 9:26 am
Sean Lange - Wednesday, March 29, 2017 9:10 AMHAHA!!! This reminds me of very first job as a dev. I had to update the employee table to change somebody's name. I ran a very similar update statement without a where clause that was supposed to disable one users account but instead disabled the whole table. To pour salt on the wound they had a trigger on that table that checked to see if the account was disabled and if so, it used some sp_OACreate stuff (sql 7) and disable their AD account. I managed to disable the entire company's AD accounts. Close to 5,000 employees nation wide. It was a bit of a nightmare to say the least that took almost two days for the whole IT staff to unravel.
That's sounds like a barrel of laughs :hehe: It does, however, make me wonder why Dev was linked to the live AD 😛 Lessons learned from your mistakes I suppose 🙂
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 29, 2017 at 9:28 am
Thom A - Wednesday, March 29, 2017 8:31 AMGilaMonster - Wednesday, March 29, 2017 8:27 AMThom A - Wednesday, March 29, 2017 8:12 AMConcerning that someone who has probably created at least 100 topics on this forum is now asking what ISNULL, MAX and CAST "means".Not when you go and look at some of those 100 topics.
True, but after 100 topics, "one" would hope that they have learned.
Too optimistic? 🙂
Is this the multi-personality SS?
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
March 29, 2017 at 9:31 am
SQLRNNR - Wednesday, March 29, 2017 9:28 AMThom A - Wednesday, March 29, 2017 8:31 AMGilaMonster - Wednesday, March 29, 2017 8:27 AMThom A - Wednesday, March 29, 2017 8:12 AMConcerning that someone who has probably created at least 100 topics on this forum is now asking what ISNULL, MAX and CAST "means".Not when you go and look at some of those 100 topics.
True, but after 100 topics, "one" would hope that they have learned.
Too optimistic? 🙂
Is this the multi-personality SS?
No, he's way higher than 100 posts.
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
March 29, 2017 at 9:34 am
SQLRNNR - Wednesday, March 29, 2017 9:28 AMThom A - Wednesday, March 29, 2017 8:31 AMGilaMonster - Wednesday, March 29, 2017 8:27 AMThom A - Wednesday, March 29, 2017 8:12 AMConcerning that someone who has probably created at least 100 topics on this forum is now asking what ISNULL, MAX and CAST "means".Not when you go and look at some of those 100 topics.
True, but after 100 topics, "one" would hope that they have learned.
Too optimistic? 🙂
Is this the multi-personality SS?
As Thomas Rushton so eloquently put it, that's the Canine from Cymru.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 29, 2017 at 9:46 am
GilaMonster - Wednesday, March 29, 2017 9:31 AMSQLRNNR - Wednesday, March 29, 2017 9:28 AMThom A - Wednesday, March 29, 2017 8:31 AMGilaMonster - Wednesday, March 29, 2017 8:27 AMThom A - Wednesday, March 29, 2017 8:12 AMConcerning that someone who has probably created at least 100 topics on this forum is now asking what ISNULL, MAX and CAST "means".Not when you go and look at some of those 100 topics.
True, but after 100 topics, "one" would hope that they have learned.
Too optimistic? 🙂
Is this the multi-personality SS?
No, he's way higher than 100 posts.
I figured it was 100 unique topics and about 100 posts in each topic.
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
Viewing 15 posts - 57,931 through 57,945 (of 66,000 total)
You must be logged in to reply to this topic. Login to reply