<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
T-SQL (SS2K5)
»
Mentor
55 posts, Page 1 of 6
1
2
3
4
5
»
»»
Mentor
Rate Topic
Display Mode
Topic Options
Author
Message
john-902052
john-902052
Posted Friday, June 11, 2010 3:12 PM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, May 10, 2013 6:46 AM
Points: 86,
Visits: 145
I have been working with T-SQL for a few months now fulltime and have learned some of the things that I need. I would like to take my skills to the next level and was wondering if anyone would be interested in helping me?
Post #936326
Jeff Moden
Jeff Moden
Posted Friday, June 11, 2010 3:20 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 5:13 AM
Points: 32,906,
Visits: 26,793
Which part of the world do you hail from?
--Jeff Moden
"
RBAR
is pronounced "ree-bar" and is a "Modenism" for "
R
ow-
B
y-
A
gonizing-
R
ow".
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."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #936332
john-902052
john-902052
Posted Friday, June 11, 2010 3:28 PM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, May 10, 2013 6:46 AM
Points: 86,
Visits: 145
Los Angeles area of California.
Post #936337
LutzM
LutzM
Posted Friday, June 11, 2010 3:31 PM
SSCertifiable
Group: General Forum Members
Last Login: Wednesday, April 24, 2013 3:17 PM
Points: 6,731,
Visits: 12,131
john-902052 (6/11/2010)
I have been working with T-SQL for a few months now fulltime and have learned some of the things that I need. I would like to take my skills to the next level and was wondering if anyone would be interested in helping me?
Why just select a single person?
If you decide to hang around here for a while there will be hundred's if not thousand's of SQL Pro's willing to help you.
The SSC community has been (and still is) the best mentor I ever had!
And the best part of it: you'll get more than one opinion / option.
I would consider a mentor as an "add-on"...
Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question
How to post performance related questions
Links for
Tally Table
,
Cross Tabs
and
Dynamic Cross Tabs
,
Delimited Split Function
Post #936339
john-902052
john-902052
Posted Friday, June 11, 2010 3:35 PM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, May 10, 2013 6:46 AM
Points: 86,
Visits: 145
Because I want to get to know the person and go deep with the topic. Here people may or may not answer and only will work against a small defined problem that won't get me to the level of learning that I am after. I can read books to solve individual select problems, it is those problems that require experience and insight that I am after.
Post #936343
LutzM
LutzM
Posted Friday, June 11, 2010 4:14 PM
SSCertifiable
Group: General Forum Members
Last Login: Wednesday, April 24, 2013 3:17 PM
Points: 6,731,
Visits: 12,131
john-902052 (6/11/2010)
Because I want to get to know the person and go deep with the topic. Here people may or may not answer and only will work against a small defined problem that won't get me to the level of learning that I am after. I can read books to solve individual select problems, it is those problems that require experience and insight that I am after.
I partly agree. I disagree that learning how to solve small defined problems aren't a way to take the skills to the next level.
Insight provided by experienced SQL pro's is something you can get from this site. But I agree, it might not be to the extent you're after, since posts are limited to just written (and sometimes short) explanation. Articles and blogs will be more detailed, but again, "just text".
Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question
How to post performance related questions
Links for
Tally Table
,
Cross Tabs
and
Dynamic Cross Tabs
,
Delimited Split Function
Post #936355
scott.pletcher
scott.pletcher
Posted Friday, June 11, 2010 4:14 PM
SSC Veteran
Group: General Forum Members
Last Login: Friday, December 31, 2010 9:46 AM
Points: 274,
Visits: 473
Look for articles/books by Itzik Ben-Gan. He is
great
with T-SQL (I think's that his entire job
).
I also liked Ken Henderson's stuff, particularly "The Guru's Guide to Transact-SQL". I don't know if/what the latest release/version of this is.
Finally, search the net for "T-SQL challenges", try coding them -- before reading their solution(s) of course
.
If you want a quick simple
SQL not
T
-SQL
challenge, try this:
A studentgrade table has one row per student and test. Each student may have taken anywhere from 0 to 3 (
never more
) tests.
studentgrade --> (studid int, test# int, score int)
Write a
single
query -- no subqueries, joins, CTEs, etc. -- that lists:
studentid
# of tests taken
hi score (if only one test, it shows here)
mid score (if only two tests, 2nd shows here; if only one test, will be null)
low score (will only be non-null if all 3 tests are found for that student)
Scott Pletcher, SQL Server MVP 2008-2010
Post #936356
Jeff Moden
Jeff Moden
Posted Friday, June 11, 2010 4:31 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 5:13 AM
Points: 32,906,
Visits: 26,793
I don't like those challenges because they teach the wrong thing. There are many times where the resolution of a problem using a single query is just flat out the wrong thing to do for scalability and/or performance.
--Jeff Moden
"
RBAR
is pronounced "ree-bar" and is a "Modenism" for "
R
ow-
B
y-
A
gonizing-
R
ow".
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."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #936358
Jeff Moden
Jeff Moden
Posted Friday, June 11, 2010 4:33 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 5:13 AM
Points: 32,906,
Visits: 26,793
john-902052 (6/11/2010)
Because I want to get to know the person and go deep with the topic. Here people may or may not answer and only will work against a small defined problem that won't get me to the level of learning that I am after. I can read books to solve individual select problems, it is those problems that require experience and insight that I am after.
There is a huge difference between an occasional mentor and a private instructor.
--Jeff Moden
"
RBAR
is pronounced "ree-bar" and is a "Modenism" for "
R
ow-
B
y-
A
gonizing-
R
ow".
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."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #936359
scott.pletcher
scott.pletcher
Posted Friday, June 11, 2010 4:35 PM
SSC Veteran
Group: General Forum Members
Last Login: Friday, December 31, 2010 9:46 AM
Points: 274,
Visits: 473
I would think in this situation a single query would be the most efficient. I/O (physical
and logical
) are the real culprit in performance more than 90% of the time.
Although of course it's also a challenge, so the idea is to think a little about everything you have available in a single query.
This not a killer challenge -- it requires some thought, but it's not a back-breaker.
Scott Pletcher, SQL Server MVP 2008-2010
Post #936361
« Prev Topic
|
Next Topic »
55 posts, Page 1 of 6
1
2
3
4
5
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
