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, […]

2003-10-20

295 reads

Blogs

Deadline for Microsoft MVP contributions is 20 March 2023

By

Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...

Why Managed Identities are Awesome

By

For the first workdays of this new year, I had the pleasurable task of...

Goal Progress for Jan 2023

By

The grade for January is a D. Details below, but just not making a...

Read the latest Blogs

Forums

Anderson-Darling Calculation

By jackdanny816

Hi   I am following an article posted on sql server central on the...

Use of an NCI - that does not contain the Column required.

By SteveOC

Hello. I am a bit confused and not sure what terms to use to...

SQL Server 2019 error and Usage reporting not starting

By hungtrung

we use two SQL instances on one server - both SQL Server 2017 and...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers