learning how to tune T-SQL query ASAP

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

And also
https://technet.microsoft.com/en-us/library/ms365303.aspx

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER

HuaMinChen,

it seems that this one : https://technet.microsoft.com/en-us/library/ms365303.aspx only a very basic resource on how to write T-SQL , but not the best way to write it and turn it.

PadawanDBA,

I have some reference here, please tell me which one is necessary other than the one you propose, your is better or I need more by buying any of this below:

1) http://www.amazon.com/gp/product/1782172556/ref=ox_sc_sfl_title_2?ie=UTF8&psc=1&smid=ATVPDKIKX0DER
2) http://www.amazon.com/gp/product/1430259620/ref=ox_sc_sfl_title_6?ie=UTF8&psc=1&smid=ATVPDKIKX0DER
3) http://www.amazon.com/gp/product/1430237414/ref=ox_sc_sfl_title_9?ie=UTF8&psc=1&smid=ATVPDKIKX0DER
4) http://www.amazon.com/gp/product/1499321732/ref=ox_sc_sfl_title_2?ie=UTF8&psc=1&smid=ATVPDKIKX0DER
5) http://www.amazon.com/gp/product/1499529597/ref=ox_sc_sfl_title_8?ie=UTF8&psc=1&smid=ATVPDKIKX0DER
6) http://www.amazon.com/gp/product/0991638670/ref=ox_sc_sfl_title_10?ie=UTF8&psc=1&smid=ATVPDKIKX0DER

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

ASKER

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?

Yes, there are references like
http://www.databasejournal.com/features/mssql/article.php/3087431/T-SQL-Programming-Part-1---Defining-Variables-and-IFELSE-logic.htm
http://www.blackwasp.co.uk/sqlprogrammingfundamentals.aspx
https://technet.microsoft.com/en-us/library/ms189826%28v=sql.90%29.aspx

ASKER

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.

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/)

ASKER

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 ?

ASKER

PadawanDBA,

this one http://www.amazon.com/Microsoft-High-Performance-Functions-Developer-Reference/dp/0735658366/)' has one for SQL server 2014 ?

There were no changes to window functions in 2014, so it's all 100% valid.

ASKER

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.

ASKER

so that book is purely for Windows application developer on MS SQL server?

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.

ASKER

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 ?

ASKER

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?

ASKER

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?