SQL Server 2005 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• SQL Profiler Trace "Audit Login" and "Audit Logout"

  I am trying to find out what causes a record with an EventClass of "Audit Login" and another of "Au…

  Keith Lunevich-369414

  2 replies

  15 years, 4 months ago

  By: JWOL

• Minimising use of tempDB during large INSERT

  Hi all, I have a reporting database that pulls large amounts of data from a production databases an…

  Trevster

  31 replies

  15 years, 4 months ago

  By: Chris Howarth-536003

• Index usage and index cardinality

  Situation is this: I am selecting a column value (not part of any index) from a table containing a…

  Tom John-342103

  4 replies

  15 years, 4 months ago

  By: Lynn Pettis

• Recomplie option

  Hi, can any one tell me when we need to use recompile option in Stored proc ? How can we figure out…

  Bhuvnesh

  3 replies

  15 years, 4 months ago

  By: Grant Fritchey

• Max degree of Paralellism

  Hi everyone, We recently experienced performance degradation with our MS CRM application. We monito…

  Carl B.

  9 replies

  15 years, 4 months ago

  By: Grant Fritchey

• need help for query tunning

  Hii frndz I m new to TSQL , can anybody help me in optimizing the attached query. SP Table structur…

  sanketahir1985

  6 replies

  15 years, 4 months ago

  By: Grant Fritchey

• Advantage of having unique non clustered index same as clustered index on a table

  Hello guys, Is there any advantage of having a non clustered index same as a clustered index on a t…

  Pvm_25

  7 replies

  15 years, 4 months ago

  By: Pvm_25

• Table statistics and creating new index

  I recently had a problem query that on analysis used a poor choice of index- i thought ok, i will c…

  jabadwy

  2 replies

  15 years, 4 months ago

  By: Steve Jones - SSC Editor

• 100% CPU utilisation

  Hi, I have a single duel core CPU with 4 GB RAM Windows2003SP2 with SQL2005SP2. After applying SP2 …

  chandu.ade

  7 replies

  15 years, 4 months ago

  By: chandu.ade

• Inner Join v/s WHERE Col IN (select col from dbo.UDF_Function)

  -- Option 1 select ClientId, Name, id from category c inner join [dbo].[fn_CSVToTableTest]('1,2,3,4…

  Shamshad Ali

  18 replies

  15 years, 4 months ago

  By: Gail Shaw

• SUM(COLUMN) with Clustered Index Seek -- Too slow

  I have a table that has about 70 million records, 130 columns. 36 of the columns are dimensions tha…

  Eagle315

  3 replies

  15 years, 4 months ago

  By: Leo.Miller

• Applying multiple columns in one index - what is recommended

  I have a table with following columns Column_nameType =========== ==== Idbigint <Primary …

  Shamshad Ali

  7 replies

  15 years, 4 months ago

  By: muhammad.mazhar

• Simple query....Worst plan

  HI i need better approach for the below one.i know this is very straight forward query but if someb…

  Bhuvnesh

  13 replies

  15 years, 4 months ago

  By: Bhuvnesh

• Optimization: DE-Delimiting a Semi Colon Delimited List

  I'm taking some of my old queries, and I'm practicing ways to make them more set based to improve m…

  huston.dunlap

  8 replies

  15 years, 4 months ago

  By: Paul White

• query is too slow

  Hi Folks, what do I need to do to optimize this query .. it take 10mins the query and execution pla…

  bodhilove

  10 replies

  15 years, 4 months ago

  By: Bhuvnesh