Good books about huge databases ?

Hey
I need some good books about working with enormous amount of data. The table
rows are counted in milions. Have you used SS-2005 with such big amount of
data ? What was your experiences ? Any bad things happend ? Any supprises ?
Any bugs ? Is there big perfomance diffrence between SS-2000 and 2005 ?
What books will you recommend to read to get to know some nice techniques ?
What articles ? What websites ? Maybe there is some forum for developers /
programmers for such databases ?
Please share your experience :)
JarodSQL Server 2005 is really nice...
more functions
more speed
more realibility
more services
etc...
I'm reading from Wrox Professional ADO.NET 2: Programming with SQL Server
2005, Oracle and MySQL
it's a generalist book but they have more and only for SQL Server 2005
check them out: http://www.wrox.com/WileyCDA/Section/id-131384.html
and you can always buy it from amazon.com or amazon.co.uk where I buy my
books from Wrox
Bruno Alexandre
(a Portuguese in Kbenhanv, Danmark)
"Jarod" <blueice@.NOSPAM.gazeta.pl> escreveu na mensagem
news:%235eJAvUnGHA.4164@.TK2MSFTNGP05.phx.gbl...
> Hey
> I need some good books about working with enormous amount of data. The
> table rows are counted in milions. Have you used SS-2005 with such big
> amount of data ? What was your experiences ? Any bad things happend ? Any
> supprises ? Any bugs ? Is there big perfomance diffrence between SS-2000
> and 2005 ?
> What books will you recommend to read to get to know some nice techniques
> ? What articles ? What websites ? Maybe there is some forum for developers
> / programmers for such databases ?
> Please share your experience :)
> Jarod|||Jarod wrote:
> Hey
> I need some good books about working with enormous amount of data. The
> table rows are counted in milions. Have you used SS-2005 with such big
> amount of data ? What was your experiences ? Any bad things happend ?
> Any supprises ? Any bugs ? Is there big perfomance diffrence between
> SS-2000 and 2005 ?
> What books will you recommend to read to get to know some nice
> techniques ? What articles ? What websites ? Maybe there is some forum
> for developers / programmers for such databases ?
> Please share your experience :)
> Jarod
I'm currently reading "The Art Of SQL"
(http://www.amazon.com/gp/product/0596008945). Pretty good explanations
of database and query concepts.|||You may also want to pick up some books on Data Warehousing; different
design model, and different design rules, but if you're dealing with
millions of rows of data, you may find yourself looking at OLAP cubes
eventually. Look for stuff by Kimball.
I had to laugh recently: Microsoft is running this ad campaign about
companies that run SQL Server 2005; Hilton supposedly has a 7 million
row data warehouse that load 1.4 million rows of data a day. In our
shop, we process over 40 million rows of data a day on SQL 2000.
SQL Server 2005 is very nice, and there are a lot of performance
enhancements, but SQL 2000 has been an enterprise class database for a
long time. If you have the choice, go with SQL 2005; if not, you can
do a lot with SQL 2000
Stu
Jarod wrote:
> Hey
> I need some good books about working with enormous amount of data. The tab
le
> rows are counted in milions. Have you used SS-2005 with such big amount of
> data ? What was your experiences ? Any bad things happend ? Any supprises
?
> Any bugs ? Is there big perfomance diffrence between SS-2000 and 2005 ?
> What books will you recommend to read to get to know some nice techniques
?
> What articles ? What websites ? Maybe there is some forum for developers /
> programmers for such databases ?
> Please share your experience :)
> Jarod