SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


First SQl job were you nervous?


First SQl job were you nervous?

Author
Message
thomashohner
thomashohner
SSC Eights!
SSC Eights! (878 reputation)SSC Eights! (878 reputation)SSC Eights! (878 reputation)SSC Eights! (878 reputation)SSC Eights! (878 reputation)SSC Eights! (878 reputation)SSC Eights! (878 reputation)SSC Eights! (878 reputation)

Group: General Forum Members
Points: 878 Visits: 2283
I currently work in a health clinic as a Clinical Applictions Specialist. I do the training, configuring workflows and as of last spring the reporting. I started doing the reporting piece by chance. My boss hated doing the reports so we all know what happened here. Hey its your turn. He used Excel which I absolutley loathe. I discovered Sql Server and SSRS and fell head over heels in love! Needless to say because I had already mastered the front end of the app pulling the information out that our clinic request became very easy.

Here is my conundrum, I love Sql I read 100 pages on Triggers today alone, I'm studying for my first exam for the MCSA. However in the last 6 weeks I have been asked for my resume twice once from the vendor that I currently build reports from their db for our clinic and a third party company that works with the same db. They have already shared 4 of my reports with their community base. One of the senior developers at the third party company is who I feel is my mentor is one of those who asked for my res. My fear as I told him is that I dont feel good enough yet for the big boys.

Anyone else sometimes feel nervous that you wont measure up? They pay me well at my current job, just nervous about living up to expectations.
My favorite part of the day is F5w00t

Thoughts?

***SQL born on date Spring 2013:-)
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)

Group: General Forum Members
Points: 87412 Visits: 41113
If you're nervous about living up to expectations, then you're well on your way to being one of the "big boys". Keep reading about SQL Server. If you don't have the Developer's Edition on your home machine or laptop to play with, spend the less-than $65USD to get a copy. It's worth every cent. So is the nervousness. If the nervousness ever completely goes away, you have a problem.

I'll give you a little secret to success on the T-SQL side of things. If you can't easily make a million row test table at the drop of a hat (any hat) to test your code with, life will be a whole lot more difficult for you. Looking back, it's the one thing that has really made a huge difference in my career. As a man much wiser than I once said, "One good test is worth a thousand expert opinions" and he was correct.

--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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
thomashohner
thomashohner
SSC Eights!
SSC Eights! (878 reputation)SSC Eights! (878 reputation)SSC Eights! (878 reputation)SSC Eights! (878 reputation)SSC Eights! (878 reputation)SSC Eights! (878 reputation)SSC Eights! (878 reputation)SSC Eights! (878 reputation)

Group: General Forum Members
Points: 878 Visits: 2283
Thanks so much for your reply Mr. Modden. I got the Developer edition a while back when I knew there were things I wanted to play with that I best not do on our production server. What a great deal on that software! Got mine for $44 Amazon Prime. I have a half a dozen db's now on my laptop. Such as, Adventure Works, JProco( Currently doing the Joes2Pros series labs from Rick Morlean) and several I have created. I even have one named after the wife Hehe. Along with the books and labs I'm working on I also try to make a point of reading at least 1-2 SQL blogs or articles a week.


On the million record test data... I know what I'm doing today:-D

Thanks again,

Thomas

***SQL born on date Spring 2013:-)
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)

Group: General Forum Members
Points: 87412 Visits: 41113
thomashohner (5/4/2014)
On the million record test data... I know what I'm doing today:-D


Do you use a While Loop or Recursive CTE to make your test data?

Thanks so much for your reply Mr. Modden.


Heh... just a tip from an old dude that has seen a whole lot of water pass under the proverbial bridge... THAT's the one thing that you should absolutely sweat bullets over. While it's good to be humble and thankful, spell the name of your boss, other higher-up, or even a peer incorrectly and see how many points you earn especially if the name has only 5 characters in it. ;-) Personally, I'm not insulted outside the work-place but wanted to tell you that a whole lot of people are much more sensitive to it. I've found that such a simple faux paux in communications will cause many higher-ups to think "Gee... what kind of attention-to-detail does the person really have when they won't even take the time to spell my name correctly?' I also take the time to learn to pronounce even difficult names correctly. While some claim to understand and accept mispronunciation of their complex names simply because they are complex, you can really get their attention and develop incredible working relationships just by taking the time to show them they're important enough to learn to pronounce their difficult name correctly.

--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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Eirikur Eiriksson
Eirikur Eiriksson
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: General Forum Members
Points: 15328 Visits: 18612
Throwing in my nickles worth, first on the operation side; draw up your worst case scenarios, then think of few ways to make them even worse, how you would tackle those (not including UCR (update CV and Relocate)) and play through those until you are comfortable with it.
On the development, draw a list of things that's commonly referred to as "no can do" in SQL and (work on) solve those!
Cool
thomashohner
thomashohner
SSC Eights!
SSC Eights! (878 reputation)SSC Eights! (878 reputation)SSC Eights! (878 reputation)SSC Eights! (878 reputation)SSC Eights! (878 reputation)SSC Eights! (878 reputation)SSC Eights! (878 reputation)SSC Eights! (878 reputation)

Group: General Forum Members
Points: 878 Visits: 2283
@ Mr. Moden, My apologies I guess misspelling your name is not illustrating attention for detail.Blush

I think I will give a Recursive CTE a try since I have a book on CTE's that I have been itching to crack open.

***SQL born on date Spring 2013:-)
thomashohner
thomashohner
SSC Eights!
SSC Eights! (878 reputation)SSC Eights! (878 reputation)SSC Eights! (878 reputation)SSC Eights! (878 reputation)SSC Eights! (878 reputation)SSC Eights! (878 reputation)SSC Eights! (878 reputation)SSC Eights! (878 reputation)

Group: General Forum Members
Points: 878 Visits: 2283
@Eirikur Eiriksson sounds like great ideas to me!

***SQL born on date Spring 2013:-)
GilaMonster
GilaMonster
SSC Guru
SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)

Group: General Forum Members
Points: 88427 Visits: 45284
thomashohner (5/3/2014)
Anyone else sometimes feel nervous that you wont measure up?


Yup. With every new client.

I think I will give a Recursive CTE a try since I have a book on CTE's that I have been itching to crack open.


Cool, and when you do so take note of how incredibly badly it performs.

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


Eirikur Eiriksson
Eirikur Eiriksson
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: General Forum Members
Points: 15328 Visits: 18612
GilaMonster (5/4/2014)
Cool, and when you do so take note of how incredibly badly it performs.


In my books, having to use recursive CTEs qualifies as worst case scenario, do explore the alternatives!
Cool
thomashohner
thomashohner
SSC Eights!
SSC Eights! (878 reputation)SSC Eights! (878 reputation)SSC Eights! (878 reputation)SSC Eights! (878 reputation)SSC Eights! (878 reputation)SSC Eights! (878 reputation)SSC Eights! (878 reputation)SSC Eights! (878 reputation)

Group: General Forum Members
Points: 878 Visits: 2283
I did a Google search and yes the Recursive CTE does seem to have a HUGE performace disadvantage compared to a Loop. I'm still very new at this so my next question to research and understand is why.

Off the top of my head is it because a CTE is a derived table and it will have to go back and scan itself over and over to calculate the next proceeding values?

***SQL born on date Spring 2013:-)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search