I'm interested also if that would be possible.

Only the datecreated is mentioned in the sysobjects table.

*pro.factor isn't in the select, why do you calculate it?

*Is

'CveProyecto Prorateo' = pro.proyecto

testing if pro.proyecto is equal to the literal 'CveProyecto Prorateo'?

*

LEFT JOIN (SELECT factor = gp.factor / (SELECT...

After the installation of Oracle Client software, reboot the server. Otherwise sql server doesn't seem to recognize until reboot.

Hello,

I'm not familiar with ado (and its locking) but you could check the following:

*locks: sp_who2

If the function only has to enter a new record, perhaps you may consider a stored...

You can manipulate the batchsize and querytimeout to reduce the errors.

At work I changed the standard batchsize to 100 and now the replication (on a LAN) won't time out any...

Interesting solution.

Is data_sf quite selective? If so an index on data_sf wouldn't probably hurt to avoid a tablescan for the records to update.

1)Is there an index on data_sf?

2)if it doesn't have to run as a transaction, try splitting it up in batches

(test the following first)

DECLARE @DATEOLD datetime

DECLARE @DATENEW datetime

set @DATEOLD=...

set @DATENEW=...

SET ROWCOUNT...

Hello,

For question 1:

I've learned a lot from http://www.sql-server-performance.com/articles/per/main.aspx for auditing performance, perfomance tuning. Use query analyzer to view queryplans, and sqlprofiler to see the duration of individual statements.

Basic: check normalisation,check...

A few months ago our data was backup up on a mobile HD of 500 gb. This made it easy to move around and test it. The main backdraw of...

We had a filesharing issue for large files in win2k3. Fixed with applying SP2, adding memory & flashing firware. Alas another feature crept up: commandshells don't always start (issue with...

If you have sysadmin rights, you could start a trace with sqlprofiler to see the troublesome queries.

sp_who2 gives the current connections and if it is blocked (temporarily) by another.

Have a look at the audit section of http://www.sql-server-performance.com/articles/audit/main.aspx

The timeout can come from "normal" locks on records (applications fetching not all or too many data), I/O throughput.

Are these readonly...

I work 39 hours from 8-16.30 (safe by some incident). So home by 17:15. The flexible hours are really appreciated.

You could check if the defrag actually helps (fragmentation before/after) with DBCC SHOWCONTIG.

Perhaps you should iterate on index position rather than tablename

(order by IndexId for the indexes cursor), so sql...