SQL Server 2005 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• Querying a large table with an odd criteria

  Hi, I'm looking for a better solutions to the one I've developed, I've been working on it so long t…

  giles.clapham

  21 replies

  14 years, 5 months ago

  By: TheSQLGuru

• heap or clustered

  Hi, is possible create heap with primary key?? Im testing query... If I have clustered table that l…

  radekhatle

  18 replies

  14 years, 5 months ago

  By: Gail Shaw

• "No Join Predicate" Warning Message

  I was troubleshooting an issue in production and stumbled upon an issue I have not seen before. I …

  JohnnyDBA

  8 replies

  14 years, 5 months ago

  By: Ninja's_RGR'us

• affinity mask value for 8 cpu heavily loaded sqlserver 2005 Ent

  Hi guys I have migrated my SQLServer2005 Ent from Physical to VM and upgraded Virtual CPU from 4 to…

  kochu.vinod

  5 replies

  14 years, 5 months ago

  By: steveb.

• Select query taking time

  I am trying to perform optimization of a sproc. It contains one "select" statement which is taking …

  sql_butterfly

  16 replies

  14 years, 5 months ago

  By: sql_butterfly

• Query Tuning - Update Satement

  Hi Guys, I'm having trouble on tuning this update statements. UPDATE CASE_DETAILS_V SET USER_DATA3…

  Seeking For Anwser

  5 replies

  14 years, 5 months ago

  By: Seeking For Anwser

• Updating millions of records

  Hello, We have data processing team in our organization which needs to work with millions of record…

  SQLRO

  17 replies

  14 years, 5 months ago

  By: gofrancesc

• Query Tuning Assistance - Max() and Group By

  Good morning, I was wondering if there is a way to optimize a query that has a MAX() function. Her…

  dajonx

  6 replies

  14 years, 5 months ago

  By: Dave Ballantyne

• Is there a script somewhere (or a tool I can use) to add set nocount on to all my stored procdures?

  I have over 600 stored procedures that do not have nocount set on and I have been asked to do perfo…

  murray50

  2 replies

  14 years, 5 months ago

  By: gsc_dba

• How to do proper tuning

  Hi all experts! I have a machine that needs to be tuned perfectly. My questions: Are there any good…

  mattias 58533

  4 replies

  14 years, 5 months ago

  By: TheSQLGuru

• Quick deadlock question

  Hi all, I have a question regarding deadlock trace output. I had always thought that "Statement Ty…

  Adam Kreul

  1 replies

  14 years, 5 months ago

  By: Patrick_Fiedler

• Indexes not used properly

  In my database I have a UDF which takes in four parameters as input does a union between two tables…

  snoop123

  1 replies

  14 years, 5 months ago

  By: Gail Shaw

• Set Statistics Time oddity.

  Anyone ever seen it do this? SQL Server Execution Times: CPU time = 942904 ms, elapsed time = …

  Evil Kraig F

  2 replies

  14 years, 5 months ago

  By: SQLRNNR

• Select Distinct on indexed column is not instant

  Hi, In order to speed up a "select distinct col1" from a 150M-records-table, I created an index on …

  Florent Rousseau

  3 replies

  14 years, 5 months ago

  By: Gail Shaw

• SQl Query - Need to find performance impact

  I need to get distinct records from a table1 and table2. Table1 has col1,col2,col3,col4 has contryc…

  chatwithkrishan

  1 replies

  14 years, 5 months ago

  By: dajonx