InnoDB by default stores all data in one large file, typically referred to as the InnoDB tablespace. Without customisation, A file named ibdata1 at the root of your MySQL data directory will contain all your data and indexes. One problem that has...
Error Message: Microsoft.Reporting.WinForms.ReportServerException: The Report Server Windows service ‘ReportServer$SCE’ is not running. The service must be running to use Report Server. (rsReportServerServiceUnavailable)at Microsoft...
When looking at MySQL output, it is sometimes more convenient to split up the number of records returned into separate pages and include hyperlinks to further pages in the result set, a layout often referred to as pagination. The following is an...
Sometimes simplicity is also convenient, and in the case of authentication on the most popular web server, Apache, .htpasswd fits the bill You may opt for a PHP/MySQL login which in itself is simple enough, but requires the availability of MySQL. If...
Here is a SQL stored procedure (sp_Now) that determines what processes are currently executing and consuming resources on a database server. It’s helpful in troubleshooting sporadic performance problems, especially in an environment where...
How to install Oracle database on SuSE Linux10? Let me explain these steps, step by step. System Requirements: Memory: 1G recommendedSwap partition: set to 2 times the memory/tmp disk space: 400MB or moreDisk space: software 3.5G data 1.2G...
I did a little research the other day with regards to Time Dimensions and I thought I would share my findings here. Background:Traditionally a data warehouse will have at least one “Time” dimension that will have one record for...
A common issue for users of SQL Server databases is disk space and the size of the physical log file and database. While I’m not going to attempt to make a “one size fits all” statement on database maintenance plans, I thought...