Tags » Database Tuning

SQL Server Conversion failed when converting the varchar value 'xxxx' to data type int - A Root Cause Analysis

There are many reasons but this is what I ran into:

The query was simple as follows:

select top 1 stopid from busstops where code = cast('836' as int)
… 472 more words
SQL Server

Access: Tuning Your Client Settings

Microsoft Access is a great application for creating databases. It is also used as a tool for just storing data. Where Excel will limit you to just over a million rows this application has no issues whatsoever to store a couple of million rows. 928 more words

Office Tips And Tricks

Importance of Database Administration

Self-medication is defined as “the use of drugs to treat self-diagnosed disorders or symptoms, or the use of a prescribed drug for chronic or recurrent disease or symptoms”. 603 more words


ORAchk replaces EXAchks and RACcheck

The new tool from Oracle ORAchk includes EXAchks and RACcheck functionality and replaces the older tools. It is no longer just a database tool but also runs health check on E-Business Suite Financials, Enterprise Manager Cloud Control repository, GoldenGate and Sun Systems. 417 more words