Tag Info

Hot answers tagged


In my opinion you must be, or you need, a DBA. Not a single rdbms can solve problems with big data out of the box. In your case partitions can be useful for example. So data compression, etc... I can just suggest 3 alternatives: SQL Server Enterprise Edition Oracle Enterprise Edition Postgresql And the skills to manage data.


For example, I have a table which contains a column whose format is BLOB. The result I would like to get is to extract the content of the BLOB into CSV files. What is the most elegant method to do this? BCP OUT will be your best choice. Make sure your database has BLOB data (Image and/or TEXT datatypes). Also, select into should be set to TRUE ...

Only top voted, non community-wiki answers of a minimum length are eligible