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

Creating a new User-Defined Data Type–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

A new chapter begins

By

In 2012 when I originally founded Born SQL, I never imagined I would find...

Daily Coping 19 Jan 2022

By

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

Read the latest Blogs

Forums

Secondary Filegroup

By jayoub

Hi, I have a quick question If I have a database with a primary...

INSERT INTO Getting error on second record values

By wburke 85918

I am trying to create a table to use for testing. I have codded...

JSON building from configuration table

By danssms

The attached file shows   the json schema - defined levels and the bottom...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers