SQL Server 2008 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• How to optimize a query that's running slow on Nested Loops (Inner Join)

  Hi All, Please provide your suggestion on this issue. Original Query : select distinct d.research…

  kbhanu15

  3 replies

  11 years, 6 months ago

  By: Gail Shaw

• Multiple Covering Indexes

  After doing some performance research, it appears that covering index(es) may be beneficial for a c…

  Spork

  8 replies

  11 years, 6 months ago

  By: SQLBuddy123

• stored proc taking time for first run every 30 mins

  stored proc is taking arround 2 minutes for first time, next execution it takes a second. If i try…

  mxy

  9 replies

  11 years, 6 months ago

  By: EricEyster

• upgrading from 2005 to 2008

  Hi, Please suggest me what are the measures to be taken on the database or server settings if we ar…

  pmadhavapeddi22

  5 replies

  11 years, 6 months ago

  By: pmadhavapeddi22

• Slow insert into a table

  I'm facing an issue here. I have one procedure which inserts data in a table with the help of some …

  sqlnaive

  7 replies

  11 years, 6 months ago

  By: Jeff Moden

• SQL Tuning - Enhancement ???

  Is there any other way of writing this query ? SQL Server 2008 R2 LEFT OUTER LOOP JOIN PART_LIST p1…

  DKG2014S

  3 replies

  11 years, 6 months ago

  By: Jeff Moden

• While giving Right click on any objects am getting error like 'Cannot show requested dialog'

  Dear All, This is Jagadeesh, I have installed the SQL server2008R2 in my system.If i select Right c…

  Chowdary's

  2 replies

  11 years, 6 months ago

  By: Beatrix Kiddo

• Optimising the insert into temp table query

  i have the below query which takes 1 hour to run please suggest any optimising method for the same …

  raj.prabhu001

  4 replies

  11 years, 6 months ago

  By: SQLBuddy123

• sql query fills up tempdb with greater than 300 gb

  Hi, Below mentioned query, whenever it runs it fills up tempdb space and resulting disk space issue…

  RahulSingh

  3 replies

  11 years, 6 months ago

  By: benjamin.reyes

• My procedure is taking more CPU time : sys.dm_exec_requests

  hi my procedure is taking more cpu time, how to reduce this. select r.total_elapsed_time, r.cpu_ti…

  kbhanu15

  5 replies

  11 years, 6 months ago

  By: SQLBuddy123

• RML Util ~ filter by name

  Hi I've tried searching t'internet and the RML help pdf but I cant find an answer so hence I seek …

  simon_s

  1 replies

  11 years, 6 months ago

  By: simon_s

• SQL Server Memory Nodes - NUMA - Lock pages allocation only allocated on 1 node???

  Hello All Can someone explain why (using DBCC Memorystatus) I can see that all my locked pages allo…

  tct_sql_admin

  1 replies

  11 years, 6 months ago

  By: tct_sql_admin

• Reduce Logical reads

  In our production server, views were slower in execution. So I optimized couple of views by removin…

  Samit Shah

  2 replies

  11 years, 6 months ago

  By: Gail Shaw

• Issues With sys.dm_db_index_physical_stats...Running for more than 48 hours

  Hi All, We have script that loops each index in the database and for every Index, it feteches its L…

  dedicatedtosql

  6 replies

  11 years, 6 months ago

  By: SQLRNNR

• Clustered Index SEEK as the highest cost in a query plan

  Hi All, In a query i've been investigating, i made a change such that now the most expensive part o…

  kbhanu15

  2 replies

  11 years, 6 months ago

  By: stormsentinelcammy