Mukesh_Singh_Nick@yahoo.com wrote:

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

On Oct 17, 8:53 am, Mukesh_Singh_N...@yahoo.com wrote:
> 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