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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply