Book Recommendation?

Can anyone recommend a good book or site on Full Text Searching which goes
into detail about things like full text ranked search across multiple tables
especially using phrases not single words? I find the whole thing counter
intuitive compared to normal SQL
Chris,
Not at this time... but look for http://www.SQLFTS.com to come online soon
with content as I own this URL and I'm currently developing the content. As
for a book, I just today re-submitted a new book proposal to a publisher's
Editor-in-Chief (at her request) as the overall technical book market has
been in decline and new books have been difficult to launch on this subject.
However, with the Google IPO and with various announcements from Microsoft,
MSN and Steve Ballmer -
http://www.boston.com/business/techn...llenge_google/
- to quote this article - "Meanwhile, Ballmer left no doubt that Microsoft
has targeted Internet search services for the kind of all-out competitive
push that the company once used to seize dominance in Web browser software.
Despite Google's popularity, "the search market is still quite fragmented,"
Ballmer said, and existing tools still generate lots of useless results.
Ballmer said Microsoft plans to invent new search technology that will
change this, and make life more difficult for Google and other rivals."
So, now it seems to be a good time to be writing a book on Microsoft Search
Technology, including SQL Server 2005! Anyone should feel free to post &/or
email me (mailto:jt-kane@.comcast.net) with comments, encouragements,
feedback, suggestions etc. on both website content as well as future book
content!
Thanks,
John
Looking for a book &/or information on SQL FTS?
http://www.SQLFTS.com - First To Search for SQL Full-Text Search
"Chris Kennedy" <chrisknospam@.cybase.co.uk> wrote in message
news:O0WRakQkEHA.4092@.TK2MSFTNGP10.phx.gbl...
> Can anyone recommend a good book or site on Full Text Searching which goes
> into detail about things like full text ranked search across multiple
tables
> especially using phrases not single words? I find the whole thing counter
> intuitive compared to normal SQL
>

Book recommendation on performance

I have the Transact-SQL Programming book from O'Reilly. It was
published in 1999. It states that "SELECT ... INTO" statements end up
locking the entire database of the target table. Since the tempdb is
also involved (in many cases), this creates major deadlocks for the
entire database and all users. It suggests using the "INSERT ...
SELECT" form instead.

Considering that the book is somehow dated, is this recommendation
still valid, especially on target sizes of up to 5 million records?php newbie (newtophp2000@.yahoo.com) writes:
> I have the Transact-SQL Programming book from O'Reilly. It was
> published in 1999. It states that "SELECT ... INTO" statements end up
> locking the entire database of the target table. Since the tempdb is
> also involved (in many cases), this creates major deadlocks for the
> entire database and all users. It suggests using the "INSERT ...
> SELECT" form instead.
> Considering that the book is somehow dated, is this recommendation
> still valid, especially on target sizes of up to 5 million records?

To a large extent, no. The author seems to have had SQL 6.5 in mind, where
SELECT INTO a temptable, indeed to bring a server to a stand still. The
problem is that SELECT INTO creates the temp table, and then goes on to
fill it with data. Since the query is one transaction, it keeps a lock on
the system tables until the query has completed. This was fatal in SQL 6.5
which only had page locks. In SQL7 and SQL2000 where you have row locks,
the impact on other processes is much smaller.

The advantage of SELECT INTO is that is that is minimally logged, so
SELECT INTO #tmp for five million rows can be faster and take less
toll on the server than CREATE TABLE INSERT INTO.

Nevertheless, there are contexts where SELECT INTO is an inferior choice
over CREATE TABLE not talking about a table variable. Say that you already
have a transaction in progress, and you creating many small tables
repeatedly within this transaction. SELECT INTO takes out more locks on
than CREATE TABLE, so you acquire a whole lot more locks with SELECT
INTO, and this can have an impact on performance. Case in point: I had
a procedure which suddently started to perform much slower than before.
This procedure performs some complex data updating in an iterative
fashion. My profiling pointed to a seeminginly innocent query which
appeared to take longer and longer time as the procedure proceeded.
Eventually I found the answer in a trigger (which was not affected by
this query). I had replaced direct deferences to "inserted" with temp
table created through "SELECT * INTO #inserted FROM inserted".

To summarize: SELECT INTO is fine for single-time queries on large
tables. It is bad to have in triggers in tables which maninly are
updated one row at a time.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Book Recommendation for SRS2005 Designing Reports

Hi,
Does anyone have any book recommendations for designing Reports? I am
looking for a book that covers the basics but also moves onto more
advanced examples.
Thanks.I just picked up "Microsoft SQL Server 2005 Reporting Services 2005" by
Brian Larson (McGraw Hill). The ISBN is 0-07-226239-7. It was highly rated
on Amazon and it's turned out to be excellent.
"Gareth King" <QBVBKADUOIUJ@.spammotel.com> wrote in message
news:WtFKf.111376$AL5.53955@.fe01.news.easynews.com...
> Hi,
> Does anyone have any book recommendations for designing Reports? I am
> looking for a book that covers the basics but also moves onto more
> advanced examples.
> Thanks.

Book recommendation

I have begun to try to break out of using Access db's (97!) and have been trying out SQL Server Express 2005 along with the SQL Management Studio Express. I am a little confused with it as I am trying to use the interface inside of VB.NET 2005 as well as the management studio and sometimes I can connect from one without the other.

Anyway this points to the fact that I have a lot to learn and I was looking for a recommendation for a book that could be a tutorial for using VB.NET 2005 with SQL Server Express. I really need something that starts from square one but hopefully builds fast. Right now it appears I need to understand connection strings (when do I put ".\sqlexpress" and when do I use the server name followed by the instance for example?).

I have tried some of the books online for example and ran into a dead end with the simple tutorial (http://msdn2.microsoft.com/en-us/library/ms165732.aspx) when the headers didn't sort, I couldn't select any other pages and the edit button didn't work. I don't have a clue what happened as I followed the instructions.

Anyway if someone could recommend something that teaches using SQL Server Express while building an application with VB2005 that would be perfect.

Dana

There are a TON of books that would help you (as I have read about .5 of them and believe or not I collect them...hey i love what I do :)). Anyway as a Wrox author I recommend the following two titles:

http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764595733.html

http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764589237.html

and if you want to learn SQL Server 2005's CLR integration one day then this one :)

http://www.wrox.com/WileyCDA/WroxTitle/productCd-0470054034.html

|||Derek,

Just wanted to follow up on your recommendation and say thank you. I purchased the WROX SQL Server Express Starter Kit you recommended as well as a book called Beginning SQL Server Express by Rick Dobson (mainly because Amazon gave me a package deal.. brilliant marketing move!) and although I am only beginning to read them they are exactly what I wanted .. something that starts from the very beginning and moves along fairly quickly.

My problem has been that I have lived Access97 until this so I really needed to start with a very basic understanding of the daunting world of the "server databases" and the associated management tools, leaving my cocoon of saved queries and linked tables behind and learning connection strings and stored procedures instead. This should get me on track so thank you for taking the time to reply.

Danasql

Book Recommendation

Everyone,
Could someone please recommen some good books for SQL clustering over
Win2K3?
Thank you.
Start here
http://www.amazon.com/gp/product/073...lance&n=283155
hope this helps
...Edwin.
"Dragon" wrote:

> Everyone,
> Could someone please recommen some good books for SQL clustering over
> Win2K3?
> Thank you.
>
>
|||hmmm, Thank you Edwin.
Is there any book for SQL 2005 instead of 2000?
"Edwin vMierlo" <EdwinvMierlo@.discussions.microsoft.com> wrote in message
news:9A17EEBA-1E37-4F59-ABF9-9F22C88AD07D@.microsoft.com...[vbcol=seagreen]
> Start here
> http://www.amazon.com/gp/product/073...lance&n=283155
> hope this helps
> ...Edwin.
> "Dragon" wrote:
|||Not yet. The 2005 books are in the process of being written.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Dragon" <baadil_nospam@.hotmail.com> wrote in message
news:Oho2FwMVGHA.4884@.TK2MSFTNGP10.phx.gbl...
> hmmm, Thank you Edwin.
> Is there any book for SQL 2005 instead of 2000?
> "Edwin vMierlo" <EdwinvMierlo@.discussions.microsoft.com> wrote in message
> news:9A17EEBA-1E37-4F59-ABF9-9F22C88AD07D@.microsoft.com...
>
|||Thank yuo Michael.
"Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
news:O7VsGUhVGHA.4952@.TK2MSFTNGP09.phx.gbl...
> Not yet. The 2005 books are in the process of being written.
> --
> Mike
> http://www.solidqualitylearning.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
>
> "Dragon" <baadil_nospam@.hotmail.com> wrote in message
> news:Oho2FwMVGHA.4884@.TK2MSFTNGP10.phx.gbl...
>

Book recommendation

I have begun to try to break out of using Access db's (97!) and have been trying out SQL Server Express 2005 along with the SQL Management Studio Express. I am a little confused with it as I am trying to use the interface inside of VB.NET 2005 as well as the management studio and sometimes I can connect from one without the other.

Anyway this points to the fact that I have a lot to learn and I was looking for a recommendation for a book that could be a tutorial for using VB.NET 2005 with SQL Server Express. I really need something that starts from square one but hopefully builds fast. Right now it appears I need to understand connection strings (when do I put ".\sqlexpress" and when do I use the server name followed by the instance for example?).

I have tried some of the books online for example and ran into a dead end with the simple tutorial (http://msdn2.microsoft.com/en-us/library/ms165732.aspx) when the headers didn't sort, I couldn't select any other pages and the edit button didn't work. I don't have a clue what happened as I followed the instructions.

Anyway if someone could recommend something that teaches using SQL Server Express while building an application with VB2005 that would be perfect.

Dana

There are a TON of books that would help you (as I have read about .5 of them and believe or not I collect them...hey i love what I do :)). Anyway as a Wrox author I recommend the following two titles:

http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764595733.html

http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764589237.html

and if you want to learn SQL Server 2005's CLR integration one day then this one :)

http://www.wrox.com/WileyCDA/WroxTitle/productCd-0470054034.html

|||Derek,

Just wanted to follow up on your recommendation and say thank you. I purchased the WROX SQL Server Express Starter Kit you recommended as well as a book called Beginning SQL Server Express by Rick Dobson (mainly because Amazon gave me a package deal.. brilliant marketing move!) and although I am only beginning to read them they are exactly what I wanted .. something that starts from the very beginning and moves along fairly quickly.

My problem has been that I have lived Access97 until this so I really needed to start with a very basic understanding of the daunting world of the "server databases" and the associated management tools, leaving my cocoon of saved queries and linked tables behind and learning connection strings and stored procedures instead. This should get me on track so thank you for taking the time to reply.

Dana

Book recommendation

Looking for an overview book on SQL Server 2000, can anyone recommend a Titl
e
or Good author?
Id like to learn the basics and how to use query analyser to manager the
database setup. Also the book can show what are the SQL functions (such as
date manipulation) and how to use them.
Thanks.What about Books Online?
Roji. P. Thomas
Net Asset Management
http://toponewithties.blogspot.com
"JD" <JD@.discussions.microsoft.com> wrote in message
news:2F1B2593-E3E9-4782-808B-FDF32F04668E@.microsoft.com...
> Looking for an overview book on SQL Server 2000, can anyone recommend a
> Title
> or Good author?
> Id like to learn the basics and how to use query analyser to manager the
> database setup. Also the book can show what are the SQL functions (such as
> date manipulation) and how to use them.
> Thanks.
>|||Also
http://vyaskn.tripod.com/sqlbooks.htm
Madhivanan|||If I had to choose 1 book besides BOL this would be it
The Guru's Guide to Transact-SQL
by Ken Henderson
http://www.amazon.com/exec/obidos/t...=glance&s=books
http://sqlservercode.blogspot.com/

Book recommendation

Hi,
I am not sure which book to buy: Hitchhiker's Guide to SQL Server 2000
Reporting Services
or
Professional SQL Server Reporting Services -- by Paul Turley
I need a book that will also show me for example how to pass parameters from
asp.net to rss. I want the user to select parameters from asp.net and pass
those parameters to the stored procedure in the report.
ThanksI use the Wrox book (as you mentioned) and also SQL Reporting Services Step
by Step - by Microsoft. Both deal, in depth, with design, deployment and
server administration.
Depending on how you want the report to open from your aspx page, you can
simply use the URL for the RS report, and pass the parameters in that (that's
how RS does it), to open the report only, without any fuss. I also use
buttons on my ASP pages to render the report in PDF/Excel etc immediately
without having the user required to 'export' it themselves.
Tony
"collie" wrote:
> Hi,
> I am not sure which book to buy: Hitchhiker's Guide to SQL Server 2000
> Reporting Services
> or
> Professional SQL Server Reporting Services -- by Paul Turley
> I need a book that will also show me for example how to pass parameters from
> asp.net to rss. I want the user to select parameters from asp.net and pass
> those parameters to the stored procedure in the report.
> Thanks

Book recommendation

Can someone please recommend a good book for SQL Server 2000 for a
programmer(Powerbuilder), not a DBA.Hi,

I have authored a book about developing complete applications using
VB.Net and SQL Server 2000. Our effort has been to teach the reader
how to develop complete database applications. (The application we
have considered is an Accounting Application).

Many of the topics like implementing double entry rules, vouchers,
invoices etc have been taught.

If this interests you do visit http://www.vkinfotek.com, and you will
find a list of topics. If you have any questions, do not hesitate...

Regards
Bharati
http://www.vkinfotek.comsql