select

case when MAX(mydate) < GETDATE() THEN MAX(mydate) ELSE MIN(Mydate) end as mydate

from #mydates where mydate >= GETDATE()

No additional indexes on the tables?

Just primary keys?

Also provide your data in a consumable format, like you have with your tables

E.g.

INSERT INTO TB_WORK_ORDER_ABV VALUES ('dfewrgre','ggergerg','gregergher','gerhreher')

what is the error message on the subscription?

have you set the unattended execution account?

have you set the smtp server to use for sending mail?

does the account the file share subscription...

Transactional Replication would be the only real alternative.

Unless you can live with delays when you can write your own SSIS packages to transfer new data, updated data, deleted data at...

Again I refer you back to the topic you rasied earlier

http://www.sqlservercentral.com/Forums/Topic1410892-391-1.aspx

You will need to ensure that you have selected disconnect users when restoring.

You cannot restore a log if the DB is being used by a user.

So if your logshipping is...

So JobB should only run if JobA has run successfully?

If JobA runs on a Saturday and finishes on a Sunday do you want to run JobB?

Post the query which is giving you performance problems dont keep changing the query.

Then from that query, post the definition of all tables used within that query along with all...

Definition of TB_TRACKING_ABV, TB_WORK_ORDER_AGVEN again with indexes please

One more time

Read the link in my signature on posting performance problems, also read the link on posting code and data.

Update all your statitics, rebuild your indexes, post the execution...

Also syscomments is depreciated, use sys.sql_modules instead

Take what the missing index view and DTA say with a pinch of salt, just dont apply anything it says at think it will work.

Your best off running DTA against...

Please post the CREATE TABLE scripts along with all indexes for both tables along with the full query.

You may have an outdated plan, bad statistics, bad index fragmentation which is...

Ruled that out as well, the management pack at the time didnt do everything we needed.

Again get a copy install it, configure it, evaluate it, if it does what you...

Truncating your log files, eeesh, you need to put some proper transaction log management in place, regular shrinking of files is not best practise.

http://www.sqlservercentral.com/stairway/73776/

Also get a copy of the accidental...