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
SET cntry_coeu = Rf_country.cntry_ceu,
cntry_cocm = Rf_country.cntry_ccm,
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...
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...
Separate names with a comma.