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)

2007-05-24 (first published: )

2,722 reads

Blogs

Be careful with table updates

By

The dire warning in the subject line is not meant to scare you. Rather,...

Daily Coping 1 Dec 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Building a pacemaker cluster to deploy a SQL Server availability group in Azure

By

There are new Ubuntu Pro 20.04 images available in the Azure marketplace with SQL...

Read the latest Blogs

Forums

Help with Column Visibility Expressions

By Jeffs1977

I have a parameter in my report labeled as PaySource. PaySource has 3 values...

SQL Server and CloudStrike

By Leo.Miller

Has anyone had issues with CloudStrike Anti-Virus on their SQL Servers? I've had a...

Table Date field format

By shank-130731

I created a date field [Datte] in SQL v2008. I then link with MS...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers