SQL Server 2005 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• How does one improve the performance of a "colA > colB" query?

  Hi all I've got a performance problem with a query that uses a comparison between two columns to pu…

  Duncan Pryde

  7 replies

  13 years, 2 months ago

  By: Duncan Pryde

• how to create a publisher for snapshot replication using C# and RMO namespace

  i want to create a publisher and subscriber for a transactional replication how to create them, and…

  apu5star

  1 replies

  13 years, 2 months ago

  By: Orlando Colamatteo

• publisher should not try to transfer data to subscriber that is not connected

  i ve tried merge replication.. i want to know how the log file will be when subscriber is not conne…

  apu5star

  3 replies

  13 years, 2 months ago

  By: apu5star

• Server side tracing - where is the data stored?

  Maybe a silly question from me today but ... I've set up a server-side trace with a max size of 5GB…

  derek.colley

  4 replies

  13 years, 2 months ago

  By: Orlando Colamatteo

• Constraints Vs Performance

  Is Foreign Key affects the performance? In What way?

  jansub07

  1 replies

  13 years, 2 months ago

  By: Gail Shaw

• Clustered Index Seek Causing Poor Performance - Suggestions For Indexes

  I have an query, that is being sent via an application that is resulting in poor performance. For a…

  jwa082276

  36 replies

  13 years, 3 months ago

  By: Gail Shaw

• SQL Performance Issue

  I have so many Stored Procedures in my DataBase, so,How to find which Stored Procedure is taking lo…

  suresh0534

  12 replies

  13 years, 3 months ago

  By: glamourth

• Speed question for computed columns

  I have a zip code table that stores Latitude and Longitude. All my calculations use radians. I am …

  FredS-1001785

  1 replies

  13 years, 3 months ago

  By: GSquared

• Faster returning of result

  If I have following environment Stock (Stockid(PK), Stockname, Price) -Have 2millions rows Sales(Sa…

  Munabhai

  8 replies

  13 years, 3 months ago

  By: Munabhai

• Code review tools for SQL 2005

  Hi All, Is there any free SQL code review tools to check the quality of the SQL code and to improv…

  hamsa_apj

  1 replies

  13 years, 3 months ago

  By: Grant Fritchey

• occasional high number of reads for a stored proc execution

  this is 2008 R2 BTW... I have a table as such: Time_Series table: ID int, offset_days smallint, the…

  cmoy

  2 replies

  13 years, 3 months ago

  By: Grant Fritchey

• creating NON CLUSTERED INDEX on table

  Hi , I have "INDEX" table with the below columns and having 100 millions of records. indexid varcha…

  Chinna :)

  2 replies

  13 years, 3 months ago

  By: Chinna :)

• Update statement - query performance

  I have a update statement which takes more than 1 minute but if i do select statement with same whe…

  Sandy2704

  5 replies

  13 years, 3 months ago

  By: Jeff Moden

• What is the most efficient way to delete records?

  Hello, I have a database that is 230GB in size. A single table in this database has 200 million row…

  brutsoft

  35 replies

  13 years, 3 months ago

  By: Jeff Moden

• SQL Server 2005--Running reindex every 2 days for performance reasons, Tuning advisor constantly asking me to add stats on same query

  Does anyone know why this is? In the past, I have done a full index rebuild, updateusage, and sp_u…

  Brent White

  1 replies

  13 years, 3 months ago

  By: Grant Fritchey