Tag Info

New answers tagged

0

Referring https://msdn.microsoft.com/en-us/library/ms188414.aspx Update the stats - sysviews are out of sync. EDIT: [thanks for the advice, John] It seems the system views are not always accurate, and sp_spaceused is notorious for this. A form of caching is applied to non-critical, but heavy process data collection functions - like measuring partitions ...


2

PostgreSQL won't run off NTFS on Linux. Format the drive as ext4. Frankly, putting a database on a USB key on a tablespace isn't usually a great idea. The tablespace is unreadable without the rest of the database, and the rest of the database is useless without the tablespace. So you're creating a fragile system with two points of failure. It's a much ...


0

STEP #1 Add the option to my.cnf [mysqld] innodb_file_per_table = 1 STEP #2 If you are running MySQL 5.6, login to mysql and run mysql> SET GLOBAL innodb_file_per_table = 1; If you are not running MySQL 5.6, restart mysqld # service mysql restart STEP #3 Write a script to create NULL ALTER TABLE commands MYSQL_USER=root ...


0

The good thing with Oracle is, it lets you always trick things, do all manual stuff no matter how automatic it is. autoallocate in our DW/ODS environment is a real pain, not because it is bad, but because our conditions. All huge deletes, inserts and truncates fragmantation is unavoidable with autoallocate. The system always has to grow and the solution is ...



Top 50 recent answers are included