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
GilaMonster
GilaMonster
SSC Guru
SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)

Group: General Forum Members
Points: 217127 Visits: 46278
thomashohner (5/4/2014)
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.


It'll probably be faster than an explicit loop. Slower than a proper set-based operation. That's because behind the scenes it is a loop.

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


thomashohner
thomashohner
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2512 Visits: 2306
[quote]
Do you use a While Loop or Recursive CTE to make your test data?[quote]

Niether, I spent this time researching how to do this and stumbled on a article by a very articulate fellow on this forum. However I do believe this comment may have been testing how ingnorant I am on the subject which incidentally is very much so.

Thanks look forward to putting your article in action.

http://www.sqlservercentral.com/articles/Data+Generation/87901/

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

Group: General Forum Members
Points: 208617 Visits: 41973
thomashohner (5/4/2014)
[quote]
Do you use a While Loop or Recursive CTE to make your test data?[quote]

Niether, I spent this time researching how to do this and stumbled on a article by a very articulate fellow on this forum. However I do believe this comment may have been testing how ingnorant I am on the subject which incidentally is very much so.

Thanks look forward to putting your article in action.

http://www.sqlservercentral.com/articles/Data+Generation/87901/



Shucks... first, thanks for the "attention to detail" on one of your previous posts above. And I also say "Thank you" for the very nice complement. Blush I'm humbled.

Shifting gears, it admittedly was a wee bit of a "test" to find out if you really meant that you already sussed the million row test table thing. If you were stuck on While Loops (mostly because of the poor functionality of RAND()) or rCTEs, I was going to suggest the very article that you posted back. Nicely done and good form on your part.

Just for convenience sake, here are the URLs for both of the "test data" articles.
http://www.sqlservercentral.com/articles/Data+Generation/87901/
http://www.sqlservercentral.com/articles/Test+Data/88964/

Last but not least and as you can see from the resposes that instantly popped up when you mentioned using rCTEs, here are a couple of articles to assist you in your research, if you haven't already come across them.
http://www.sqlservercentral.com/articles/T-SQL/74118/
http://www.sqlservercentral.com/articles/T-SQL/62867/

Getting back to the subject at hand and based on what's happened in this thread so far, I think you have the right attitude and will do very well whether it's something new or not. Never lose the nervousness. It's one of your best assets to drive you to success no matter what you do.

--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
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)

Group: General Forum Members
Points: 95721 Visits: 33013
You should be nervous.

You're talking about taking responsibility for what, in this modern age, is arguably the most valuable asset of many organizations, the data. If that doesn't scare the pants off you, you're probably not a good fit for the job.

I get nervous about every new job and every new situation in old jobs. But, how do you deal with the nervousness? Ignore it and plow forward? Run & hide? Or, acknowledge it and try to get as much information as you can so you can be better prepared so that you're mitigating the issue without dismissing it? Do that last thing and you'll be fine (most of the time).

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
SQL is delicious
SQL is delicious
SSC Veteran
SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)SSC Veteran (211 reputation)

Group: General Forum Members
Points: 211 Visits: 174
I'm always nervous, every time. One of my problems is that it's hard for me to articulate exactly how to do something in SQL, or explain it to other people...but if you put me in front of SQL Server with requirements, I'm totally fine. If you give me a query that's performing badly and tell me to make it run fast, I can almost always do that without too much difficulty.

But yeah...nervous? Every time, all the time. I feel like I never know enough.
thomashohner
thomashohner
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2512 Visits: 2306
@Jeff Moden thanks for the links this will be a huge benefit in being able to test several things I have been wanting to try. Especially testing different query techniques and the performance factor.

@Grant Fritchey I just hit my year anniversary recently of ever even hearing the word SQL. So everything makes me super nervous I suppose that will be around for a very long, long time. I also have your book on my reading stack on Amazon.

***SQL born on date Spring 2013:-)
herladygeekedness
herladygeekedness
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1306 Visits: 813
More than each new job makes me nervous, each new mystery I can't explain makes me nervous!!! Did I miss something small and stupid? Is this a whole new bug we haven't seen? What changed?

I figure that being nervous means that I care enough to not bugger it up and that counts. It would be easier to not give a damn, then I could be calm all day every day.

I've learned to live with it as part of the job. One thing to not do, however, is worry about what might go wrong overnight or while you are away on vacation. that's the kind of nervous that can eat you and is not healthy.

You're in good company, I didn't go to school for this, I rather fell into it a couple decades ago. Once you accept that you will never know and master everything, you'll be fine. Already being someone that can figure things out for themselves and uncover new resources to assist you in that endeavor, you are an excellent candidate for geekhood.
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (60K reputation)SSC Guru (60K reputation)SSC Guru (60K reputation)SSC Guru (60K reputation)SSC Guru (60K reputation)SSC Guru (60K reputation)SSC Guru (60K reputation)SSC Guru (60K reputation)

Group: General Forum Members
Points: 60477 Visits: 13297
I still get nervous for every new job/client/project.
It keeps me on the edge :-)


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
jshahan
jshahan
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1028 Visits: 2159
Worry as a virtue? Guess that qualifies me as a saint.

Seriously, these comments about worry as an asset from this group of posters is like therapy for me. It gives me permission to feel okay about my anxiety as I approach a new set of specs or even a Monday morning.

It is comforting to know that people with skill sets like yours share this demon. I’ll work to embrace it as you have.
Tom Thomson
Tom Thomson
One Orange Chip
One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)

Group: General Forum Members
Points: 25495 Visits: 12494
In the jobs that I enjoyed doing, when I hit something new, if I found I was sure I could handle it I immediately handed it on to a junior; if I was unsure of myself and worried about whether I could produce, I got on with it. If you are always challenged, you will be always unsure, always worried. If you aren't challenged, life is just too dull. Learning new things is fun, but you can never be sure you will manage to understand them until you have learnt the critical parts, so unsureness must be a sign that you are having fun.
Now that I'm pretty much retired I don't hit enough situations where I'm not sure I'm up to what I need to do. Maybe I need to unretire.

Tom

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