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


Online reorganization enhancements in Oracle 12c

The Online Reorganization and Redefinition feature in Oracle Database offers DBAs significant flexibility not just to modify the physical attributes of a table but also to defragment and compress the table while allowing online access to the database. 690 more words


Oracle in-database archiving and invisible columns in 12c

“The true mystery of the world is the visible, not the invisible.” Oscar Wilde

In-Database archiving is new to Oracle 12c. The idea behind it is to make rows invisible. 564 more words


Helpful Scripts pt2!

Yesterday I presented some scripts from Glenn Berry which can help you figure out most things to know about your database.

Today I will introduce you to another famous script, this time from… 180 more words

SQL Server