Advanced programming examples ?

Can anyone reccomend a book or online tutorials that shows quite
advanced SQL examples.
Most the sites and books I have seen for SQL only give small examples
from the pubs database designed for a few concurrent users. This is
fine for learning but what about real systems with 50+ concurrent users
and millions of records.
I'm looking for best practices and some examples showing heavy duty
stored procedures for high volume batch updates and inserts, triggers
for audit trails, best practice for transactions, efficient crosstab
queries etc.
Can anyone reccomend a website of book for this for SQL 2000.
Thanks
hals_leftThe following books have some great stored procedures and complex queries:
The Guru's guide to Transact-SQL
http://vyaskn.tripod.com/gurus_guid...ransact_sql.htm
Transact-SQL Cookbook
http://vyaskn.tripod.com/transact-sql_cookbook.htm
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
<cc900630@.ntu.ac.uk> wrote in message
news:1117094001.602864.285150@.f14g2000cwb.googlegroups.com...
Can anyone reccomend a book or online tutorials that shows quite
advanced SQL examples.
Most the sites and books I have seen for SQL only give small examples
from the pubs database designed for a few concurrent users. This is
fine for learning but what about real systems with 50+ concurrent users
and millions of records.
I'm looking for best practices and some examples showing heavy duty
stored procedures for high volume batch updates and inserts, triggers
for audit trails, best practice for transactions, efficient crosstab
queries etc.
Can anyone reccomend a website of book for this for SQL 2000.
Thanks
hals_left|||Thanks - the gurus guide looks exactly what im after|||Another good book for how to write efficient queries is:
Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook
by Ken England
<cc900630@.ntu.ac.uk> wrote in message
news:1117094001.602864.285150@.f14g2000cwb.googlegroups.com...
> Can anyone reccomend a book or online tutorials that shows quite
> advanced SQL examples.
> Most the sites and books I have seen for SQL only give small examples
> from the pubs database designed for a few concurrent users. This is
> fine for learning but what about real systems with 50+ concurrent users
> and millions of records.
> I'm looking for best practices and some examples showing heavy duty
> stored procedures for high volume batch updates and inserts, triggers
> for audit trails, best practice for transactions, efficient crosstab
> queries etc.
> Can anyone reccomend a website of book for this for SQL 2000.
> Thanks
> hals_left
>