Re: Book recommendations?



blueghost73@xxxxxxxxx (blueghost73@xxxxxxxxx) writes:
I do software support for software that works with both Oracle and SQL
Server, so I mostly just write queries to look at the data related to
the software. When I first started, I bought a couple of books to learn
the basics, intentionally going with generic books that would help with
both types of databases. I've got the basics down, and now I'm looking
for a really detailed reference book that goes really indepth into
querying for SQL Server specifically. Currently, we only work with the
2000 version, but we'll be going to 2005 soon, so I think I'd rather go
with a book on 2005, although if you know one that covers the
differences between them, that would be great. Any recommendations?

The ultimate book on writing queries on SQL 2005 simply must be "Inside
T-SQL Querying" by Itzik Ben-Gan on Microsoft Press. If there is a problem
he can't write a query for, then there is simple is no query to write - or
the query is not worth writing. I'm just about to read the book myself,
so I cannot say how much he compares with SQL 2000.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.



Relevant Pages

  • Re: Slow update
    ... Thanks for your comments - time to invest in some books me thinks! ... Geoff ... I'm afraid I don't know much about the SQL server itself ...
    (microsoft.public.dotnet.languages.vb)
  • problem with asp web site recorsets (sqlserver2000) return esporadicaly EOF BOF
    ... intermittently return empty recordsets on queries that should be returning ... At the time the problem occurs, the same queries successfully ... Microsoft SQL Server. ... same sql querys using query analizer, the sql server return valid results. ...
    (microsoft.public.data.odbc)
  • Re: Custom Row Functions: Access vs. SQL Server
    ... how can I implement the custom row functions? ... >Visual Basic integrated with SQL Server just as it is with Access? ... Custom functions can be used in SQL Server 2000 and above queries, ...
    (comp.databases.ms-access)
  • Re: Managing Long Running Queries/Batches
    ... Everything you mentions sounds like good ways to tweak performance for ... your SQL server. ... Run the queries asynchonously. ... Use replication, or better, log shipping to another server where the ...
    (microsoft.public.sqlserver)
  • Re: Alternatives to ADP?
    ... Another thing to look at, which Sylvain touched on, but didn't quite highlight is to write your queries on the SQL Server side, and ... then attach them in Access as either Tables or Pass-through Queries. ... have the disadvantage that you have to worry about linking them in...not so much a problem if your server is reliably in one place, ... So I am now testing the other upsizing option that creates an adp file. ...
    (microsoft.public.access.adp.sqlserver)