Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-03-22 : 08:41:07
|
| Keri writes "I am still a SQL newbe, but have learned a lot in the past year. I am not creating databases, nor maintaining our SQL Server 2000. I am a report writer and use Query Analyzer for the base of my reports. I use Actuate to develop the reports. My question is, i am interested in getting a book that covers more advanced querying. I have the book The Guru's Guide to Transact-SQL, but am intested in other books to further my growth and education in SQL. Can you suggest some books that deal with queries-advanced primarily since i really am not designing or maintaining the DB. Thanks for any information you can give. Sincerely, Keri Taylor" |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-03-22 : 09:06:07
|
| Keri Taylor,Welcome to the SQLTeam. Somebody else may give you some hints of a book. My advice is to visit this site & similar SQL development forums regularly, where you will find all interesting things that you might get in your life and more in SQL Queries & T-SQLGood Luck |
 |
|
|
druer
Constraint Violating Yak Guru
314 Posts |
Posted - 2006-03-22 : 09:37:58
|
| The best way to learn is to dig in and try to help others. I find that the more I think I know, I realize that my knowledge is based only on my past experienced and each day someone asks a question totally off the wall to me that forces me to learn more about TSQL. Jump in and try to answer others questions. Others might have different answers, which doesn't mean that 1 is right or wrong, but that each developer came at the problem from a different direction. You can then take your solution and theirs and try to compare them by execution plans to understand more about the performance behind things. Writing TSQL code that actually performs rapidly is "advanced". |
|
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-03-22 : 09:54:19
|
| I totally agree with druer (in fact, what I meant by visiting these forums is, participating in answering, asking questions etc.). Its not that effective if u go thru a book and do some samples. Here you will find more of practical problems and diffrernt approaches and views.Another thing that I developed (which is beneficial to me in great extent of course) is building a document with all the new things I found (If its taking too long, just the URL).When I have some free time, I'm going thru that doc, to refresh my memory and whenever me or another person needs a solution to a prob, I quickly go thru my doc & find it.Its a kind of a short note or my personal SQL Study Notes.Finally I must say, this site (the gurus who answers the Qs often and the questions asked by even newbies), helped me a lot to develop my in MS SQL server knowledge. |
|
|
|
Sim
Starting Member
12 Posts |
Posted - 2006-03-28 : 16:48:20
|
| Keri,I'm in a similar position. I have nothing to do with maintaining the db, I only extract information from it and run statistical analysis. The problem seems to be that beyond conversions and syntax so many of the hurdles associated with writing queries are unique to the architecture of your db. |
|
|
|
|
|
|
|
|
Advanced Queries