Good sp patterns

I am looking for a good document or whatever to learn how to create
storedprocedure(select,Insert,...) effectively?
I am going to create some storeprocedure and I want them to be nice in
performance and scalability.
thanksIf you are asking about a nicely-formatted template or some general dos and
donts, I am sure there are folks out here who have something to offer. But
to have a guide line for writing good performing and easy scaling procs, it
can cost a book and a few years of experience ...
Besides, it is always dependent on YOUR system. In addition, the
performance and scalability of stored procedures are not just in themselves.
It starts with logical DB design, physical implementation, etc.
Some books may be helpful. SQL Server 2000 Performance Tuning by Ed Whalen
et al, Professional SQL Server 2000 programming by R. Vieira can be among
them.
"ALI-R" <ali@.microsoft.com> wrote in message
news:%2328NHORwEHA.3416@.TK2MSFTNGP09.phx.gbl...
> I am looking for a good document or whatever to learn how to create
> storedprocedure(select,Insert,...) effectively?
> I am going to create some storeprocedure and I want them to be nice in
> performance and scalability.
> thanks
>|||Is there somehwhere like www.codeprojects.com ,where I can find some
storedprocedure samples to get some idea how to write my stored procedures.
thanks for your help.
Ali
"Quentin Ran" <removethis.qran2@.yahoo.com> wrote in message
news:ujmD$lSwEHA.2316@.TK2MSFTNGP15.phx.gbl...
> If you are asking about a nicely-formatted template or some general dos
and
> donts, I am sure there are folks out here who have something to offer.
But
> to have a guide line for writing good performing and easy scaling procs,
it
> can cost a book and a few years of experience ...
> Besides, it is always dependent on YOUR system. In addition, the
> performance and scalability of stored procedures are not just in
themselves.
> It starts with logical DB design, physical implementation, etc.
> Some books may be helpful. SQL Server 2000 Performance Tuning by Ed
Whalen
> et al, Professional SQL Server 2000 programming by R. Vieira can be among
> them.
>
> "ALI-R" <ali@.microsoft.com> wrote in message
> news:%2328NHORwEHA.3416@.TK2MSFTNGP09.phx.gbl...
>