There are a few ways to count all of the rows in all of your tables in a database. The “Fastest Option” actually pulls the information from the database where the numbers are stored rather than taking time to count rows.
Category: SQL
Distinct Query On One Column
While this query has more than what may be needed this will help you to get data based on one unique column.
C# Backup and Restore MySQL Database(s)
Must Download DLLs from http://mysqlbackupnet.codeplex.com/
Android Contacts – Working With Duplicates
While this line is not necessary it’s a good idea to limit to this initially until you are ready to run on a larger scale.
MSSQL – Sort By Day Of Week
This script utilizes this Format Date Function to sort results based on a day of the week. The case statement in this query is easy to update if your region has a different day for the start of the week. This particular script is part of a metric that I…
MSSQL – Data Transfer
Recently I had to transfer ICD9CM codes from one database to another with limited database permissions, I decided to let the database work for me to perform the task. Ideally you’d have Visual Studio SSIS or some other mass data transfer option but this query will help you to get…
MSSQL – Identity Insert
Reference: http://technet.microsoft.com/en-us/library/aa259221(v=sql.80).aspx