Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Improvising Database to better perfomances Expand / Collapse
Author
Message
Posted Tuesday, February 8, 2011 12:15 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 26, 2014 3:04 AM
Points: 113, Visits: 190
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
Post #1060046
Posted Tuesday, February 8, 2011 12:26 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, October 16, 2014 2:12 PM
Points: 2,278, Visits: 3,798
This is a generic question. Please be more specific on what you are looking for.

Mohammed Moinudheen
Post #1060050
Posted Tuesday, February 8, 2011 12:32 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 26, 2014 3:04 AM
Points: 113, Visits: 190
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
Post #1060053
Posted Tuesday, February 8, 2011 1:08 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 2:09 PM
Points: 40,193, Visits: 36,597
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 2008, MVP
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

Post #1060062
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse