Search Results | SQL Server Performance Forums

Querying Large Table

Post by: Ranjit72, Feb 22, 2008 in forum: SQL Server 2005 T-SQL Performance Tuning

Martin, As I said it is not our database. As explained in the earlier post they will not create anything for us on the table level(Indexes ect). We...

Querying Large Table

Post by: Ranjit72, Feb 22, 2008 in forum: SQL Server 2005 T-SQL Performance Tuning

Are there any caveats in using Indexed views? I havent used it before. Table Structure: [SourceID] [varchar] (3) COLLATE...

Querying Large Table

Post by: Ranjit72, Feb 22, 2008 in forum: SQL Server 2005 T-SQL Performance Tuning

I have not gone that far, to look at the execution plan the query should be completed right? Please correct me if I am wrong. Before my query gets...

Querying Large Table

Post by: Ranjit72, Feb 22, 2008 in forum: SQL Server 2005 T-SQL Performance Tuning

Thank you all, As I said this is a vendor database and we have only select rights, we dont have any create rights. On the other hand we can ask them...

Querying Large Table

Thread by: Ranjit72, Feb 18, 2008, 9 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hello All, I have a large table with 5 million records and I have to query based on the certain criteria...the query is taking like 15-20 mins to...

Transaction Log back up and ASP timeout errror

Post by: Ranjit72, Jun 20, 2006 in forum: Non-Transact SQL Developer Performance Tuning

SMY, I already did both your suggestions, thank you though. Satya,I cannot move the Log files to a different drive as it is a standalone...

Transaction Log back up and ASP timeout errror

Thread by: Ranjit72, Jun 5, 2006, 6 replies, in forum: Non-Transact SQL Developer Performance Tuning

Hi all, I have a typicall issue with one of our Web apps and MS SQL 2000.The user complains that intermittenly there is a "MS OLE DB Timeout error"...