aquasmit/sqlserver-get-rows-count-on-large-table.sql

Last active July 10, 2018 14:03

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/aquasmit/5f36ff58e6cc8e9a5372783629065ffb.js"></script>
Save aquasmit/5f36ff58e6cc8e9a5372783629065ffb to your computer and use it in GitHub Desktop.

Download ZIP

SQL server - get approximate count of rows from a table with large number of records

Raw

sqlserver-get-rows-count-on-large-table.sql

	use [SALES]

	/This returns approximate count/
	EXEC sp_spaceused N'dbo.Customers';
	GO

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment