SQL Server 2005 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• Want solution on access utilization of RAM by SQL server 2005

  Dear All, My Database is SQL Server 2005. It is having 32Gb ram. In which Sql server taking 28 gb. …

  2M

  3 replies

  8 years, 10 months ago

  By: Gail Shaw

• Execution Plan -- Clustered Index Update

  When looking at the execution plan of a query it shows a 'Clustered Index Update' @ a cost of 85%. …

  SQLDraggon

  12 replies

  8 years, 11 months ago

  By: Gail Shaw

• Logical Reads

  when i execute my main sp , inner sp showing read count as 6000 ,but when execute that perticular …

  sudhakara

  5 replies

  8 years, 11 months ago

  By: Jeff Moden

• which is better to user the cross join or while loop ?

  Hi Please tell me which is better for the performance impact ? 1. Insert into #temp table Using the…

  nitin.varshney

  7 replies

  8 years, 11 months ago

  By: francislouispearson

• Performance Issues

  Dear all In my production server frequently(every four to six hour) i am getting time out problem …

  vs.satheesh

  1 replies

  8 years, 11 months ago

  By: Gail Shaw

• Query performance change depending where condition date value

  Hi all I have and issue with a query in SQL Server 2012 SELECT top 1000 firmas.TipoPers, firmas.Cod…

  eliseoaznarte

  8 replies

  8 years, 11 months ago

  By: ChrisM@Work

• Interview questions on SQL Server 2005.

  Can anyone send me some interview questions pls. I recently got into DBA and I wanna stick to it as…

  Joy Smith San

  40 replies

  9 years ago

  By: Jeff Moden

• Stock Volume calculation

  Hi there, I have a raw table that I get every friday night after stocks close, which gives 45 da…

  rash3554

  1 replies

  9 years ago

  By: rash3554

• Covering Index vs Included Columns

  Hi Guys! Can anyone tell me if there is any functional or performance difference between designing …

  tfifield

  11 replies

  9 years, 1 month ago

  By: Lynn Pettis

• Stored Procedure Inital run slow than quick each day.

  I have a series of SPs that run nightly. They run twice each, once building current month data, onc…

  Myles Sigal

  3 replies

  9 years, 1 month ago

  By: Jacob Wilkins

• Differences in run time for same query

  Hi all I've got a real head-thrasher on my hands. I've got a stored procedure that takes a paramete…

  richardmgreen1

  6 replies

  9 years, 2 months ago

  By: richardmgreen1

• Creating table from 3 diffrent tables with conditions

  1)Assuming Process, Organization and Department tables all exist. please show me how you would cr…

  2smegk

  4 replies

  9 years, 2 months ago

  By: 2smegk

• Missed hostnames and logins in SQL Auditing

  We are running SQL Auditing which captures hostname, login ids,applicationname, servername etc. Tod…

  SSRfromChennai

  2 replies

  9 years, 4 months ago

  By: Ruggiero Lauria

• Data Profiling using T-SQL queries

  Hi Please help, I am new on SQL, I need all the t-sql queries that can get me started with data pr…

  CeliweM

  4 replies

  9 years, 7 months ago

  By: CeliweM

• Creating Clustered index on a large table

  I have a fairly large table with roughly 120 million rows. It has a primary key composed of 3 integ…

  anish_ns

  18 replies

  9 years, 8 months ago

  By: Jeff Moden