|
|
Posted by dirq on 10/17/07 16:09
Try these:
Inside Microsoft SQL Server 2005: T-SQL Querying
http://www.amazon.com/Inside-Microsoft-SQL-Server-2005/dp/0735623139/ref=pd_bbs_sr_8/103-0258183-1515818?ie=UTF8&s=books&qid=1192637210&sr=8-8
Administrator's Guide to SQL Server 2005
http://www.amazon.com/Administrators-Server-Microsoft-Windows-System/dp/0321397975/ref=sr_1_1/103-0258183-1515818?ie=UTF8&s=books&qid=1192637300&sr=8-1
-Dirk
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
Navigation:
[Reply to this message]
|