Search Results | SQL Server Performance Forums

Urgent help: sql 2008 database configuration

Post by: sekharabcs, Nov 30, 2009 in forum: SQL Server 2008 General DBA Questions

Thank you Luis for your reply.I have gone thru some of the kb articles and came to the below conclusion:My opinion:D: database files (because this...

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

Post by: sekharabcs, Oct 10, 2009 in forum: SQL Server 2005 T-SQL Performance Tuning

Thank you Hassan. I will consider the above mentioned points.

help with Index Rebuilding

Post by: sekharabcs, Oct 9, 2009 in forum: SQL Server 2005 T-SQL Performance Tuning

Thank you Hassan for your help! Missing Indexes: I have a quick question on Missing Indexes. I have got the list of missing indexes from a script...

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?

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

datatype for identity in table2 is INT SP2 is not having any output parameter. I will create a one and check. 1. So do you mean that @@IDENTITY when...

problem with @@IDENTITY?

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

My Apologies Adriaan, ID columns in not an identity. Its a INT which allows NULLS. SP2 code: Insert Into table2 (Created) Values (GetDate())...

problem with @@IDENTITY?

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

Thank you for the reply Frank. I could see that there is no trigger on the tables used by the above SP. However, there are some other tables with...

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

Post by: sekharabcs, Sep 22, 2009 in forum: SQL Server 2005 T-SQL Performance Tuning

Thanks for your reply Satya. Currently we do not have any data warehouse and also we have all applications/servrices running on a single server...

Order placing application taking time to place an order

Post by: sekharabcs, Sep 18, 2009 in forum: SQL Server 2005 T-SQL Performance Tuning

Thanks Frank and Hemant, I will analyse the queries in Stored Procedures and execution plans. I will also need to look into network related things...

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

Post by: sekharabcs, Aug 19, 2009 in forum: SQL Server 2005 T-SQL Performance Tuning

Thanks Adriaan and Satya for your most valuable suggestion. I will check for getting grip on the query first. Regards, ABC

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:...