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…

PHP Code Snippets Powered By : XYZScripts.com