September 13, 2016 at 5:22 am
Please share the important tricks related to Optimization
1.How to decrease the logical reads of existing query
2.How to reduce execution time of existing queries
3.Way's of writhing new queries
4 .DBA activities related to query optimization
September 13, 2016 at 6:15 am
That's a huge topic. More a book than a forum thread.
https://www.amazon.com/SQL-Server-Query-Performance-Tuning/dp/1430267437/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 13, 2016 at 7:16 am
Another good book:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 14, 2016 at 2:07 am
Thank's to all for provide such information
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy