After you bounce SQL Server link works fine for some time then it hits again; is that a fair statement?

If Yes... something is getting corrupted over time, memory leak perhaps?

google "database load simulation" 😉

That means your recovery strategy calls for point-in-time recovery.

- DO Full and T-Log backups.

How about a daily full backup...

If table was not restored, from where test version of the table comes from?

Doing validation in both the app and backend side seams to me the easiest way to get into troubles.

- system performance. Double validation certainly has a negative impact on overall...

:blink: do elaborate, please.

8kb (9/15/2009)

---

At my job, there is new requirement for one of our products to work in "offline" mode. That means the user must be able to view and manipulate data...

Roy Ernest (9/24/2009)

---

If I am allowed to venture a comment on this, I would say, The DBA should know when to enforce Normalization and when to DE-normalize. 🙂 There are...

Answering your Oracle question... research DBMS_LOB system package.

LOB is such a complex subject it goes beyond what can be discussed in a post.

how about putting the comments inside the storedproc instead of outside of it?

This is confusing at least. Not sure about the context of your statement...

Where is space going?

Do you remember cast()... make them strings 😉

dbo.benyos (9/20/2009)

---

If they are textual you might end up in the...

I have to say... impressive solutions.

Call me lazy but, how about...

SELECT *

FROM qtral

WHERE tral_no + tral_pd

...

Check EXCEPT operator, like it was designed to solve your conundrum.