SQL Server 2008 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• Improve performance of query

  Hi guys please guide me how can i improve the performance of the below query by making changes to i…

  raj.prabhu001

  2 replies

  9 years, 11 months ago

  By: Jeff Moden

• sql server 2008 R2 ent edition sp3 64 bit not releasing memory

  This is from stackoverflow: I think I have a basic question here that many might have encountered. …

  fizzleme

  3 replies

  9 years, 11 months ago

  By: Ed Wagner

• Uneven timings when deleting by chunks

  Hi, *** There is a table like this: CREATE dbo.Table1 ( ID int Primary Key Clustered, …

  btio_3000

  6 replies

  9 years, 12 months ago

  By: Kristen-173977

• SQL Server 2008 R2 SP2 - High amount of stolen pages for CACHESTORE_SQLCP

  Hi, I've migrated a database from Oracle 11.1.0.7 to SQL Server 2008R2, using the application edito…

  Jefferson Elias

  7 replies

  10 years ago

  By: Jefferson Elias

• bcp issue

  I am starting the practice of mega data today, here is what I am doing now: I have data generated f…

  halifaxdal

  4 replies

  10 years ago

  By: halifaxdal

• will adding an index help the performance on my tables with 10+m records? thanks

  Hello, I might get an assignment of working on mega tables with 10-30 millions records, the origina…

  halifaxdal

  2 replies

  10 years ago

  By: halifaxdal

• Peformance hit moving from 2005 to 2008??

  This is really a shot in the dark, but here's the general situation. We are updating a 3rd party ap…

  jay-h

  4 replies

  10 years ago

  By: Jeff Moden

• CROSS-APPLY performance issue

  I have a view as below: CREATE VIEW V1 AS SELECT T1.Col1, F1.Col1, T1.Col2, T2.Col2... FROM T1 INN…

  Sathishk

  4 replies

  10 years ago

  By: Ed Wagner

• Effect of Parallelism on Peformance Counters!

  [font="Verdana"] DMVs offer us performance counters; CPU/IO cost etc. If these are affected by Para…

  Abrar Ahmad_

  5 replies

  10 years ago

  By: Gail Shaw

• Execution Plan "table Spool"

  Hello friends I found table spool(Lazy) in execution plan so it is better or not? let me know if …

  meerack11

  4 replies

  10 years ago

  By: Gail Shaw

• How to Remove Fragmantaion on INDEX?

  Hello friend, I Created index on table that contain 55% fragmantion so I REBUIT it. But still it ha…

  meerack11

  11 replies

  10 years, 1 month ago

  By: Luis Cazares

• Performance monitoring on a new DB Server

  Hi everyone. I am quite new to this so please be kind! 🙂 I have been given a project to centralise …

  print_mug

  2 replies

  10 years, 1 month ago

  By: ryszardbocian

• Rebuilding an index results in a stored procedure failing with "stored procedure xxx has changed since it was last compiled"

  We have a scheduled task which runs each Saturday early morning, determining which indexes are frag…

  James Lavery

  2 replies

  10 years, 1 month ago

  By: James Lavery

• Sql Server Stats becoming outdated multiple times a day

  I have a small set of tables that the stats are becoming stale. This is happening about 3 times a d…

  Cole.Mietzner

  1 replies

  10 years, 1 month ago

  By: sgmunson

• Query Execution plan too long

  Hi All, I am working on a legacy application and one of the view has degraded performance. I have t…

  thenewbee

  15 replies

  10 years, 1 month ago

  By: thenewbee