SQL Server 2008 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• Performance problem with Views defined against Linked Server data sources

  I have a problem with a data retrieval query that joins three SQL Views, each view based upon a rem…

  rp.blatchford

  2 replies

  11 years, 9 months ago

  By: rp.blatchford

• (RVO) script runs 5 sec with hard-coded value - 45 sec using parameter!

  This script below runs 5 sec with hard-coded value and 45 sec using parameter! guys, any ideas why?…

  RVO

  8 replies

  11 years, 9 months ago

  By: ahperez

• Incorrect syntax near '.'

  I have just copied following query from 'Scripts' from our site only. when i execute it i get Error…

  KcV

  3 replies

  11 years, 9 months ago

  By: Koen Verbeeck

• On which column to create index if no where clause is present ?

  Hi Experts, On which column should one create index if no WHERE clause is specified. example Sele…

  Shadab Shah

  7 replies

  11 years, 9 months ago

  By: Sean Pearce

• Index creation after Insert for Temporary Table inside a SP

  Hi, I need a suggestion for one of the scenarios i'm facing... I've a SP in which i'm creating a te…

  ganeshc27

  8 replies

  11 years, 10 months ago

  By: Gail Shaw

• Execution Times vs Logical Reads/Scan Count

  Hello guys, I want to discuss about your experience what is better. for example. I have procedur…

  tony28

  3 replies

  11 years, 10 months ago

  By: Bhuvnesh

• Query Runs for Long Inspite of Indexes on table

  Hi I have a table which has more than 6 million records . Below is the table CREATE TABLE [Off].[…

  sdennis

  8 replies

  11 years, 10 months ago

  By: Jeff Moden

• How to measure the duration of a full table scan?

  Hello all, we would like to measure how long a table scan on a specifc table takes. We have tried i…

  MDave

  1 replies

  11 years, 10 months ago

  By: Gail Shaw

• NC index seek vs NC index scan with implicit conversion

  Hi all, I've been looking thru our production plan cache and have found a number of implicit conver…

  jhager

  3 replies

  11 years, 10 months ago

  By: Gail Shaw

• T-SQL Performance tuning on Aggregates

  The below query resulted after 30minutes. It uses 2 uses and SUM(). Attached the execution plan too…

  d_uvarajan

  14 replies

  11 years, 10 months ago

  By: Jeff Moden

• Curiosity on performance increase

  I'm just curious as to why this would increase performance so drastically. I have a stored procedur…

  kreierson

  7 replies

  11 years, 10 months ago

  By: kreierson

• SQL 2005 T-SQL Performance tuning

  Hi, I require your help for optimizing/tuning the below query. This query is a part in a stored pro…

  d_uvarajan

  8 replies

  11 years, 10 months ago

  By: d_uvarajan

• udf very slow?

  I created a User Defined Function that performs some arithmetic calculations on a few columns and r…

  Eric Mamet

  21 replies

  11 years, 10 months ago

  By: Eric Mamet

• about performance counters used for Sql

  I would like to know what is the difference between counter LogicalDisk\% Disk Read Time and Physic…

  sej2008

  2 replies

  11 years, 10 months ago

  By: sej2008

• Simple query maxing CPU

  Good afternoon everyone, I've got a simple query that should be no problem at all but which maxes o…

  ElijahE

  11 replies

  11 years, 10 months ago

  By: Jeff Moden