In essence, SQL Server view can be considered as a “Virtual Table”. When we create a view, user “feel” no difference between it and a table. And we can query it exactly same way as we query any other table. View can be really handy when we are using some super complex query to get
Month: September 2010
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
Database Normalization … taming the wild horse
For any application to use database and hence data effectively it is very important that data is organized properly. The most common problem for database is redundancy in data. If table has highly redundant data, that means for every operation (like insert, update or delete) it takes more effort to find correct record. And it
Trip to The Smokies … Day 7,8,9 … End of days
Well, it was really a good time at Axesh’s (that is name of friend we were visiting at Iron Station, NC) home. He is family known to us since our days back to India. It was fun remembering old days and we played cards till very late. Being resident of CT, I was quite amazed
Trip to The Smokies … Day 4,5,6 … Nothing better then 100% natural air
Well, there are many places to see at the national reserve. But if you are looking for tall buildings and crowded cafes then its not your place to be… If you like to feel the nature then you are at the right place my friend. In all these days this is only what we have
Trip to The Smokies … Day 2-3 … On top of the world !!!
Yessssss … finally after @ 10 hrs. of crazy drive we are finally at our motel at Gatlinburg. And it was night already so we had to skip the idea to go to Clingmans Dome. Instead we moved around the city. It was not night at Times Square for sure but undoubtedly it was very
Trip to The Smokies …. Day 1 & 1/2 … Holding Faith a Little Longer
And, the trip has officially begun for me. We reached at our motel by 11:30 pm and we have to reach our temple exactly by 12:00 (as it is time when viewings will begin). Unfortunately we didn’t make it, we reached there by 12:30 and viewing was already closed. My mom felt that it is