This script uses a cursor to loop through all tables and get the count and table sizes using sp_spaceused. It is much faster and efficient than use 'SELECT COUNT(*) FROM TABLE_NAME'.
2012-06-22 (first published: 2012-06-09)
1,988 reads
Delete Duplicates in SQL Server without using Cursor or Temporary tables
2012-06-21 (first published: 2006-11-22)
3,247 reads
2012-06-20 (first published: 2012-05-30)
8,756 reads
A script to help you find the Precision & Scale parts of a decimal value.
2012-06-19 (first published: 2012-06-04)
4,990 reads
Generate a script of insert statements with column names for any table including those with identity columns.
2012-06-15 (first published: 2012-05-22)
3,143 reads
Sometimes you just need to populate a CHAR/VARCHAR column for testing with a random selection of string literals at table CREATE time. Here is a quick and easy script.
2012-06-14 (first published: 2008-01-16)
1,181 reads
SQL Server 2012 introduces a new string concatenation function. This can be recreated in earlier versions of SQL Server.
2012-06-06 (first published: 2012-05-16)
2,171 reads
These are scripts I run each morning on my registered CMS servers to check immediate health.
2012-06-04 (first published: 2012-05-09)
2,890 reads
The code below uses a CASE STATEMENT to group sales data based on date,week,month and quarter. It should be executed in AdventureWorks 2005 or 2008.
2012-05-30 (first published: 2012-05-10)
2,043 reads
This function returns all the necessary version information in a table.
2012-05-28 (first published: 2012-03-21)
3,167 reads
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...
Most apps that call an LLM send every request to the same model. That...
By Steve Jones
“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...
Hub Via Wa:628218200233 Alamat: Jl. Dokter Sutomo No.50-50A, Ps. Jambi, Kec. Ps. Jambi, Kota...
Hello everyone , I am planning to migrate a database from SQL Server 2014...
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers