From IT Skills
Jump to: navigation, search

by creating correct scripts[edit | edit source]

  1. IF-THEN inside of called SPs and FNs
  2. sophisticated caching
  3. reducing data to show for user on UI
  4. Temp Table and Table Variable — both are created in TempDB and not in memory.
  5. Курсор – это почти всегда дополнительные ресурсы сервера и резкое падение производительности по сравнению с другими решениями.
  6. check parallelism
  7. indices quantity. 6 seems are maximum to be efficient

by increasing MS Sql server power[edit | edit source]

  • if to load a database with many locks then other databases of the same sql instance gets slow too

This category currently contains no pages or media.