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

link or website for Performance tuning and optimizing query Expand / Collapse
Author
Message
Posted Monday, December 14, 2009 4:02 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 12:26 AM
Points: 2,840, Visits: 3,963
hi

can anubpdy tell me any
link or website for Performance tuning and optimizing SQL 2005 query ?

i need to learn this



-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #833700
Posted Monday, December 14, 2009 5:18 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, August 28, 2014 2:39 AM
Points: 1,904, Visits: 2,846
http://msdn.microsoft.com/en-us/library/ms979196.aspx
http://www.sql-server-performance.com/

and the list can go on....


----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.
Post #833735
Posted Monday, December 14, 2009 5:22 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 12:26 AM
Points: 2,840, Visits: 3,963
thanks
but i am talking about tuning Sql queries


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #833737
Posted Monday, December 14, 2009 6:56 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, July 28, 2014 1:07 PM
Points: 579, Visits: 1,807
I was going through one white paper recently and thought its good. A lengthy one but discusses lot of aspects with performance tuning.
(May be more suited for a DBA and not developer as its not concentrated around tuning the queries only)

http://technet.microsoft.com/en-us/library/cc966540.aspx#EDAA


---------------------------------------------------------------------------------
Post #833788
Posted Monday, December 14, 2009 9:22 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 @ 8:51 AM
Points: 42,843, Visits: 35,971
Start with this two-part series. Finding the problem is more than half the battle.
http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

I doubt there's a single, comprehensive site that covers everything. The links given earlier are good but that's far from everything. Read blogs, articles and performance questions here. Grant Fritchey's book (link in his sig) is a very good resource.



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 #833937
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse