Good Book On Sql Admistration And Performance ?
Mar 26, 2001Hello
Would you please point again on good book for admistration
Thanks
ADVERTISEMENT
Good SQL Book
May 30, 2007hello
i am just starting to learn sql and know the basics, but now im looking for a good book to learn some more. A book that covers stored procedure would be very useful. If possible a book with q and a would be very good because i feel this tests if u understand what was just explaned. but if there is a good book without this it is ok. All sugestions welcome
NubNub
Good Book For Using DTS?
Aug 23, 2000I have been using DTS somewhat, but I would like to read a good discussion (with cpmplex examples) of it.
Anyone found either a book on DTS or a good section in a book?
Thanks,
Judith
Need A Good Book...
Apr 27, 2004I've been a SQL Server dba for 5 or 6 years now. With the upcoming release (eventually, I'm sure) of Yukon/SQL2005, I've read that it's important for DBA's to pick up one of the .NET languages - I've figured, I'll try to learn VB.NET - I've had a little exposure to it, and can usually figure out what's going on in VB code I've read - however, I seriously doubt I could write anything in it from scratch - I want to learn it in a bad way - can you all recommend any self-paced books that will walk me thru it? I've never had any formal training with it, don't know a class from a DLL....Thanks in advance for your help!!
View 3 Replies View RelatedGood SQL Book?
Jul 20, 2005hello, for a new job i might have to learn SQL. i've neverworked with databases or SQL, so i'll need to learn. cananybody advice me on what would be a good book to learnfrom? i'm quite an experienced programmer, so it doesn'thave to be a dummies guide, and preferably not a bulky booklike the "SQL bible" or something.oh, one of my 'favourite' computer books of all times is"thinking in Java" by bruce eckel, to give you an idea.mike--not sure if there's a better group to ask these questions
View 4 Replies View RelatedI'd Like To Get A Good Book Of SQL...
Apr 20, 2006Would all of you give me a suggestion of valuable book in terms of SQL ??
I confused what kind of SQL book is going to be good for me to study since
I begin to jump into MS-SQL...
Furthermore, I'd know that various level of book as begginer, intermediate , advance...
Thanks for your help in advance..
Web Developer Looking For Good SQL Book
Jan 6, 2007I'm looking to buy a book about SQL, T-SQL, stored procedures, etc. I'm a web developer, so I don't need a book for a SQL Server administrator. I need a book that tells me what I as a developer need to know about SQL. I'm currently using Visual Studio, SQL Server 2005, ASP.NET 2.0, and VB.NET (and fairly new to all of those) if that makes any difference. The bulk of my web developing experience has been with PHP and MySQL so this is new territory for me. I hope all that makes sense. I would appreciate any suggestions for such a book.
Thanks!
-Mathminded
p.s. I bought a bunch of Wrox books and haven't had them long enough to decide if I like them: "Professional ASP.NET 2.0", "Professional ASP.NET 2.0 Security, Membership, and Role Management", "ASP.NET 2.0 Website Programming", and "Visual Basic 2005". I thought I'd check with the experts before investing in another book. :-)
A Good SSIS Book?
Jan 7, 2007I am new to SQL2005 and have been given the task of writing some SSIS packages to import some CSV files.
I need to cleans the data as it is imported from my CSV files before it reaches my SQL DB.
I am currently Googling the internet to discover how to do this.
Can anyone recommend a good SSIS book?
I am a C# developer, so a book that has lots of SSIS C# examples would be good.
Any help appreciated.
Regards,
Paul.
Need A Good Book On Replication????
Jul 31, 2000Anyone has a suggestion on a good book on Replication. How to set it up.. I am looking for a good detailed book on this subject.
View 2 Replies View RelatedA Good Book On SP, Functions
Dec 13, 2007Can anyone recommend a good book on Stored procedure, Functions, triggers ..Etc??
Thank you
Good Book About MS-SQL Replication...
Jul 20, 2005Hi,Does anyone know any good book(s) about MS-SQL, especially aboutReplication - basically, I need in-depth explanation about how tosetup/maintain Snap Shot, Transactional, Merge Replication anddifferent agents - with good examples? Hopefully, the book(s) isrecent enough to cover SQLCE merge replication as well. In-depthinformation about DTS is a plus ^_^Just tired of print hundreds of pages from MSDN site.Thanks,Charlie Chang
View 1 Replies View RelatedLooking For A Good Book On SSIS 2005
Mar 13, 2007Anyone know a good book on SSIS. I need a good beginer book on SSIS 2005 I am very interested in using it for capturing data from other database and loading that data into the database that I'm working on . Weather it be from another database, textfiles, spread sheets. Any suggestion.
View 1 Replies View RelatedGood Book About Stored Procedure
Mar 5, 2008Hi:
Can you please recommend 1-2 good books about "stored procedure", I need a book which starts from basic and goes to developed level.
Thanks.
Jt
Anyone Know Of A Good T-Sql Reference Code Book?
Nov 6, 2003Hi does anyone know of a good book that has all the t-sql keywords and functions in?? Or a webiste that has a printable version with explanations. I knows its on msdn but its very hard to print it all off.
I need something by my side so I can refer too and use in helping me build statements and sp,s etc.
Thanks
Best Book To Gain Good Knowledge In DBA
Feb 26, 2007Dear Friends,
please suggest me the best book to gain sound knowledge in DBA concepts as well as
writing in sub queries, complex queries as well as inner queries.
thank you very much
Vinod
Good Integration Services Book
Apr 3, 2006ive been learning through books online, but i just find learning from a book is better for me. have any of you bought books on integration services and if so , would you recommend them?
View 4 Replies View RelatedReporting Services, Good SQL 2005 Book
Jan 28, 2006What are reporting services? i know asp or something like that, do i have to use asp? or can i use crystal Rpts?
Can anyone offer a good book on SQL Serv 2005?
Good Book For Learning The Stored Proc Language
Jul 12, 2007Though I have been using SQL Server for some years, it is just recently that I have need to learn how to write SP's. I would like a recommendation for a book that is rich with examples (my best learning style).
Many thanks...
Todd
SQL Server 2000 Book Recommendations? Including Good Coverage Of Reporting Services
Jul 23, 2005What up-to-date books on this topic can people here recommend? Thanks.- Bob
View 1 Replies View RelatedBook Recommendation On Performance
Jul 20, 2005I have the Transact-SQL Programming book from O'Reilly. It waspublished in 1999. It states that "SELECT ... INTO" statements end uplocking the entire database of the target table. Since the tempdb isalso involved (in many cases), this creates major deadlocks for theentire database and all users. It suggests using the "INSERT ...SELECT" form instead.Considering that the book is somehow dated, is this recommendationstill valid, especially on target sizes of up to 5 million records?
View 1 Replies View RelatedSql Server 2005 Performance Tuning Book
Aug 26, 2007Hello everyone ,
I am looking for an useful sql server 2005 performance tuning book. i have been searching for a real nice book as i m going to start my job from next month in a financial domain with one of the requirement as sql server 2005 performance tuning.so i m looking forward a book which can help me doing well at my workplace. Any suggestions and links appreciated in advance .
Windows OS Good For SQL Server Performance
Apr 11, 2008
Hello,
I need to choose the OS, for my SQL Server Database where performance is important and will be used on a regular basis of two hours.
Should we go for 32 bit or 64 bit processor?
How much RAM should be used 2 or 4GB ?
Should we use SAN, RAID or local disk , which one of them and why?
I need to tell the owner by Monday.
thanks,
Priyanka
How To Count Distinct Members And Keep Good Performance
Mar 26, 2007Hi all,
I have a simple cube with only one measure : "Amount", I have three dimensions Supplier, Category and Company.
I would like to display a matrix with Categories as rows, company as columns, the amount and the number of distinct suppliers who appaers for each category/company.
I tried to create a calculated measure like this:
Count(Crossjoin({[D Supplier].[Supplier Code].members}, {[Measures].[Amount]}), EXCLUDEEMPTY)
The result is OK, but when I add this calculated Measure to my query the execution time jumps from a few seconds (<10) to a few minutes. Am I missing something ?
Anyone have an idea to do this in a better way ?
DTS Book
Jul 19, 2000Can anyone recommend a good book on DTS?
View 1 Replies View RelatedNew DTS Book
Feb 23, 2001For those of us struggling with DTS, you've probably all seen
Professional SQL Server 2000 DTS
Mark Chaffin, Brian Knight, and Todd Robinson
WROX
ISBN 1-861004-41-9
This is brand new:
Microsoft SQL Server 2000 DTS
Timothy Peterson
SAMS
ISBN 0-672-32011-8
I have both and they're both worth owning.
I also just found a reference to the following, but I haven't seen it so I count vouch for it. (I also wonder why I haven't stumbled across it previously...)
Professional SQL Server 7.0 Development Using SQL-DMO, SQL-NA and DTS
Frank Miller & Rachelle Reese
WROX
ISBN 1861002807
Book
Jul 27, 2004I read alot of Technical books on SQL and I have found that SQL for dummies is actually a pretty good book(nice reference)
View 1 Replies View RelatedGot Done W/ Book, Anyone Want It ?
Mar 9, 2004I really like to pass my books on, for small price to anyone who could use them, since I no longer need 'em. I've got one , the SQL 2000 Administrator's Companion. Please take a look, I put it on ebay:
http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&category=36313&item=3593450436
Thanks
/rob
BEST SQL BOOK
Apr 15, 2008Ok, look. I could sit here and ask about 1,000 different queries that I would like to have. I'd much rather prefer to find it on my own however. Could someone please recommend a book that will tell me all I need to know about performing different kinds of queries? I have limited Mysql, JavaDB experience. A beginner compared to most of you. Thx in advance for any replies.
View 2 Replies View RelatedBook
Sep 6, 2007Hi
Which is the best book to refer for SQL Server 2005
thanks
The Best Book
Jul 20, 2005Hi to all, I ask to everybody which is the best book of the MS SQl Server 2000.I search in particulary a book complete and advanced.ThanksAlex Palermo
View 6 Replies View RelatedBook
May 30, 2006It seems that there are only two books on SSIS
The Rational Guide to Scripting SQL Server 2005 - BETA preview
Professional SQL Server 2005 Integration Services by wrox
Has anyone read these or any other ones out there?
Any thoughts on which to get?
I am very new to SSIS.
Thanks
Book
Feb 4, 2007Hi,
Can you recommend a book on SSIS.
I am particularly interested in books which demonstrate a particular project from start to finish while going through chapters.
Thanks
E-Book
Nov 14, 2007Hi I tried to download the E-Book that is located on the benefits page, when i click to save it to hard drive it just sits and nevers start the process. What can I do to correct this matter. Thank you for you time and effort.
DKB