SQL Server 2005 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• Table valued Function Performance

  Hello In the last week, my company installed a new machine with SQL Server 2005, i had to migrate m…

  rootfixxxer

  21 replies

  15 years ago

  By: rootfixxxer

• STOREPROC VERY SLOW

  I HAVE A STOREPROC WHICH IS RUNNING FINE IN DEVELOPMENT ENV BUT WHEN I M USING THE SAME STORE PROC …

  pardeshkumar

  14 replies

  15 years ago

  By: TheSQLGuru

• Tune a SQL SP with cursors and dynamic SQL

  I have SP that runs rather slow. I am attaching the code to this post. The obvious comments are I s…

  dwg1011

  8 replies

  15 years ago

  By: Gail Shaw

• Question on best place to use a function

  Suppose TableA has 100 million rows. Is it better, from a performance standpoint, to write the que…

  Steve-443559

  2 replies

  15 years ago

  By: sqlnaive

• Deadlock FETCH API_CURSOR0000000000001AEC

  I found a deadlock on my SQL Server. I enabled trace flag 1222 and could find deadlock information …

  DBA328

  4 replies

  15 years ago

  By: TheSQLGuru

• Query Performance

  Hello, I have a stored procedure which times out, but if i update the statistics and run the progra…

  PradeepVallabh

  6 replies

  15 years ago

  By: Ninja's_RGR'us

• First query hangs with PAGEIOLATCH_SH wait but subsequent queries complete.

  We have just migrated a database to a new host (was 2000, now 2005). There is a query (select) whic…

  marko61

  7 replies

  15 years ago

  By: TheSQLGuru

• Query taking long time for completion. -- URGENT!!

  Hi All, We are using SQL Server 2005 Enterprise edition with SP4 installed on it. Actually its …

  jai_422

  5 replies

  15 years ago

  By: TheSQLGuru

• Disk Bytes/sec

  I am troubleshooting database performance problems and I can clearly see that the database is IO bo…

  Brian Carlson

  11 replies

  15 years ago

  By: itpcpro

• Same Execution Plan but Different Execution Time

  Same stored procedure with same execution plan runs sometimes way slower. On the production, when i…

  day-476284

  14 replies

  15 years ago

  By: TheSQLGuru

• Stored proc eating bandwidth on server!

  ok.. this is pretty simple and i can't understand... we have a stored proc which is called from an …

  nikhil8960

  9 replies

  15 years ago

  By: TheSQLGuru

• Same Query giving different execution pan and performance

  Hello Friends, Stuck in very strange situation. I have populated few tables for two set of paramete…

  sqlnaive

  1 replies

  15 years ago

  By: sqlnaive

• Index Rebuilding - Fragmetation

  Dear All, Regarding Index rebuilding, I can see same fragmentation percentage before and after the …

  ravisamigo

  9 replies

  15 years ago

  By: TheSQLGuru

• performance problems with stored proc

  Prob solved by updating the stats

  cap gemini

  3 replies

  15 years ago

  By: Grant Fritchey

• Time Out Limit for Statement Optimization

  I have a procedure that produces a poor execution plan. The plan has a property 'Reason for early …

  rchantler

  4 replies

  15 years ago

  By: Grant Fritchey