Tag: Database
-
MSSQL, jTDS, NVARCHAR and Slow Indexes
[fusion_builder_container hundred_percent=”yes” overflow=”visible”][fusion_builder_row][fusion_builder_column type=”1_1″ background_position=”left top” background_color=”” border_size=”” border_color=”” border_style=”solid” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”no” center_content=”no” min_height=”none”] An application I’ve built is going into production soon. It’s the first application I’ve been involved with which will be using MSSQL server in production, I have some learning about MSSQL…
-
Why I love Debian (and PostgreSQL)
I woke up this morning, got online through my new UMTS/HSPDA modem, and discovered that one of my servers had a load average of 239+ Not the best way to start the day. Turns out an rsync backup job between two servers had gone nuts and was spinning them up through the roof. A couple…
-
Oracle Export (exp) and Initial Extent Size Issues
If you have a large database in Oracle, with a tablespace with say 2 gigabytes worth of data in it, and you then go in a delete a large number of rows from a large number of tables, and shrink it down to about 300 megabytes worth of data, and then you create an Oracle…
-
Why Oracle makes me nuts
When left to my own devices I tend to use PostgreSQL or MySQL. They’re both free, open source, run on every platform I use, and I understand how to use them, tune them, etc…. However, when I’m building an application and database scripts that will be deployed on Oracle, and using an application which doesn’t…