August 19, 2016 at 9:28 am
I have once again learned the value of being part of a SQL forum. Specifically this site.
New project. Take a feed I already created and make sure that payments are properly accounted for when checks are voided. Sounds easy. Why not take the time to pass it by the forum to see if there would be an easier / better performing way to do the queries or if what I had was good enough.
Wrote up the DDL, sample data, etc. Started on the queries. Stopped. Started again from the other direction. Suddenly realized I was missing a link (or perhaps several) between the check table and the tables I've always been pulling from.
If I hadn't seen the "post the DDL, sample data, desired results, and *what you've already coded*" mantra so many times, I would never have sat down, trying to scrub the data, and realizing there was a bigger problem I had to resolve before I even got to the "is this code good enough or does anyone have a better way of writing this query" question.
Thank you all for being there and insisting on basic forum standards. @=)
August 19, 2016 at 9:30 am
Brandie Tarvin (8/19/2016)
Lynn Pettis (8/19/2016)
And then we have people that think they can learn our job from a book.blink
blinkblink
Ummmm, that's how I learned it. Books and a small PC and doing the exercises in the books. Does that make me a not-a-dba?
Not at all. First of all you have plural books. And you used a pc to do the exercises. The person Lynn is referring to is a post where they seem to want a book to change careers. If it were only that simple.
_______________________________________________________________
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/
August 19, 2016 at 10:08 am
Brandie Tarvin (8/19/2016)
Lynn Pettis (8/19/2016)
And then we have people that think they can learn our job from a book.blink
blinkblink
Ummmm, that's how I learned it. Books and a small PC and doing the exercises in the books. Does that make me a not-a-dba?
You didn't learn just from a book. I have read your story about how you moved from retail to IT.
August 19, 2016 at 10:14 am
Brandie Tarvin (8/19/2016)
I have once again learned the value of being part of a SQL forum. Specifically this site.New project. Take a feed I already created and make sure that payments are properly accounted for when checks are voided. Sounds easy. Why not take the time to pass it by the forum to see if there would be an easier / better performing way to do the queries or if what I had was good enough.
Wrote up the DDL, sample data, etc. Started on the queries. Stopped. Started again from the other direction. Suddenly realized I was missing a link (or perhaps several) between the check table and the tables I've always been pulling from.
If I hadn't seen the "post the DDL, sample data, desired results, and *what you've already coded*" mantra so many times, I would never have sat down, trying to scrub the data, and realizing there was a bigger problem I had to resolve before I even got to the "is this code good enough or does anyone have a better way of writing this query" question.
Thank you all for being there and insisting on basic forum standards. @=)
Brandie, you are not the first, nor will you be the last, to see the power behind that mantra. It is amazing how things become clearer when you are trying to setup a scenario for others to work with to help solve a problem or enhance a SQL query, procedure, function, etc.
I can actually remember a couple of questions where I asked for that information and the OP found their problem while doing just what you said you were doing.
August 19, 2016 at 10:16 am
Sean Lange (8/19/2016)
Brandie Tarvin (8/19/2016)
Lynn Pettis (8/19/2016)
And then we have people that think they can learn our job from a book.blink
blinkblink
Ummmm, that's how I learned it. Books and a small PC and doing the exercises in the books. Does that make me a not-a-dba?
Not at all. First of all you have plural books. And you used a pc to do the exercises. The person Lynn is referring to is a post where they seem to want a book to change careers. If it were only that simple.
And more importantly, they want books written by Indian authors so they can understand it better.
August 19, 2016 at 10:20 am
Lynn Pettis (8/19/2016)
Sean Lange (8/19/2016)
Brandie Tarvin (8/19/2016)
Lynn Pettis (8/19/2016)
And then we have people that think they can learn our job from a book.blink
blinkblink
Ummmm, that's how I learned it. Books and a small PC and doing the exercises in the books. Does that make me a not-a-dba?
Not at all. First of all you have plural books. And you used a pc to do the exercises. The person Lynn is referring to is a post where they seem to want a book to change careers. If it were only that simple.
And more importantly, they want books written by Indian authors so they can understand it better.
And thank you all for the good advice you passed on. I didn't have time when I first saw the post to put some thought into a response as I also had to run of a to a meeting I almost forgot about. Good thing people around me started say "Time for a meeting."
August 19, 2016 at 10:39 am
!!!!
https://www.pluralsight.com/courses/identifying-fixing-performance-issues-caused-parameter-sniffing
And massive amount of work it was too. Recording's the easy part. Scripting is the most time consuming, editing probably the most difficult.
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
August 19, 2016 at 10:49 am
GilaMonster (8/19/2016)
!!!!https://www.pluralsight.com/courses/identifying-fixing-performance-issues-caused-parameter-sniffing
And massive amount of work it was too. Recording's the easy part. Scripting is the most time consuming, editing probably the most difficult.
Congrats!
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 19, 2016 at 11:00 am
GilaMonster (8/19/2016)
!!!!https://www.pluralsight.com/courses/identifying-fixing-performance-issues-caused-parameter-sniffing
And massive amount of work it was too. Recording's the easy part. Scripting is the most time consuming, editing probably the most difficult.
Congrats! Nice accomplishment.
Is this one of their paid courses?
August 19, 2016 at 11:20 am
GilaMonster (8/19/2016)
!!!!https://www.pluralsight.com/courses/identifying-fixing-performance-issues-caused-parameter-sniffing
And massive amount of work it was too. Recording's the easy part. Scripting is the most time consuming, editing probably the most difficult.
Excellent. Another one to watch.
August 19, 2016 at 11:55 am
GilaMonster (8/19/2016)
!!!!https://www.pluralsight.com/courses/identifying-fixing-performance-issues-caused-parameter-sniffing
And massive amount of work it was too. Recording's the easy part. Scripting is the most time consuming, editing probably the most difficult.
Congrats!!! That is quite an accomplishment!!!
_______________________________________________________________
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/
August 19, 2016 at 12:24 pm
Jeff Moden (8/19/2016)
Heh... Cross out the "S" and the "E" and it makes a word that comes from the same animal as "pork chop". 😀
Yeah right, Jeff, "Ham and pork comes from the same wonderful magical creature." Next you'll tell us we can get bacon from it too!
😛
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 19, 2016 at 12:27 pm
RBarryYoung (8/19/2016)
Jeff Moden (8/19/2016)
Heh... Cross out the "S" and the "E" and it makes a word that comes from the same animal as "pork chop". 😀
Yeah right, Jeff, "Ham and pork comes from the same wonderful magical creature." Next you'll tell us we can get bacon from it too!
😛
And don't forget the shoulder - that's just pulled pork waiting to happen. All you need is smoke, heat, rub and time. 😀
August 19, 2016 at 12:28 pm
GilaMonster (8/19/2016)
!!!!https://www.pluralsight.com/courses/identifying-fixing-performance-issues-caused-parameter-sniffing
And massive amount of work it was too. Recording's the easy part. Scripting is the most time consuming, editing probably the most difficult.
Congratulations, Gail. Now if only I had a subscription so I could watch in. :crazy:
August 19, 2016 at 12:32 pm
Ed Wagner (8/19/2016)
RBarryYoung (8/19/2016)
Jeff Moden (8/19/2016)
Heh... Cross out the "S" and the "E" and it makes a word that comes from the same animal as "pork chop". 😀
Yeah right, Jeff, "Ham and pork comes from the same wonderful magical creature." Next you'll tell us we can get bacon from it too!
😛
And don't forget the shoulder - that's just pulled pork waiting to happen. All you need is smoke, heat, rub and time. 😀
And the ribs, skin, loin, oh heck...the list of delicious pork pieces goes on and on.
_______________________________________________________________
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/
Viewing 15 posts - 55,411 through 55,425 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply