====== Fast COUNT ======
  * This technique shows how get count from MSSQL fast, if you have lot of rows.
  * I is significantly faster than //select count(*) ...//
  * But in some cases result couldn't be exact.
  * The code bellow is code for creating stored procedure, which returns row count of table, which name was passed as a procedure parameter

<code sql>
CREATE PROCEDURE [dbo].[table_Count] 
@tableName nvarchar(255),
@ID bigint OUTPUT
AS
BEGIN

    SELECT @ID=rowcnt
    FROM sysindexes
    WHERE indid IN (1,0)
        AND OBJECTPROPERTY(id, 'IsUserTable') = 1
        AND OBJECT_NAME(id) = @tableName
	
END
</code>