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

294 reads

Blogs

Microsoft industry clouds

By

In talking with Microsoft customers, I have found that most are not aware that...

Two Clustered Indexes?

By

Everyone knows that you only get a single clustered index, right? Wouldn’t it be...

Daily Coping 18 Jan 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Will my Query affect any rows in the DB??

By Imrans23

Dear All, Hope you are doing well. I am really new to SQL and...

Will my Query affect any rows in the DB??

By Imrans23

Dear All, Hope you are doing well. I am really new to SQL and...

Setting a variable from a multi-table Select

By JaybeeSQL

Hi all, I have a variable to declare, and this works: Declare @CopyFromUser Varchar(10)...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers