Inside SQL Server

A couple of years ago, I bought a copy of "Inside SQL Server 7.0" (Ron
Soukup and Kalen Delaney / Microsoft Press). Due to unforeseen
circumstances, I never got around to reading it.
About a week ago, I finaly had time to start reading. I must say I
really enjoy getting to know all the mechanics and inner workings of
SQL Server and some of the backgrounds provided might help me create
more efficient databases.
On the other hand, I am well aware that my professional focus now has
to be on SQL Server 2000, not SQL Server 7.0. While reading, I often
find myself wondering how much of what I read still applies to SQL
Server 2000. Have there been major reworkings of the inner mechanics
of SQL Server between 7.0 or 2000, or is 2000 basically (as I've once
read somewhere) "the same as 7.0 but with XML support thrown in"?
Basically, what I want to know is how I can make the best use of my
limited time and money:
a) Continue reading, but order "Inside SQL Server 2000" as well; check
out the differences between the books when the latter arrives.
b) Order "Inside SQL Server 2000" first. Stop reading for now and read
only the 2000 edition.
c) Don't bother with "Inside SQL Server 2000" until I need information
on specific aspects of SQL Server 2000 (like XML?). Spend the money
saved to treat my children to an extra ice cream.
Any insights on this would be greatly appreciated!
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)Hugo
Creat books
a) Continue reading, but order "Inside SQL Server 2000" as well; check
out the differences between the books when the latter arrives
"Hugo Kornelis" <hugo@.pe_NO_rFact.in_SPAM_fo> wrote in message
news:l7gd501kukf2pj1ia4vo0ud57lojog2m6d@.
4ax.com...
> A couple of years ago, I bought a copy of "Inside SQL Server 7.0" (Ron
> Soukup and Kalen Delaney / Microsoft Press). Due to unforeseen
> circumstances, I never got around to reading it.
> About a week ago, I finaly had time to start reading. I must say I
> really enjoy getting to know all the mechanics and inner workings of
> SQL Server and some of the backgrounds provided might help me create
> more efficient databases.
> On the other hand, I am well aware that my professional focus now has
> to be on SQL Server 2000, not SQL Server 7.0. While reading, I often
> find myself wondering how much of what I read still applies to SQL
> Server 2000. Have there been major reworkings of the inner mechanics
> of SQL Server between 7.0 or 2000, or is 2000 basically (as I've once
> read somewhere) "the same as 7.0 but with XML support thrown in"?
> Basically, what I want to know is how I can make the best use of my
> limited time and money:
> a) Continue reading, but order "Inside SQL Server 2000" as well; check
> out the differences between the books when the latter arrives.
> b) Order "Inside SQL Server 2000" first. Stop reading for now and read
> only the 2000 edition.
> c) Don't bother with "Inside SQL Server 2000" until I need information
> on specific aspects of SQL Server 2000 (like XML?). Spend the money
> saved to treat my children to an extra ice cream.
> Any insights on this would be greatly appreciated!
> Best, Hugo
> --
> (Remove _NO_ and _SPAM_ to get my e-mail address)|||Hugo,
Difficult... I'd say it partly depends on how much you understand and
remember right now. You could continue reading, check differences and use
the second pass as repetition. However, it might not be easy to spot the
differences when you get the 2000 edition, which would suggest stop reading
and wait for a while.
I think the Inside book is great if you are the intended audience, so I
definitely recommend that you go for the 2000 edition. I would probably go
for option B, stop reading and continue when you get the 2000 edition.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Hugo Kornelis" <hugo@.pe_NO_rFact.in_SPAM_fo> wrote in message
news:l7gd501kukf2pj1ia4vo0ud57lojog2m6d@.
4ax.com...
> A couple of years ago, I bought a copy of "Inside SQL Server 7.0" (Ron
> Soukup and Kalen Delaney / Microsoft Press). Due to unforeseen
> circumstances, I never got around to reading it.
> About a week ago, I finaly had time to start reading. I must say I
> really enjoy getting to know all the mechanics and inner workings of
> SQL Server and some of the backgrounds provided might help me create
> more efficient databases.
> On the other hand, I am well aware that my professional focus now has
> to be on SQL Server 2000, not SQL Server 7.0. While reading, I often
> find myself wondering how much of what I read still applies to SQL
> Server 2000. Have there been major reworkings of the inner mechanics
> of SQL Server between 7.0 or 2000, or is 2000 basically (as I've once
> read somewhere) "the same as 7.0 but with XML support thrown in"?
> Basically, what I want to know is how I can make the best use of my
> limited time and money:
> a) Continue reading, but order "Inside SQL Server 2000" as well; check
> out the differences between the books when the latter arrives.
> b) Order "Inside SQL Server 2000" first. Stop reading for now and read
> only the 2000 edition.
> c) Don't bother with "Inside SQL Server 2000" until I need information
> on specific aspects of SQL Server 2000 (like XML?). Spend the money
> saved to treat my children to an extra ice cream.
> Any insights on this would be greatly appreciated!
> Best, Hugo
> --
> (Remove _NO_ and _SPAM_ to get my e-mail address)|||Tibor
I hold in respect for you, your experience but permit me to be not agree
with you.
There a lots of things which don't change since we read 'inside 7.0'
At this time we can say , hey wait for SQL Server 2005 because inside 2000
might or might not be relevant.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ORhWeV0CEHA.2052@.TK2MSFTNGP11.phx.gbl...
> Hugo,
> Difficult... I'd say it partly depends on how much you understand and
> remember right now. You could continue reading, check differences and use
> the second pass as repetition. However, it might not be easy to spot the
> differences when you get the 2000 edition, which would suggest stop
reading
> and wait for a while.
> I think the Inside book is great if you are the intended audience, so I
> definitely recommend that you go for the 2000 edition. I would probably go
> for option B, stop reading and continue when you get the 2000 edition.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Hugo Kornelis" <hugo@.pe_NO_rFact.in_SPAM_fo> wrote in message
> news:l7gd501kukf2pj1ia4vo0ud57lojog2m6d@.
4ax.com...
>|||Disagreeing is OK, Uri :-)
Yes, it is a close call, I agree.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:O0gDSl0CEHA.308@.TK2MSFTNGP11.phx.gbl...
> Tibor
> I hold in respect for you, your experience but permit me to be not agree
> with you.
> There a lots of things which don't change since we read 'inside 7.0'
> At this time we can say , hey wait for SQL Server 2005 because inside 2000
> might or might not be relevant.
>
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:ORhWeV0CEHA.2052@.TK2MSFTNGP11.phx.gbl...
use
> reading
go
>|||Uri Dimant wrote:

> Hugo
> Creat books
> a) Continue reading, but order "Inside SQL Server 2000" as well; check
> out the differences between the books when the latter arrives
I must agree with this. As others have noted that are not that many
differences and I also know that for myself it took me a few reads
before I even fully understood why certain things were important. (Why
did I have to know what a page and extant were?) So I would definably
read the 7 book first, then once you finish that, start reading the 2000
book, then hopefully when you are done with that you can read the 2005
book. Another added benefit of reading 7 before 2000 is that it saves
your 2000 copy from getting worn down so quickly. I'm to the point where
I need to get another copy, except I've been a little leery because I'm
so excited to get a hold of 2005 (Yukon).
Aaron Weiker
http://blogs.sqladvice.com/aweiker
http://aaronweiker.com/|||Hi Hugo
The actual differences between the products are minimal in terms of what is
covered in the 2000 version. There was a slight change to the way rows on a
page are organized and what it means for the rows to be 'in order'. I also
greatly expanded the details of internal index storage and gave indexes
their own chapter. There were also a few small optimizer changes.
But most of the work of the 2000 version was the new features:
LOTS of details on Recovery Models (new feature)
More details on the internals of backup and restore
User Defined Functions, creation and optimization (this is a brand new
feature)
Lots of details on new database options and ALTER DATABASE
Lots of details about creation and use of Indexed Views for performance
enhancement
Details on 'instead of' triggers
etc.
So if you want details of these NEW features, you need the new version of
the book.
(But, XML is NOT included because in SQL Server 2000, XML is not "Inside"
SQL Server. It is only a thin wrapper around it. )
But, I would think that ice cream for your kids was more important.
However, if you buy the book, the royalties might be enough for me to buy an
extra ice cream for MY kids.
:-)
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Hugo Kornelis" <hugo@.pe_NO_rFact.in_SPAM_fo> wrote in message
news:l7gd501kukf2pj1ia4vo0ud57lojog2m6d@.
4ax.com...
> A couple of years ago, I bought a copy of "Inside SQL Server 7.0" (Ron
> Soukup and Kalen Delaney / Microsoft Press). Due to unforeseen
> circumstances, I never got around to reading it.
> About a week ago, I finaly had time to start reading. I must say I
> really enjoy getting to know all the mechanics and inner workings of
> SQL Server and some of the backgrounds provided might help me create
> more efficient databases.
> On the other hand, I am well aware that my professional focus now has
> to be on SQL Server 2000, not SQL Server 7.0. While reading, I often
> find myself wondering how much of what I read still applies to SQL
> Server 2000. Have there been major reworkings of the inner mechanics
> of SQL Server between 7.0 or 2000, or is 2000 basically (as I've once
> read somewhere) "the same as 7.0 but with XML support thrown in"?
> Basically, what I want to know is how I can make the best use of my
> limited time and money:
> a) Continue reading, but order "Inside SQL Server 2000" as well; check
> out the differences between the books when the latter arrives.
> b) Order "Inside SQL Server 2000" first. Stop reading for now and read
> only the 2000 edition.
> c) Don't bother with "Inside SQL Server 2000" until I need information
> on specific aspects of SQL Server 2000 (like XML?). Spend the money
> saved to treat my children to an extra ice cream.
> Any insights on this would be greatly appreciated!
> Best, Hugo
> --
> (Remove _NO_ and _SPAM_ to get my e-mail address)|||On Tue, 16 Mar 2004 08:28:24 -0800, Kalen Delaney wrote:

>But, I would think that ice cream for your kids was more important.
>However, if you buy the book, the royalties might be enough for me to buy a
n
>extra ice cream for MY kids.
LOL!!
I'll see if my next assignment will earn me enough to buy the book AND
some ice cream. That would make all kids happy.
Thanks, Kalen, for your detailed explanation of the differences. I
didn't even realize how many of the features I use heavily are new.
I'm glad to know that my current reading is not a waste of time, but
you certainly made me eager to start reading about the 2000-specific
deatils as well.
Thanks as well for writing a great book!
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)