Technical Article

sp_toptables

Are you managing big databases with a lot of tables like SAP as I'm?Do you use sp_spaceused, as I'm?Do you want to know your n biggest tables as I'm?Then don't search any longer.I'm using this script every day for may maintenance jobs.I generates, like sp_spaceused, out of sysindexes the n biggest tables without any cursor, […]

You rated this post out of 5. Change rating

2003-10-20

301 reads

Blogs

SQL Server Source Control on a $0 Budget

By

The Source Control Dilemma Every DBA has been there. Trying to keep track of...

CHOOSE’ing a Beer: #SQLNewBlogger

By

We recently published an article on CHOOSE at SQL Server Central. I thought it...

Don’t Treat Your Data Catalog Like a Data Museum

By

Introduction Treating your data catalog like a “data museum”—a static collection where information quietly...

Read the latest Blogs

Forums

The Inefficiencies of Kubernetes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Inefficiencies of Kubernetes

The Backup Space Needed

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Backup Space Needed

Implementing Fuzzy Search in SQL Server Using New Inbuilt Functions

By utsav

Comments posted to this topic are about the item Implementing Fuzzy Search in SQL...

Visit the forum

Question of the Day

The Backup Space Needed

How do I calculate the amount of space needed for I/O buffers during a backup operation?

See possible answers