SQL Server 2005 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• Slow running queries first time in the morning

  Hi all I have a 2005 server which is used purely for reporting, and is populated with data each mor…

  dtilly

  5 replies

  16 years, 3 months ago

  By: Grant Fritchey

• Will The SQL Server Optimizer Use More Than One Index For a Search?

  I once read on a DBA blog that the SQL Server Optimizer would only use one index for a search. If a…

  Gail Wanabee

  6 replies

  16 years, 3 months ago

  By: TheSQLGuru

• Query running slow when executed with parameters

  I've a problem with a query when i run it with parameters in MSSQL Server 2005. If I substitute par…

  Baratella Marco

  6 replies

  16 years, 3 months ago

  By: TheSQLGuru

• How to improve insert performance

  Dear all, We are facing performance problem in inserting into table. Detail Table Size: 2 GB Index:…

  kokila-416295

  11 replies

  16 years, 3 months ago

  By: DragonGod

• Stored Procedures run slow in 64 Bit

  Hello, lately we added a server, running on 8 GB RAM, 2 Quattro Core Xeon Processors, Windows 2003 …

  Andreas Beuschel

  7 replies

  16 years, 3 months ago

  By: curious_sqldba

• 3 indexes in 1 fields of a table

  Whether it is advisable to create 3 indexes in 1 fields in a table.? whether it will speed up the p…

  karthikaug18

  4 replies

  16 years, 3 months ago

  By: 465789psw

• Reading some values in sys.dm_db_index_physical_stats

  Hi all Please see the attached picture for my problem. Basically I have run a query to view the i…

  Kwisatz78

  2 replies

  16 years, 3 months ago

  By: Paul White

• Slow running Select query

  Hi I have a two databases on the same SQL 2005 instance. I created a table, call it 'Table1' on bo…

  Rowan-283474

  4 replies

  16 years, 3 months ago

  By: Grant Fritchey

• Blocked Process Report - Is this blocking due to a compilation?

  I have noticed some long running queries and decided to look set up a Blocked Process Report trace.…

  mike-306849

  2 replies

  16 years, 3 months ago

  By: Paul White

• SSIS I/O

  Hi, I do exception reporting for a Large Life Insurance company's risk management dept. I currently…

  Rowan-283474

  25 replies

  16 years, 3 months ago

  By: Marios Philippopoulos

• I have low selecvity on 3 col's will the optimizer still due an index scan

  I have ran Brent Ozar FindMissingIndexes, my first question is should I create 2 index off the resu…

  465789psw

  2 replies

  16 years, 3 months ago

  By: 465789psw

• Database Engine Tuning Advisor - Odd Results - Any Ideas On How To Fix?

  I'm using SQL Server 2005 with a .43 TB database. The database has been implemented and deployed wi…

  Gail Wanabee

  14 replies

  16 years, 3 months ago

  By: Marios Philippopoulos

• Non-Clustered Indexes Query Performance

  Hi, I've a table Employee Id INT, FirstName VARCHAR(10), MiddleName VARCHAR(10), LastName VARCHAR(1…

  mha_hamed

  6 replies

  16 years, 3 months ago

  By: mha_hamed

• BUG - Use of ranking functions can result in an ineffecient query plan

  Here's a quick blog on an effect i noticed last week. I couldnt find any thing by googling around. …

  Dave Ballantyne

  2 replies

  16 years, 3 months ago

  By: Dave Ballantyne

• Good books (advanced) on query optimization/tuning

  Hello! I would like to purchase good book about query optimization strategies (choosing optimal …

  Igor Marchenko

  15 replies

  16 years, 3 months ago

  By: Grant Fritchey