AdventureWorks database

Is this database 'AdventureWorks' comes with SQL 2005?
I read the book 'Mastering Microsoft SQL Server 2005' by Sybex says this
comes with SQL Server 2005. But I cannot find that in the Management Studio.It is not automatically installed. You must specifically select it during a
custom install.
You might be able to get it now by just reinstalling the tools and making
sure you choose the sample databases. Otherwise you can download it from
here
http://www.microsoft.com/downloads/details.aspx?FamilyID=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:ucBHEhvLHHA.780@.TK2MSFTNGP03.phx.gbl...
> Is this database 'AdventureWorks' comes with SQL 2005?
> I read the book 'Mastering Microsoft SQL Server 2005' by Sybex says this
> comes with SQL Server 2005. But I cannot find that in the Management
> Studio.
>|||Thanks.
I downloaded the 'SqlServerSamples.msi' and installed it.
However, I looked thro' the Samples folder cannot find the AdventureWorks
database.
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:uBZ0s2vLHHA.960@.TK2MSFTNGP04.phx.gbl...
> It is not automatically installed. You must specifically select it during
> a custom install.
> You might be able to get it now by just reinstalling the tools and making
> sure you choose the sample databases. Otherwise you can download it from
> here
> http://www.microsoft.com/downloads/details.aspx?FamilyID=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en
>
> --
> HTH
> Kalen Delaney, SQL Server MVP
> http://sqlblog.com
>
> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:ucBHEhvLHHA.780@.TK2MSFTNGP03.phx.gbl...
>> Is this database 'AdventureWorks' comes with SQL 2005?
>> I read the book 'Mastering Microsoft SQL Server 2005' by Sybex says this
>> comes with SQL Server 2005. But I cannot find that in the Management
>> Studio.
>|||Alan T wrote:
> Thanks.
> I downloaded the 'SqlServerSamples.msi' and installed it.
> However, I looked thro' the Samples folder cannot find the AdventureWorks
> database.
You should download AdventureWorksDB.msi or AdventureWorksDBCI.msi
Razvan|||Yes, the SqlServerSamples.msi is code samples. There are separate downloads
for the sample databases, which you can see in the link I gave you are
larger files than the Samples download. You can choose to download AW in
either a case-sensitive collation or case-INsensitive.
--
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Razvan Socol" <rsocol@.gmail.com> wrote in message
news:1167832817.697717.13790@.48g2000cwx.googlegroups.com...
> Alan T wrote:
>> Thanks.
>> I downloaded the 'SqlServerSamples.msi' and installed it.
>> However, I looked thro' the Samples folder cannot find the AdventureWorks
>> database.
> You should download AdventureWorksDB.msi or AdventureWorksDBCI.msi
> Razvan
>|||Yes, I downloaded and now to attach the database file.
Thanks.
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:evmaXQ1LHHA.5064@.TK2MSFTNGP04.phx.gbl...
> Yes, the SqlServerSamples.msi is code samples. There are separate
> downloads for the sample databases, which you can see in the link I gave
> you are larger files than the Samples download. You can choose to download
> AW in either a case-sensitive collation or case-INsensitive.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> http://sqlblog.com
>
> "Razvan Socol" <rsocol@.gmail.com> wrote in message
> news:1167832817.697717.13790@.48g2000cwx.googlegroups.com...
>> Alan T wrote:
>> Thanks.
>> I downloaded the 'SqlServerSamples.msi' and installed it.
>> However, I looked thro' the Samples folder cannot find the
>> AdventureWorks
>> database.
>> You should download AdventureWorksDB.msi or AdventureWorksDBCI.msi
>> Razvan
>sql

AdventureWorks database

Is this database 'AdventureWorks' comes with SQL 2005?
I read the book 'Mastering Microsoft SQL Server 2005' by Sybex says this
comes with SQL Server 2005. But I cannot find that in the Management Studio.It is not automatically installed. You must specifically select it during a
custom install.
You might be able to get it now by just reinstalling the tools and making
sure you choose the sample databases. Otherwise you can download it from
here
http://www.microsoft.com/downloads/...&displaylang=en
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:ucBHEhvLHHA.780@.TK2MSFTNGP03.phx.gbl...
> Is this database 'AdventureWorks' comes with SQL 2005?
> I read the book 'Mastering Microsoft SQL Server 2005' by Sybex says this
> comes with SQL Server 2005. But I cannot find that in the Management
> Studio.
>|||Thanks.
I downloaded the 'SqlServerSamples.msi' and installed it.
However, I looked thro' the Samples folder cannot find the AdventureWorks
database.
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:uBZ0s2vLHHA.960@.TK2MSFTNGP04.phx.gbl...
> It is not automatically installed. You must specifically select it during
> a custom install.
> You might be able to get it now by just reinstalling the tools and making
> sure you choose the sample databases. Otherwise you can download it from
> here
> http://www.microsoft.com/downloads/...&displaylang=en
>
> --
> HTH
> Kalen Delaney, SQL Server MVP
> http://sqlblog.com
>
> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:ucBHEhvLHHA.780@.TK2MSFTNGP03.phx.gbl...
>|||Alan T wrote:
> Thanks.
> I downloaded the 'SqlServerSamples.msi' and installed it.
> However, I looked thro' the Samples folder cannot find the AdventureWorks
> database.
You should download AdventureWorksDB.msi or AdventureWorksDBCI.msi
Razvan|||Yes, the SqlServerSamples.msi is code samples. There are separate downloads
for the sample databases, which you can see in the link I gave you are
larger files than the Samples download. You can choose to download AW in
either a case-sensitive collation or case-INsensitive.
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Razvan Socol" <rsocol@.gmail.com> wrote in message
news:1167832817.697717.13790@.48g2000cwx.googlegroups.com...
> Alan T wrote:
> You should download AdventureWorksDB.msi or AdventureWorksDBCI.msi
> Razvan
>|||Yes, I downloaded and now to attach the database file.
Thanks.
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:evmaXQ1LHHA.5064@.TK2MSFTNGP04.phx.gbl...
> Yes, the SqlServerSamples.msi is code samples. There are separate
> downloads for the sample databases, which you can see in the link I gave
> you are larger files than the Samples download. You can choose to download
> AW in either a case-sensitive collation or case-INsensitive.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> http://sqlblog.com
>
> "Razvan Socol" <rsocol@.gmail.com> wrote in message
> news:1167832817.697717.13790@.48g2000cwx.googlegroups.com...
>

Advanced Transact-SQL Reference book - Need recommendations!

I currently have two SQL server books for MS SQL Server 2000. One is a
prep book for the 70-229 exam, the other is a Wrox book: "professional
SQL Server 2000 Programming."

I'm looking for more T-SQL books that give me PRACTICAL tips on
writing advanced queries. What book do you refer to? Please post them."ChrisL" <chrispycrunch@.gmail.com> wrote in message
news:9e416a3e.0410150618.68b59074@.posting.google.c om...
>I currently have two SQL server books for MS SQL Server 2000. One is a
> prep book for the 70-229 exam, the other is a Wrox book: "professional
> SQL Server 2000 Programming."
> I'm looking for more T-SQL books that give me PRACTICAL tips on
> writing advanced queries. What book do you refer to? Please post them.

"Advanced Transact-SQL for SQL Server 2000" by Ben-Gan and Moreau is very
good, as are Joe Celko's books. Also see here:

http://vyaskn.tripod.com/sqlbooks.htm

Simon|||Simon Hayes wrote:
> "Advanced Transact-SQL for SQL Server 2000" by Ben-Gan and Moreau is
> very good

The Amazon reviews rip this book to shreds.

--
Steve Troxell|||Hi

The reviews seem very polar, I guess you just love it or hate it!!
Michael Hotek probably sums the book up best in his review.

John

"Steve Troxell" <steve_troxell@.nospam.hotmail.com> wrote in message
news:mA9cd.17729$yP2.4182@.tornado.tampabay.rr.com. ..
> Simon Hayes wrote:
> > "Advanced Transact-SQL for SQL Server 2000" by Ben-Gan and Moreau is
> > very good
> The Amazon reviews rip this book to shreds.
> --
> Steve Troxell

advanced SQL tutorials

Dear All,
Can you suggest a good book or set of websites which have advanced SQL tutorials for SQL server? Got the basics but looking to build on my knowledge.
...cause knowledge is power...Here are some books

http://www.sqlteam.com/store.asp

And read every post here, and over at sql team.

Use Books online to try and figure out a posters question in Query Analyzer. Most often than not you will see someone answer the question.

Good Luck|||You might want to be a bit more specific. SQL Server has components that cover a broad range of topics. Are you a developer seeking to increase your knowledge of T-SQL and ADO? Are you a DBA seeking the best practices for securing your data and performance tuning? Are you a business analyst looking to learn MDX and OLAP?

