Posted by Mukesh_Singh_Nick on 10/17/07 13:53

What's the best book to buy for learning MS-SQL Server for a database
programmer. I'll tell you my goals. I want a book that covers:

1) the theory behind operators (cartesian JOIN, cross JOIN, all the
JOINs, UNION, UNION all) and their comparison to mathematics/set
theory

2) writing complex queries, nested queries (sub-queries)

3) tell me about some MS-SQL Server hacks like how many maximum
columns a
table can have, if there's some such thing

4) explains what indexing is, types of indexing, types of locks, etc.

5) explains what database partitions are

6) explains some maintenance legwork like backup/restore, setting up
ODBC connections, creating and deleting users, granting/revoking
rights

7) teaches me to write stored procedures, cursors, functions,
packages
(if there's such a thing) and triggers

8) tells me about the limits of each datatype and possibly their byte
structure. Some of this is covered in the Books Online but it'll be
better if I can have a paper version of it to read it in bed

[Back to original message]