James Rea

Get record count for a specific database

This will sum all of the records of a specified database, excluding the 'sysdiagrams' table.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.48 (33)

You rated this post out of 5. Change rating

2013-10-23 (first published: 2007-12-17)

19,842 reads

I think we might have forgotten this a bit, but on one of the...

I refresh my test SQL Servers at least monthly with a fresh VM. Setting...

Embracing Total Responsibility In every organization there comes a moment when teams must choose...

Monkey type Typing Club is a unique typing practice website that offers several features...

Comments posted to this topic are about the item Change Tracking Default Retention

I am trying to create a subscription that posts to a one drive directory. ...

I run this command on my SQL Server 2022 database:

ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON;

What is the default data retention period?