Lots of sites to browse. Google is your friend.

Regards,

hmscott|||You might want to be a bit more specific. SQL Server has components that cover a broad range of topics. Are you a developer seeking to increase your knowledge of T-SQL and ADO? Are you a DBA seeking the best practices for securing your data and performance tuning? Are you a business analyst looking to learn MDX and OLAP?

Lots of sites to browse. Google is your friend.

Regards,

hmscott

Sorry for late reply and thanks for recomendations! Yes trying to learn more about complex queries with t-sql and db design and implementation for real life apps, had DB modules at Uni but it seems like hardly anything compared to the problems I face now in my job!

Advanced programming examples ?

Can anyone reccomend a book or online tutorials that shows quite
advanced SQL examples.
Most the sites and books I have seen for SQL only give small examples
from the pubs database designed for a few concurrent users. This is
fine for learning but what about real systems with 50+ concurrent users
and millions of records.
I'm looking for best practices and some examples showing heavy duty
stored procedures for high volume batch updates and inserts, triggers
for audit trails, best practice for transactions, efficient crosstab
queries etc.
Can anyone reccomend a website of book for this for SQL 2000.
Thanks
hals_leftThe following books have some great stored procedures and complex queries:
The Guru's guide to Transact-SQL
http://vyaskn.tripod.com/gurus_guid...ransact_sql.htm
Transact-SQL Cookbook
http://vyaskn.tripod.com/transact-sql_cookbook.htm
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
<cc900630@.ntu.ac.uk> wrote in message
news:1117094001.602864.285150@.f14g2000cwb.googlegroups.com...
Can anyone reccomend a book or online tutorials that shows quite
advanced SQL examples.
Most the sites and books I have seen for SQL only give small examples
from the pubs database designed for a few concurrent users. This is
fine for learning but what about real systems with 50+ concurrent users
and millions of records.
I'm looking for best practices and some examples showing heavy duty
stored procedures for high volume batch updates and inserts, triggers
for audit trails, best practice for transactions, efficient crosstab
queries etc.
Can anyone reccomend a website of book for this for SQL 2000.
Thanks
hals_left|||Thanks - the gurus guide looks exactly what im after|||Another good book for how to write efficient queries is:
Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook
by Ken England
<cc900630@.ntu.ac.uk> wrote in message
news:1117094001.602864.285150@.f14g2000cwb.googlegroups.com...
> Can anyone reccomend a book or online tutorials that shows quite
> advanced SQL examples.
> Most the sites and books I have seen for SQL only give small examples
> from the pubs database designed for a few concurrent users. This is
> fine for learning but what about real systems with 50+ concurrent users
> and millions of records.
> I'm looking for best practices and some examples showing heavy duty
> stored procedures for high volume batch updates and inserts, triggers
> for audit trails, best practice for transactions, efficient crosstab
> queries etc.
> Can anyone reccomend a website of book for this for SQL 2000.
> Thanks
> hals_left
>

Advanced Data Modeling Book

Hi,
I consider myself an intermediate database developer. I am looking for an
advanced book on data modeling that also includes some best practices. If
any one can help me out I would appreciate it.
p.s. I searched on Amazon and had way too many books to choose from.
hard to answer that because one mans Intermediate is another mans expert.
I also consider myself "Intermediate" in Design
however, I find this book to be quite good:
"Database Modeling and Design"
2nd Edition
Toby J Teorey
Greg Jackson
Portland, OR

Advanced Data Modeling Book

Hi,
I consider myself an intermediate database developer. I am looking for an
advanced book on data modeling that also includes some best practices. If
any one can help me out I would appreciate it.
p.s. I searched on Amazon and had way too many books to choose from.hard to answer that because one mans Intermediate is another mans expert.
I also consider myself "Intermediate" in Design
however, I find this book to be quite good:
"Database Modeling and Design"
2nd Edition
Toby J Teorey
Greg Jackson
Portland, OR

Advanced Data Modeling Book

Hi,
I consider myself an intermediate database developer. I am looking for an
advanced book on data modeling that also includes some best practices. If
any one can help me out I would appreciate it.
p.s. I searched on Amazon and had way too many books to choose from.hard to answer that because one mans Intermediate is another mans expert.
I also consider myself "Intermediate" in Design
however, I find this book to be quite good:
"Database Modeling and Design"
2nd Edition
Toby J Teorey
Greg Jackson
Portland, OR