Technical Article

User Tables with Size  all DBs (SQL 2005 Only)

Hope this is helpful to someone.  This script will create a table and a stored procedure in the master database to gather and store table info for all datbases. The sp uses a temp table to hold the results returned by sp_spaceused, then transfers the information to the permanent table DatabaseTableSizes and adds the database […]

5 (1)

2007-07-16 (first published: )

274 reads


sp_GetRowcount: How to count the number of rows in any SQL Server table fast


Have you ever had to find the number of rows in a user table,...

Webinar with Pavilion Data 2022.02.09


Heraflux Technologies was invited to co-present on an “Ask the Experts” webinar with Pavilion...

VS Live Cancelled


I got a note this week from the organizers of VS Live. They let...

Read the latest Blogs


Stored Procedure Error

By water490

Hi I am creating stored procedure for the first time.  I am getting error:...

Run SQL Query in C#

By water490

Hi I am working with SSIS to automate data collection.  I need to make...

configure SSRS using powershell

By Dan

Dear all, I am seeing an issue with configuring SSRS When I am trying...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers