Improvising Database to better perfomances

• farooq.hbs

  SSCrazy

  Points: 2083

  More actions

  February 8, 2011 at 12:15 am

  #97643

  Hi all,

  Need a help Regarding to improvising database performance and optimizing query with example so tht i can unds better n implement into my project..

  Thanks in Advance

• M&M

  SSC-Insane

  Points: 21700

  More actions

  February 8, 2011 at 12:26 am

  #1283546

  This is a generic question. Please be more specific on what you are looking for.

  M&M

• farooq.hbs

  SSCrazy

  Points: 2083

  More actions

  February 8, 2011 at 12:32 am

  #1283549

  Thanks for responce moin bhai,

  i mean index optimization to the database for improving the performances..

  For Example... For An ERP Application,,Table contains N number of datas in it... to retrieve data from table it gets time for the end user.. So to retrive the data fastly, Need a help from u....

  I hope u got an idea

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  February 8, 2011 at 1:08 am

  #1283555

  That's a vague question. Entire books have been written on the subject.

  Start with these:

  http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

  http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

  Then consider Grant Fritchey's book:

  http://www.amazon.com/Server-Performance-Tuning-Distilled-Experts/dp/1430219025/

  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

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass