SQL Server 2005 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• SQL testing

  hi all i will soon be moving our sql instance to a dedicated SAN, and i have 1 week to test. ill t…

  dopydb

  6 replies

  15 years, 5 months ago

  By: chrisfradenburg

• Index Question - Determining When An Index Is More Overhead Then Benefit

  I've been tracking and storing the Index Stats info returned by SYS.DM_DB_INDEX_USAGE_STATS for sev…

  YSLGuru

  5 replies

  15 years, 5 months ago

  By: jrc172

• Processor Affinity and Multi Processors

  My organization is in the process of acquiring a new database server. The server will have 2 quad-…

  Mike Johnson-491593

  3 replies

  15 years, 5 months ago

  By: vidya_pande

• Update query - need suggestion

  I am planning to do an update on a very large table (table1 ~250million). So need to know which one…

  Baskar B.V

  10 replies

  15 years, 5 months ago

  By: Jeff Moden

• An index scan on a target table forces index scans on joined tables?

  I noticed in one of my recent queries that if the select statement against a target table resulted …

  cgm/

  3 replies

  15 years, 5 months ago

  By: Ninja's_RGR'us

• Using an OR statement in a WHERE clause executes much more slowly, why?

  I have a query that joins several tables. It basically looks like: SELECT TOP 10000 EmpID, EmpFName…

  Maxer

  1 replies

  15 years, 5 months ago

  By: GSquared

• Inconsistent Execution Plan

  Hi, I'm wondering if anyone might be able to share some insight into how to resolve this problem: I…

  Matt Smith-424234

  1 replies

  15 years, 5 months ago

  By: Grant Fritchey

• Need help on tune query

  Hi All, I need your help on tune the attached SP. Here with attaching the SP,function script and th…

  moosamca

  1 replies

  15 years, 5 months ago

  By: Lynn Pettis

• clearing SQL cache

  Hello, We have our application running on sql server 2005. Recently we started slowing down of the …

  vkkrishn

  8 replies

  15 years, 5 months ago

  By: sam.alexander

• tuning the query which is having cursors

  There is one procedure which is written with cursors within cursors. The code is copied in this. Ca…

  ekknaveen

  3 replies

  15 years, 5 months ago

  By: TheSQLGuru

• Logics on Non clustered index

  My understaning is non clustered index maintain catelog to have address of physical data. …

  amalanto

  2 replies

  15 years, 5 months ago

  By: Bhuvnesh

• index issue

  Are the followings indexes are correct for rows 110k? Table contain following Columns employeeId -…

  rpatil22

  6 replies

  15 years, 5 months ago

  By: Bhuvnesh

• Is there a better way?

  Hi All, I'm wondering if anyone can suggest a more efficient way of accomplishing the following tas…

  sqlservercentral 49658

  3 replies

  15 years, 5 months ago

  By: Grant Fritchey

• sp_updatestats causing bad statistics updates?

  Hi All, This is my first post - and I am quite new to the DBA type role. I've got a query about upd…

  chelta

  4 replies

  15 years, 5 months ago

  By: Grant Fritchey

• Avg. disk Queue Length intermittently runs 100%, Looks like SQL Agent

  Im running; Windows 2003 server MSSQL 2005 sp2 Running Perfom I intermittently see Avg. Disk Queue …

  AHWB

  2 replies

  15 years, 5 months ago

  By: RBarryYoung