Search Results | SQL Server Performance Forums

Urgent help: sql 2008 database configuration

Thread by: sekharabcs, Nov 26, 2009, 4 replies, in forum: SQL Server 2008 General DBA Questions

hi all, I need to migrate my existing SQL Server to a new server which is having windows 2008 server OS and of 64 bit. I have the following hard...

SQL Server in Windows 2008 64 bit and SSRS in Windows 2003 32 bit

Thread by: sekharabcs, Nov 24, 2009, 1 replies, in forum: SQL Server 2008 General Developer Questions

Hi All, My question might be a silly one. However, I need some information. We are planning to migrate SQL Server 2005 server to SQL Server 2008...

Optimise Statistics and Indexes daily

Thread by: sekharabcs, Oct 23, 2009, 2 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hi All, We have 2 jobs running in production sql server daily after business - Optimize Statistics and Optimize Indexes. Is it the best practise to...

clustered index update in query execution plan

Thread by: sekharabcs, Oct 20, 2009, 1 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hi All, I am able to see that Clustered Index Update is taking huge % in query exec plan. Its taking around 81% in the whole query cost.Update tab t...

help with Index Rebuilding

Thread by: sekharabcs, Oct 8, 2009, 4 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hi All, We have daily scheduled jobs which will rebuild indexes in all tables and views in all databases, update statistics all tables and views....

problem with @@IDENTITY?

Thread by: sekharabcs, Oct 7, 2009, 7 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hi All, I have a strange problem. We have a stored procedure SP1 which is inserting data into a table PD. This procedure is inserting data by...

indexes created by DTA

Thread by: sekharabcs, Oct 6, 2009, 1 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hi All, I have noticed that some of production tables have indexes with name startin with '_dta_index_' and I have came to know these are/may be...

Order placing application taking time to place an order

Thread by: sekharabcs, Sep 13, 2009, 6 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hi All, Our client has an order placing system which is used by customer services to place an order. Client is reporting that the application...

Multi-valued function with CTE

Thread by: sekharabcs, Aug 18, 2009, 3 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hi All, I am getting warning "No join predicate" in the below function:...