SQL Server 2008 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• First use of CTEs in Query - asking for comments on how to improve query

  Hello everyone, Below is my first attempt at use CTEs in a query and I would to read your comments …

  e.vercruysse

  1 replies

  11 years, 6 months ago

  By: Luis Cazares

• Missing Indexes

  Have given a list of missing indexes. How to decide which indexes are to be created. Please help ur…

  mandir.jain

  4 replies

  11 years, 6 months ago

  By: Jeff Moden

• Avoid KeyLookup

  Dear All, Find the following table and Query and index.I am Getting Keylookup in Query on Execut…

  sivaramakrishnan G

  5 replies

  11 years, 6 months ago

  By: chris.rogers00

• Function with parameters running slow

  Hi All, I am having a UDF which accepts two parameters . It is running slow for the first time for …

  aslamnepanagar

  1 replies

  11 years, 6 months ago

  By: milos.radivojevic

• Query execution time

  Hi everyone, We have faced the issue with application as this is working very slow as per the clien…

  New persopn

  2 replies

  11 years, 7 months ago

  By: Gail Shaw

• High CPU with many DB connections Prod almost down

  Hi All, We are facing 95- 96 % CPU hike on our pord server. SQL Server 2008 R2 SP1 with 8 CPU and 3…

  Minaz Amin

  7 replies

  11 years, 7 months ago

  By: Minaz Amin

• Usage of Temprory Table in Stored Procedure

  Dear All, For my project salary calculation writtened in Stored Proceure based.There is nearly 50…

  sivaramakrishnan G

  2 replies

  11 years, 7 months ago

  By: Eugene Elutin

• Execution Plan vs DTA missing index recommendations

  Hi, looking at a whole bunch of select statements with a view to tuning etc etc . For the first one…

  simon_s

  3 replies

  11 years, 7 months ago

  By: Gail Shaw

• Is this SARGable?

  Assuming we have a players table with a kazillion records with PK and clustered index on playerid (…

  smallmoney

  2 replies

  11 years, 7 months ago

  By: milos.radivojevic

• Query running slow in Production and fast in Test environment

  Hi, We have SQL 2008 R2 servers in our AWS cloud instances. Both environments are in cloud and have…

  Dhruva_51

  12 replies

  11 years, 7 months ago

  By: smallmoney

• SQL Server Profiler question (resource issue)

  I keep having a long running profile shut down because the C Drive is full. I am saving the output…

  Mountain Steve

  2 replies

  11 years, 7 months ago

  By: sqlsniper

• long durations for query intermittently

  Hi Folks, I was running profiler on a sql2008 r2 standard instance 10.50.4290. Occasionally I get l…

  djordan 4543

  1 replies

  11 years, 7 months ago

  By: Igor Micev

• tuning query using max() over(partition by) clause

  Hi , I have a procedure that loads about 60 million rows using code similar to below. I just wrote …

  venus.pvr

  5 replies

  11 years, 7 months ago

  By: venus.pvr

• TempDB performance issues in Vmware

  We are seeing odd performance of our 2008 SQL Server Standard during utilities like reindexes and c…

  pgoodman

  3 replies

  11 years, 7 months ago

  By: pgoodman

• Blocking Causing Timeout Error

  Hi experts, We are getting timeout error in our custom report server db. Timeout is causing the rep…

  VastSQL

  4 replies

  11 years, 7 months ago

  By: Gary Gwyn