It has been always confusion between whether we should use 32bit OS or 64bit system… and in present time it has been quite common to have 64 bit system specially in an enterprise environment or even servers. I think the main reason for that is memories are getting cheaper and processing power of processors increasing
Tag: How To
SQL Server Views … gotcha while using sp_refreshview
Last week I blogged about use of Views in SQL Server. We also saw different types of view and best practices for designing new view and limitations that may prevent us creating a view too. As a part of best practice while designing we should always include keyword, WITH SCHEMABINDING which prevents any accidental changes
Oracle 11g R2 and Windows 7 … dealing with Enterprise Manager Troubles
So, this weekend I thought to refresh my experience with Oracle. And in that attempt, I decided to install latest of Oracle DBMS family, Oracle 11g. Now, it’s been a while since I used oracle, it was version 10g. And they have been significantly improved in version 11g, so I wanted to try them. But
SQL Server Installation Rules and “System Reboot Required” Error
When we do installation or removing SQL Server, it always executes installation rules. And what really weird is, installer even checks for these rules when we want to Un-install the SQL Server (kind of reminds me, my experience with Office ‘97 which had quite similar craving for installation media while uninstalling). Today, when we were
Newsgroups … playing with ancient form of Forums …
If you are like me, then probably you already familiar with Forums and their uses (other than searching Pornos ofcourse ) … if you look at the history you will find that forums came to existence not too early … but their another form was here since early ages of Internet … it was is
And now we have official WP 3.0.1 …
Well, I have been using WordPress 2.8.6 since I started blogging … and WP 3 got released some where during June 2010…since then it was telling me to upgrade to 3.0.1 but I was feeling lazy to do so because at first I thought its kind of ultra complicated process (and it is because I
Windows Performance Tuning … some old school tricks
If you are like me, you hate to wait for 10 mins after you click on Internet Explorer to open it up. Then you should read rest of post … as here, I won’t review any software or so called “system optimizers” that can dramatically improve performance of system with just a single scan !!