sql server - What steps should be necessary to optimize a poorly performing query? -

-

i know broad question, i've inherited several poor performers , need optimize them badly. wondering common steps involved optimize. so, steps of guys take when faced same situation?

related question:
what generic techniques can applied optimize sql queries?

  1. look @ execution plan in query analyzer
  2. see step costs most
  3. optimize step!
  4. return step 1 [thx vinko]

Comments

Post a Comment

Popular posts from this blog

windows - Why does Vista not allow creation of shortcuts to "Programs" on a NonAdmin account? Not supposed to install apps from NonAdmin account? -

-
i'm working on installer (using wise installer, older version 1999). i'm creating shortcut in programs group exe. i'm creating shortcut on desktop. if install run admin account, create shortcut on common desktop , common program group (i.e., read hkey_local_machine\explorer\shellfor users). if it's installed nonadmin account, install hkey_current_user's desktop , program group. behavior install on: xp nonadmin - desktop , program shortcuts install ok. vista admin - desktop & program shortcuts install ok. vista non-admin, uac off - desktop shortcut installs, program shortcut not . however, program group folder they're supposed installed does created. at end of install, launch program group has shorcut. launches in of above. can manually drag shortcut folder , works fine. i'm bloody baffled. i've tried installing other commercial apps (opera, foxit, firefox) firefox install under nonadmin (and if select other program files,...
Read more

c# - Setting Server Bindings of IIS 6.0 Programmatically -

-
i'm trying set installer register web site. currently, i've got creating application pool , web site under windows server 2003. unfortunately, whenever try modify serverbindings property set ip address, throws exception @ me. first tried because documentation here told me http://msdn.microsoft.com/en-us/library/ms525712%28vs.90%29.aspx . i'm using vb.net, c# answers okay need switch on using c# anyway. siterootde.properties.item("serverbindings").item(0) = "<address>" this throws argumentoutofrangeexception. checked it, , server bindings of size 0. when tried create new entry in list this: siterootde.properties.item("serverbindings").add("<address>") i comexception when try that. i looked @ registered property keys, , serverbindings found. however, when create web site through iis, generates serverbindings correctly , can see it. what need serverbindings appear? edit: moved code on c# , tried it. seems re...
Read more

What do you think are the useless tags in HTML? -

-
as moving on html5, there tags hold least importance did in past.for example <dl> defination list, dont remember last time used tag. and not this, there tags have better , more efficient versions or clear redundancy <strong> , <b> , <basefont> , <font> etc. in opinion, tags developer can live out with?, , tags can ignored? because have better version. it suggested make answer, here excellent page discusses tags , attributes should avoided in html5 pages, , why, though doesn't include elements blink tag. http://www.html-5.com/avoid/
Read more