Recently I have been busy with interviewing many candidates for my organization. We are looking for some smart and experienced developers for some senior positions. I have wrote this previously SQL SERVER – Interesting Interview Questions.
I had asked following question to one of the candidate and he was not able to answer this question. I promised him that I will put answer to this question on blog.
The question was : How to find table rowcount without using T-SQL and without opening table?
Answer : Well it is quite simple by using SQL Server Management Studio.
Right click on table and click on Properties. Now on left nav of opened window click on storage and under general section there is display of Row Count.
If you have similar interesting questions, please share with me. I will post on blog.
MIS2007 is really going good. There are many things going on. As I mentioned in my previous article, It is really pleasure to meet industry leaders. There was discussion about what is good for database RAID 5 configuration or RAID 10. This subject is always very interesting.
We were discussing from small databases (5GB) to larger databases(5 TB). The question was which RAID 5 or RAID 10. Surprisingly, everybody who participated in discussion said their experience says RAID 10 is better for this particular application as there are lots of reads and writes in database. One of the expert suggested that they have seen performance improvement of more than 6 times for RAID 10. One expert expressed that though they prefer RAID 10 but their IT department suggest RAID 5. The reason was RAID 10 is very expensive over RAID 5 with 6 TB database.
Overall, we all agreed on RAID 10 without any discussion. Please consult your IT department and run few performance test before implementation.
There was very good key note address by Roger Dow, President and CEO, Travel Industry Association. It was very interesting and motivation note. He addressed the issue “There is no such thing as customer loyalty in an intensely competitive world. Customers are changing and we must change to satisfy their individual needs.” Read More:SQL SERVER – Raid Configuration – RAID 10