Record Count for Tables

This script was created for an Oracle to SQL 2005 migration. It creates a table, and then populates it with the record counts for each table in a given schema. (You will need to replace the xxxx text with your schema name for it to work). I prefer populating a table with this data, then […]

2 (1)

2007-09-24 (first published: )

1,000 reads

Blogs

Join me at SQLBits 2020

By

The SQLBits conference is taking place in London again this year, between March 31st...

DBA, a job, a vital job

By

DBA, a job, a vital job. T-SQL a language that is fun. Select, a...

SOS_SCHEDULER_YIELD – What is it really telling us?

By

I decided to write this off the back of a conversation I was having...

Read the latest Blogs

Forums

Question up greading

By itmasterw 60042

Hi, I see the post of going from 2012 - 2019 but we were...

Constraint on multiple columns

By SIJCOOKE

Hi, I want to restrict users from adding duplicate rows. Is there a way...

Table self-join for derived columns

By pwalter83

Hi, I have a requirement to derive additional columns and populate the values by...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers