Search Results | SQL Server Performance Forums

I tried with and without indexes. There are differences but not the difference between 30 minutes en a day!!

That one is about 60 GB (55 mil records)

Yes it is, the rf table is very small btw. The main problem is that when I run the statement seperately it runs fast enough, and when there are...

The updates are different but for example uPDATE FLOWFILE SET cntry_coeu = Rf_country.cntry_ceu, cntry_cocm = Rf_country.cntry_ccm, cntry_corpu =...

Thread by: gerben, Jun 6, 2006, 10 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hello, I've got a databasese with 55 mil records. I've got about 30 update statements which have to run in a particular sequence. When I run a...

This is one of the stored procedures which runs about 30 hours.<br /><br /><br /><?xml version="1.0" encoding="utf-16"?><br /><ShowPlanXML...

Thread by: gerben, May 22, 2006, 6 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hello, I am relativly new to sql server. I am using 2005. I have a large database (100gb) And 'all' I want to do is update each record based on...