Question : We have tables with a lot of data (50M new rows each month, just in one table). Now […]
Tag: size
Table size is not changed after new column is added
Question : I am trying to check how the table size is going to be increased after adding new column […]
Appropriate tempdb size?
Question : DBCC CHECKDB is failing on a particular database because of Could not allocate space for object ‘dbo.SORT temporary […]
MySQL: optimize column size
Question : I need a tool/command which will check a table then say something like that: columnA use tinyint instead […]
PostgreSQL relation size does not sum up
Question : I have a very large table, with blob fields, called data. I’ve tried to figure out why it […]
Schema size [PG TOAST] – PostgreSQL 9.2
Question : I’ve got the following query to measure the schema’s size on my DB: WITH schema_size AS ( SELECT […]
Choosing the right storage block size for sql server
Question : There are many articles on what storage blocks size should be used for sql server e.g. Disk Partition […]
Database design – load multiple excels daily
Question : My first post ever 🙂 Apologies if I am not so clear with my question – here I […]
Database design – load multiple excels daily
Question : My first post ever 🙂 Apologies if I am not so clear with my question – here I […]
Why Django session table grows on PostgreSQL
Question : I use PostgreSQL 9.1.6 via PgBouncer 1.4.2 in my Django 1.4.8 project. django_session table grows all the time. […]