Follow me !
Search this blog
TagsAIX Apple automation backup best practices Bootcamp cloud cursor db2 db2 compression db2 hadr db2 performance db2 tuning db2 v9.5 db2 v9.7 db2move db2pd google indexes install iPad iPhone linux Macbook memory NULLID Oracle package performance restore runstats script shell script sql SQL805N SQL Server stored procedure tablespace time machine tuning ubuntu ubuntu 9.04 upgrade Windows on Mac wordpress
DisclaimerThe posts here are solely my personal views and opinion. Any technical advice or instructions are based on my own personal knowledge and experience, and should only be followed by an expert after a careful analysis or consultation with technical support. Please test any actions before performing them in a critical or nonrecoverable environment. Any actions taken based on my experiences should be done with extreme caution. I am not responsible for any adverse results. I do not represent any vendor or product.
Author Archives: rpillai
Here how you would create a new file system : First create a new partition using fdisk. eg: fdisk /dev/sdb –> Options (m , n,p,1, ,t,8e,w) Create volume group vgcreate myvg /dev/sdb1 Create a logical volume lvcreate -L … Continue reading
Feeling the Drill I have been using Apache Drill to explore data for a while now. Apache Drill is a low latency distributed query engine for large-scale datasets, including structured and semi-structured/nested data. Drill supports a variety of NoSQL databases and … Continue reading
Today I had a need to find the index fragmentation on one of my sql server database and I found this script buried on my computer, thought I will share it here: DECLARE @DatabaseID int SET @DatabaseID = DB_ID() SELECT … Continue reading