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. This blog post is about finding a table row count without using T-SQL.
I had asked following question to one of the candidates and he was not able to answer this question. I promised him that I will put answers to this question on the blog.
The question was: How to find table row count without using T-SQL and without opening tables?
Answer: Well, it is quite simple by using SQL Server Management Studio.
Right click on table and click on Properties. Now on the left nav of opened window, click on storage and under general section there is a display of Row Count.
Here is one question for you – how will you get the total number of the rows with T-SQL. If you know the answer, just post it over here. I have already provided hint in this blog post so it should be easy for you. Let me know what you think of this blog post.
If you have similar interesting questions, please share with me. I will post on the blog.
Reference: Pinal Dave (http://blog.SQLAuthority.com)