learning how to tune T-SQL query ASAP

Dear all,

right now focusing on T-SQL tuning in order to make myself more as Application DBA and some expertist here suggest the following books for me on data modelling:

http://www.amazon.com/gp/product/1449316409/ref=ox_sc_act_title_3?ie=UTF8&psc=1&smid=ATVPDKIKX0DER

http://www.amazon.com/gp/product/012802044X/ref=ox_sc_act_title_4?ie=UTF8&psc=1&smid=ATVPDKIKX0DER

http://www.amazon.com/gp/product/1118530802/ref=ox_sc_act_title_5?ie=UTF8&psc=1&smid=ATVPDKIKX0DER

but all those is only focusing on data modelling but not quickly jump into turn the query ASAP and then let me have time to read logic and theory later on in order to catch up.

any Link/Books that make me dig into necessary detail ASAP and find out what index has to add and what the optimizer is looking for and implement that ASAP so that big boss is not complain anymore and then I will go back to the theory on how to change the SQL developer in a better way ( this can take months to change it but not at that moment),

LINk is hightly prefer as I can save paper but good books from beginning to expertist is welcome if no choice.

query indexing and query parallel execution is the one I want as it will be the direction, right?
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

HuaMin ChenProblem resolverCommented:
0
Acronis Data Cloud 7.8 Enhances Cyber Protection

A closer look at five essential enhancements that benefit end-users and help MSPs take their cloud data protection business further.

PadawanDBAOperational DBACommented:
Anything written by Itzik Ben-Gan is wonderful: http://www.amazon.com/T-SQL-Querying-Developer-Reference-Ben-Gan/dp/0735685045/.  I am working through this fella' as we speak.  He blends the logic and the practical application at the same time, btw.  And I would heartily recommend against separating the two - that's how you develop bad habits and write terrible queries.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
HuaMin ChenProblem resolverCommented:
I think these

Expert Performance Indexing for SQL Server 2012
SQL Server 2014 Design & Programming
SQL Server Tuning Scripts: Performance Optimization Secrets (IT In-Focus)

are good
0
marrowyungSenior Technical architecture (Data)Author Commented:
but do you know the author ?

books from him/she is good ?

you know if your links or links here are enough , I should avoid to buy books to save tree, right?
0
marrowyungSenior Technical architecture (Data)Author Commented:
no. I mean links to write T-sQL / SP/ UDF in a way that is much faster and SQL server prefer to see this query as it will be fastest (like no cursor , while loop to loop out record one by one but bulk insert/select)

and that's why I said query indexing and query parallel execution is the one I want as it will be the direction.

any other suggestion ?

In this way I will just search for lowest top x query and then site down with developer and provide guideline to them base on that.
0
PadawanDBAOperational DBACommented:
I don't know any of the authors from those books.  That doesn't necessarily mean anything, but I think the reviews on some of those are telling, however.  I am totally biased, as I have built my T-SQL foundation from Ben-Gan books, but I think his material on T-SQL is by far the best available (fyi, the query tuning chapter in Ben-Gan's book is 140 pages).  Like I said, I am totally biased in my opinion of T-SQL books, but Ben-Gan's window functions book is also a great, albeit more advanced, book on high performing T-SQL (http://www.amazon.com/Microsoft-High-Performance-Functions-Developer-Reference/dp/0735658366/)
0
marrowyungSenior Technical architecture (Data)Author Commented:
PadawanDBA,

" high performing T-SQL (http://www.amazon.com/Microsoft-High-Performance-Functions-Developer-Reference/dp/0735658366/)'

Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions (Developer Reference)

mean call T-sQL from within Windows application and this books shows how can we make it as fast as we can ?
0
marrowyungSenior Technical architecture (Data)Author Commented:
0
PadawanDBAOperational DBACommented:
There were no changes to window functions in 2014, so it's all 100% valid.
0
marrowyungSenior Technical architecture (Data)Author Commented:
tks. very good.

but one thing in mind, that book is about pure Microsoft Development platform but not java, how about java application connect using JDBC, I tried this before and I don't know how to turn it.
0
marrowyungSenior Technical architecture (Data)Author Commented:
so that book is purely for Windows application developer on MS SQL server?
0
PadawanDBAOperational DBACommented:
I'll have to defer to someone else on app dev in various environments, that's not really my thing.  The books I mentioned are purely T-SQL querying on MS SQL Server.
0
marrowyungSenior Technical architecture (Data)Author Commented:
ok, tks,

so you are infrastruture side DB professional ?

as I am going to be an application DBA, I need many of this as reference.

any diff between your books and this http://www.amazon.com/gp/product/1449316409/ref=ox_sc_act_title_3?ie=UTF8&psc=1&smid=ATVPDKIKX0DER  ?
0
marrowyungSenior Technical architecture (Data)Author Commented:
also the T-SQL query is about tuning query, any books about advance T-SQL Query tunning that make use of any special feature of SQL server 2008 R2 and afterwards that focus on the way to write T-SQL query, like parallel execution?
0
marrowyungSenior Technical architecture (Data)Author Commented:
any advance tuning guide/books for same function but less coding on T- SQL so faster model?

any guide for parallel execution T-SQL programming guide?
0
marrowyungSenior Technical architecture (Data)Author Commented:
sorry close very late and I am ready to buy them.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.