Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

First SQl job were you nervous? Expand / Collapse
Author
Message
Posted Saturday, May 3, 2014 6:58 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 9:38 PM
Points: 138, Visits: 811
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 F5

Thoughts?




***SQL born on date Spring 2013
Post #1567305
Posted Sunday, May 4, 2014 12:02 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 7:56 PM
Points: 36,775, Visits: 31,230
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1567314
Posted Sunday, May 4, 2014 12:01 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 9:38 PM
Points: 138, Visits: 811
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 . 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

Thanks again,

Thomas




***SQL born on date Spring 2013
Post #1567347
Posted Sunday, May 4, 2014 12:23 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 7:56 PM
Points: 36,775, Visits: 31,230
thomashohner (5/4/2014)
On the million record test data... I know what I'm doing today


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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1567350
Posted Sunday, May 4, 2014 12:33 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 2:16 AM
Points: 1,309, Visits: 3,751
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!
Post #1567352
Posted Sunday, May 4, 2014 12:58 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 9:38 PM
Points: 138, Visits: 811
@ Mr. Moden, My apologies I guess misspelling your name is not illustrating attention for detail.

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
Post #1567354
Posted Sunday, May 4, 2014 1:03 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 9:38 PM
Points: 138, Visits: 811
@Eirikur Eiriksson sounds like great ideas to me!



***SQL born on date Spring 2013
Post #1567356
Posted Sunday, May 4, 2014 1:10 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:21 AM
Points: 42,466, Visits: 35,534
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 2008, MVP
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

Post #1567358
Posted Sunday, May 4, 2014 1:14 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 2:16 AM
Points: 1,309, Visits: 3,751
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!
Post #1567361
Posted Sunday, May 4, 2014 1:25 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 9:38 PM
Points: 138, Visits: 811
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
Post #1567362
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse