Can anyone recommend some good resources (Web sites, books, etc.) for 'real world' SQL Server code samples?

I've been playing around with Transact-SQL in SQL 2000. I've gotten the 'basics' down, but have been curious to see some 'real world' sample, to learn more about capabilities in SQL Server programming.

Most SQL books I've seen at Borders don't really cover this in much detail.

Thanks in advance,
Kevin