ERROR 1114 – The table is full

ERROR 1114 – The table is full

At XTIVIA, we have encountered the MySQL Error 1114, “table is full” on quite a few occasions. The description for the error is usually misleading as it implies that a table has reached or exceeded a maximum set limitation. Tables utilizing the InnoDB...
Changing Storage in an Always On Environment

Changing Storage in an Always On Environment

I was recently given a task to move a few multi-terabyte databases inside of an availability group from SAN A to SAN B within a 10-minute window. The good news was there was plenty of time to plan and prepare. For the purpose of this example, I will be using a very...
ORA-01017: Invalid Username/Password; Logon Denied

ORA-01017: Invalid Username/Password; Logon Denied

Oracle ORA-01017 Quick Fix The ORA-01017 error seems pretty straight forward, however it can have us banging our heads against our desks for awhile trying to figure out why we can’t seem to type our password in correctly. Here are a few reasons I have personally...
Always On Changing Cluster Configuration

Always On Changing Cluster Configuration

There are situations where you would want to change the Windows cluster configuration so a failover does NOT occur. Failovers can occur due to quorum (error: The Cluster service is shutting down because quorum was lost) can’t be reached for a short period of...
SQL Server Statistics and Trace Flag 2371

SQL Server Statistics and Trace Flag 2371

SQL Server Statistics are small, lightweight objects that describe the distribution of data in a SQL Server table or column. The SQL Server query optimizer uses statistics to estimate how many rows will be returned by parts of your query. This heavily influences the...