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

SQL 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

Show quoteHide quote

Jarod wrote:
I'm currently reading "The Art Of SQL"
(http://www.amazon.com/gp/product/0596008945).  Pretty good explanations
of database and query concepts.

I saw a reference to "The Art of SQL" this morning when looking up Kevin
Kline's "SQL in a Nutshell" on Amazon (it appears that 63% of Amazon
users who read the nutshell page buy the Art of SQL book, although I
hadn't heard of it before today).  What do you think so far?  Good book?

Show quoteHide quote

Mike Hodgson wrote:
It's pretty good so far.  Lots of theory, nothing specific to one RDBMS
over another.  I would HIGHLY recommend it to a developer or beginning
DBA who doesn't have a lot of database experience.  I'm only about a
third of the way through, can't say that I've actually learned anything
knew from it yet, but it's been a good refresher/memory jogger.  Overall
an enjoyable read.

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:
Show quoteHide quote

[ database_name . [ schema_name ] . | schema_name . ] table_name
SQL question
More Efficient SQL Statement - Select Count(1)
Passing a parameter as list in a Stored procedure
select based on containing only certain characters