Optimized way to get count of rows from a table

 

To get no. of rows from a table we usually use query

Select count(*) from table_name

But this query reads complete table to return no. of

Optimized way for performing this query is

Select rows from sysindexes where id= Object_Id(‘table_name’)

Technorati Tags:

Popular posts from this blog

Cross Apply Incorrect syntax near '.'

Recently I came across an issue in Sql Server 2005, while running CROSS APPLY. The error says that Incorrect syntax near '.'. I tried to figure out all syntax that I could apply but it did not resolve the issue. Actually we need to set sp_dbcmptlevel level to 90. There are good blog posts for this here and here , which can save your valuable time.
Read more

Apply CSS Class based on Browser

  Do you need to modify couple of CSS class attributes depending on browser?   There are various ways to achieve it. But I found this very simple approach for working on this issue.                 There are modifications needed at 2 places in the code. One is in the HTML body / ASPX page and other is in CSS file. Suppose there is DIV in your mark up and you want to apply different CSS class attributes if browse is IE6 / IE7/ IE8. Then just add a container div with id IE7 to this div. It can be added as this on ASPX page (Note- you can add this in Master page / specific page if you are not using Master Pages): - <!--[if IE 7]><div id="ie7"><![endif]-->       <div class=”category”> This is div of interest where ie7 specific rendering should be done.       </div>   <...
Read more

FirstBlog

Hello friends, We are in the age of web 2.0. With this, I am going to take next step in web. With this my own space, I will be writing on technical topics, financials which is of most interest to me and about all the new things which I will explore in my journey. Because I believe I am student of life and believe in sharing what I learn... So get ready for many more good things to come...
Read more