SQL SERVER – Find Table Rowcount Without Using T-SQL and Without Opening Table

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.

rcnt SQL SERVER   Find Table Rowcount Without Using T SQL and Without Opening Table

If you have similar interesting questions, please share with me. I will post on blog.

Reference : Pinal Dave (http://blog.SQLAuthority.com)

SQL SERVER – MS TechNet : Storage Top 10 Best Practices

This one of the very interesting article I read regarding SQL Server 2005 Storage. Please refer original article at MS TechNet here.

  • Understand the IO characteristics of SQL Server and the specific IO requirements / characteristics of your application.
  • More / faster spindles are better for performance.
  • Try not to “over” optimize the design of the storage; simpler designs generally offer good performance and more flexibility.
  • Validate configurations prior to deployment.
  • Always place log files on RAID 1+0 (or RAID 1) disks.
  • Isolate log from data at the physical disk level.
  • Consider configuration of TEMPDB database.
  • Lining up the number of data files with CPU’s has scalability advantages for allocation intensive workloads.
  • Don’t overlook some of SQL Server basics.
  • Don’t overlook storage configuration bases.

Reference : Pinal Dave (http://blog.SQLAuthority.com) , MS TechNet .

SQLAuthority News – Author Visit – MIS2007 Part II – Database Raid Discussion

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

unica1 SQLAuthority News   Author Visit   MIS2007 Part II   Database Raid Discussion

Reference : Pinal Dave (http://blog.SQLAuthority.com)