Wayne West

  • Interests: Card/board game design, photography

Technical Article

Get record count for every table in a database

I wrote this code to make it easier to compare record counts between a live database and a restored copy to test my backups, I thought people might find it useful. You need to run it against your live side when you do the backup that you're going to restore and compare against.Copy the output […]

5 (1)

You rated this post out of 5. Change rating

2007-05-24 (first published: )

2,729 reads

Blogs

A New Word: Ghough

By

ghough – n. a hollow place in your psyche that can never be filled;...

T-SQL Tuesday: Encryption and Data Protection

By

I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...

Parameterize your Databricks notebooks with widgets

By

Widgets provide a way to parameterize notebooks in Databricks. If you need to call...

Read the latest Blogs

Forums

ASCII value of certain column is null

By SQL_Surfer

When ASCII(Column) is null, what does it represent? Is this some kind of special/control...

Need to output table data into multiple CSV files

By Mh-397891

Hello, I created the below script to output 999 rows from SQL Server table...

Changing Database page Verify on a Database in an AG

By John D

I have a database on SQL 2019 in an Availability Group (AG) and I...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers