Code: Detail

SqlServer+Tsql - (English)

Using Sys.Partitions to do a select count

We can use Sys.Partitions to do a select count to get more performance

Last update: 13/04/2010
SqlServer+Tsql       
 
9
2
N/A
1
 

SELECT SUM(PART.rows)
FROM SYS.PARTITIONS PART
WHERE PART.object_id = OBJECT_ID( 'tbClients' )
   AND PART.index_id < 2;

Source:
 
Users who have marked this routine as a favorite
 
 
 
The site ti4fun is not responsible for the content on sites for which you have external links

Articles, routines, tips, forums, blogs or any other content posted on ti4fun site is not tested and not validated, so you should test and validate any information collected on the ti4fun site before applying it to final use environment, such as example, production. the TI4FUN site is not responsible for quality or for any damages, direct, indirect or consequential, from use of any content posted by the authors in the site.

All content published on the ti4fun site is the responsibility of the author and do not necessarily express the views of the site ti4fun and its employees.