3 ms·
That is a great resource. Here are some I've used: Inside Microsoft SQL Server 2008 T-SQL Querying: T-SQL Querying https://books.google.com/books?id=FZlCAwAAQ
by jpitz 10y ago
That is a great resource.
Here are some I've used:
Inside Microsoft SQL Server 2008 T-SQL Querying: T-SQL Querying https://books.google.com/books?id=FZlCAwAAQBAJ&printsec=frontcover#v=onepage&q&f=false https://books.google.com/books?id=FZlCAwAAQBAJ&printsec=fron...
Good resource for designing high performing queries and investigating performance problems.
PostgreSQL 9.0: High Performance https://books.google.com/books?id=OWOAu0GcsqoC&printsec=frontcover#v=onepage&q&f=false https://books.google.com/books?id=OWOAu0GcsqoC&printsec=fron...
Greg lays out a great foundation for doing performance analysis that is largely applicable to any rdbms platform.
Optimizing Oracle Performance https://books.google.com/books?id=D7ElCwAAQBAJ&printsec=frontcover#v=onepage&q&f=false https://books.google.com/books?id=D7ElCwAAQBAJ&printsec=fron...
Another great book that explains the process of approaching and solving performance problems.
Joe Celko's SQL For Smarties https://books.google.com/books?id=i-19BAAAQBAJ&printsec=frontcover#v=onepage&q&f=false https://books.google.com/books?id=i-19BAAAQBAJ&printsec=fron...
Everyone writing SQL should read Joe.
- icc97 10y agoWhat intrigues me about Joe Celko's book is that he is completely anti all forms of auto indexing (and it makes sense) but is the assumption for all the web frameworks that I come across. Most recently I hit this when looking at yesod.