Technical Article

A new version of RowCount

Hello,Here is a (another one, but improved) stored procedure that returns rowcounts for all tables in the current database, or only for @tablename, if provided. Output can be ordered by name or by number of rows.Improvement : Rowcount is right aligned and formatted with thousand separator.To use it : - open a connection on your […]

You rated this post out of 5. Change rating

2002-07-11

305 reads

Blogs

Moving T-SQL Tuesday to Jekyll

By

I got a message a few months back that Microsoft was deprecating the MySQL...

European Microsoft Fabric Community Conference announcements

By

A TON of new features announcements at the European Microsoft Fabric Community Conference help...

RDS Connectivity

By

I travel quite a lot for work. Most of it is in the US...

Read the latest Blogs

Forums

An error occurred while skipping data rows

By yrstruly

I am trying to build an ETL for an Existing Table. The ETL (SSIS)...

What is causing this error?

By Rod at work

(This is probably the wrong forum to be posting this question, so please forgive...

Changetracking disabled in database snapshot, new bug in ms sql 2019 ?

By FHoornaert

Hi, We are using database snapshot together with changetracking to keep a datawarehouse up...

Visit the forum

Question of the Day

Data Migration Assistant Targets

In the current (2024) version of the Data Migration Assistant, which on-premises targets are available?

See possible answers