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.
Reference : Pinal Dave (http://blog.SQLAuthority.com)