Tutorial/Tips on writing SPs that are fast and upto standards of development

Question

Tutorial/Tips on writing SPs that are fast and upto standards of development

Viewing 15 posts - 16 through 30 (of 54 total)

You must be logged in to reply to this topic. Login to reply

David Benoit SSC-Dedicated Points: 34562 More actions · Answer 1

GilaMonster (2/2/2009)
DavidB (2/2/2009)
I'm sure all that have posted to this thread would be happy to provide some suggestions on what you have in place currently.
Oh, absolutely! The comment about prices wasn't saying we won't help. We're happy to help.
It was just saying that if you want telephonic assistance, or x days of work from someone here, you're going to have to pay for it.

Indeed! All you guys with the mega thousands of posts certainly don't need to state that. You guys are awesome! Just didn't want the OP to look past that.

Thank you!

David

@SQLTentmaker

“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

Just remember that the help you get here is free, so don't get impatient if you don't get a response right away. We do this to help out our community, but we also have our own jobs to do as well.

idrees.butt SSC Enthusiast Points: 108 More actions · Answer 3

This might be not related! but I was not a good student at all during my BS. I am the boss by the way now 🙂 so I dont have to talk to anyone to buy the books! thats why I am abit worried about the costs...otherwise I would have got all of them hehe

So I want to become like all of you! In the field of Database! I like working on it... Consider me as a student of your and guide me...give me work/stuff to do/read so that I can offer reliable services to my future clients.

I understood all your points. I will keep them in mind...

idrees.butt SSC Enthusiast Points: 108 More actions · Answer 4

One more thing is that I am good in requirement analysis and managing teams. I charge well below than what some of you may charge! I dont even feel like mentioning that...

But I am pretty weak in technical aspects and I hope in your 'company' (if some of you may be interested in teaching every now and then by sharing experience or recommending readings) on this forum I will become good enough in a quarter or so! I really dream that one day I may be writing an article!!! 🙂

GSquared SSC Guru Points: 260824 More actions · Answer 5

Go for it. Might take more than a quarter, so don't be disappointed if you aren't up to Jeff Moden's or Gail's skill level by that time.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 6

And you don't have to wait until you are a "Jeff" or "Gail" to write an article. I don't pretend to be at their level and I have written 2 articles to date and I am actually working on at least 2 more now.

Ron McCullough SSC Guru Points: 63877 More actions · Answer 7

Idress.butt
As per you suggestion on using SQL Profiler! the situation is that we are hosting our Site on a dedicated server but we are using the SQL Server (shared) that our hosting company offers to avoid licensing primarily! Is there anyway we can still use SQL Profiler?

A thought - you may want to purchase a copy of SQL Server DEVELOPER edition and use it on your machine at work or at home.

My last search of the web at www.shop.com listed multiple sites for the software at:

SQL 2005 - $49.95 (USD) and SQL 2008 - $44.24 (USD) just about the price of a good book. The developer edition will do anything that can be done, and your practicing using it will not interfere with production or the hosting site. When you have tested improvements on the Developer edition, then you can upload them to your hosted server. And and this I think is important, if you make a major goof no harm done except to your pride.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 8

GSquared (2/2/2009)
Go for it. Might take more than a quarter, so don't be disappointed if you aren't up to Jeff Moden's or Gail's skill level by that time.

:blush: Heh... thanks Gus, bit it's more along the lines of "dedication" than anything else. 😉 You know the difference between being "loyal" to something and being "dedicated" to something, don't you? Ya gotta think "ham'n'eggs"...

The chicken was loyal...

... the pig was dedicated. 😛

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

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Max-146500 SSCarpal Tunnel Points: 4691 More actions · Answer 9

Jeff Moden (2/2/2009)
The chicken was loyal...
... the pig was dedicated. 😛

Only problem was that the pig didn't last that long - minor omission though, everyone give Jeff a round of applause. :w00t:

Max

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 10

Max (2/2/2009)
Jeff Moden (2/2/2009)
The chicken was loyal...
... the pig was dedicated. 😛
Only problem was that the pig didn't last that long - minor omission though, everyone give Jeff a round of applause. :w00t:

Heh... Where do you think the pork chops actually come from, Max? 😉

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

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

idrees.butt SSC Enthusiast Points: 108 More actions · Answer 11

Well you peope lost me!!!

I am not only bad in SQL but also bad in getting jokes!

I am just trying to locate books!!!! this way or that way!!! (we find books here for low price)

my target is to either do this rewamp till end of march or hire someone for a month or less depending upon the experties in next month if I see that its out of my range!

also I will post SOMETHING in case I am the one finishing my work! 🙂 if nothing then a best practice on how to rewamp :p

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 12

Go for it. 😉

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

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 13

idrees.butt (2/2/2009)
Can you tell some articles that list common mistakes?

http://www.sqlservercentral.com/Forums/Topic627665-338-1.aspx

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

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 14

... and, if your programs are running slowly, the best tip I can give you is to make the paradigm shift from thinking in rows (RBAR) to thinking in set of data organized in columns. Loosely stated, the required pardigm shift is to stop thinking about what you want to do to a row and start thinking about what you want to do to a column. Any form of RBAR including most Triangular Joins, Cursors, While Loops, many UDF's, and all forms of recursion are performance and resource killers. Of course, there are always exceptions to the rule, but RBAR is the first normal form of "Death by SQL".

I've managed to erg out a couple of articles on some of the ways to avoid RBAR in certain areas... here's the link to them all... note that the article on Running Totals isn't actually available right now... it's in the process of being rewritten.

http://www.sqlservercentral.com/Authors/Articles/Jeff_Moden/80567/

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

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

idrees.butt SSC Enthusiast Points: 108 More actions · Answer 15

Can you give a general, simple and very good example of how to do that shift? like an alternate way(column wise thinking) to what a normal person would do (row wise thinking)

One more thing is that I have been seeing so many links...I can just save them for now!! but cant read all...is that necessary to read all that at once? or how should I plan it?