Showing posts with label structure. Show all posts
Showing posts with label structure. Show all posts

Monday, March 19, 2012

Down and dirty database infrastructure

Does any have a link, or know of an MS book(s) that details the
underlying database structure, tables, processes? Something that
explains in detail how/why this stuff is configured and works, like
DDL, TDS, varchar, int, index, tables, normalization, DML, Primary
Key/Foreign key.Beeker (sqlserver2005dba@.gmail.com) writes:
> Does any have a link, or know of an MS book(s) that details the
> underlying database structure, tables, processes? Something that
> explains in detail how/why this stuff is configured and works, like
> DDL, TDS, varchar, int, index, tables, normalization, DML, Primary
> Key/Foreign key.

Sounds like you are looking for "Inside SQL Server 2000" by Kalen
Delaney.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Thanks much.

The review, on Barnes and Nobel (
http://search.barnesandnoble.com/bo...isbn=0735609985
), on her treatment of internals and other vaulable info are very
critical.

Then the Amazon comments praise her.
(
http://www.amazon.com/gp/product/07...406348?n=283155
).

Comment?|||"Beeker" <sqlserver2005dba@.gmail.com> wrote in message
news:1143721430.783394.148200@.t31g2000cwb.googlegr oups.com...
> Thanks much.
> The review, on Barnes and Nobel (
http://search.barnesandnoble.com/bo...isbn=0735609985
> ), on her treatment of internals and other vaulable info are very
> critical.
> Then the Amazon comments praise her.
> (
http://www.amazon.com/gp/product/07...406348?n=283155
> ).
> Comment?

She knows her stuff. Extremely knowledgeable. Get the book.

You want a book on XML, there are definitely better ones.|||Thanks Strider.

Doubt in select query

my table ha follow structure..
SalaryTable:
Value Salary
--
Jan 1000
Feb 2000
Mar 3000
Apr 4000
i want the o/p as..
Jan Feb Mar Apr
1000 2000 3000 4000
Pls give me a query for this
Regards,
SatheeshHi,
It is not straight forward in SQL 2000, you need to write logic. See the
below URL:-
http://www.sqlteam.com/item.asp?ItemID=2955
Thanks
hari
SQL Server MVP
"BabuLives" <satheeshbabu.b@.gmail.com> wrote in message
news:1130138243.780789.195160@.g43g2000cwa.googlegroups.com...
> my table ha follow structure..
>
> SalaryTable:
>
> Value Salary
> --
> Jan 1000
> Feb 2000
> Mar 3000
> Apr 4000
>
> i want the o/p as..
>
> Jan Feb Mar Apr
> 1000 2000 3000 4000
>
> Pls give me a query for this
>
> Regards,
> Satheesh
>