--=_NextPart_000_0401_01C51E40.7BE320B0
Content-Type: text/plain;
charset="windows-1255"
Content-Transfer-Encoding: quoted-printable
Hi,
is there a method of getting table current size?
TIA!!
--=_NextPart_000_0401_01C51E40.7BE320B0
Content-Type: text/html;
charset="windows-1255"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hi,
is there a method of getting table = current size?
TIA!!
--=_NextPart_000_0401_01C51E40.7BE320B0--Hi
Have you looked at sp_spaceused ?
John
"z. f." wrote:
> Hi,
> is there a method of getting table current size?
> TIA!!
>
>|||This is a multi-part message in MIME format.
--=_NextPart_000_0419_01C51E49.1F69CB00
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
thanks!
is there a sample of using it in a loop for getting all tables =information?
"John Bell" <JohnBell@.discussions.microsoft.com> wrote in message =news:A7ABFB91-352A-4816-8601-51CAA844C8AC@.microsoft.com...
Hi
Have you looked at sp_spaceused ?
John
"z. f." wrote:
> Hi, > > is there a method of getting table current size?
> > TIA!!
> > >
--=_NextPart_000_0419_01C51E49.1F69CB00
Content-Type: text/html;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
thanks!
is there a sample of using it in a loop =for getting all tables information?
"John Bell"
--=_NextPart_000_0419_01C51E49.1F69CB00--|||You could use Nigel's script:
http://www.nigelrivett.net/SQLAdmin/SpaceUsedAllTables.htm
l
Rgds,
Paul Ibison (SQL Server MVP)|||select object_name(id) as 'Table', used from sysindexes
Madhivanan|||This is a multi-part message in MIME format.
--=_NextPart_000_0066_01C51E6F.E2788700
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
sp_MSForEachtable 'sp_spaceused ''?'''
-- Roji. P. Thomas
Net Asset Management
https://www.netassetmanagement.com
"z. f." <zigi@.info-scopeREMSPAM.co.il> wrote in message =news:OEDE0hjHFHA.2976@.TK2MSFTNGP15.phx.gbl...
thanks!
is there a sample of using it in a loop for getting all tables =information?
"John Bell" <JohnBell@.discussions.microsoft.com> wrote in message =news:A7ABFB91-352A-4816-8601-51CAA844C8AC@.microsoft.com...
Hi
Have you looked at sp_spaceused ?
John
"z. f." wrote:
> Hi, > > is there a method of getting table current size?
> > TIA!!
> > >
--=_NextPart_000_0066_01C51E6F.E2788700
Content-Type: text/html;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
sp_MSForEachtable 'sp_spaceused ''?'''
-- Roji. P. ThomasNet Asset Managementhttps://www.netassetmanagemen=t.com
"z. f."
thanks!
is there a sample of using it in a =loop for getting all tables information?
"John Bell"
--=_NextPart_000_0066_01C51E6F.E2788700--|||This is a multi-part message in MIME format.
--=_NextPart_000_003C_01C51E55.AFC03570
Content-Type: text/plain;
charset="windows-1255"
Content-Transfer-Encoding: quoted-printable
Try my stored procedure, that lists the sizes of all tables or top n =tables:
http://vyaskn.tripod.com/sp_show_biggest_tables.htm
-- HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"z. f." <zigi@.info-scopeREMSPAM.co.il> wrote in message =news:u8JdQ$iHFHA.3332@.TK2MSFTNGP15.phx.gbl...
Hi,
is there a method of getting table current size?
TIA!!
--=_NextPart_000_003C_01C51E55.AFC03570
Content-Type: text/html;
charset="windows-1255"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Try my stored procedure, that lists the sizes of all =tables or top n tables:
http://vyaskn.tripod.com/sp_show_biggest_tables.htm">http://vyask=n.tripod.com/sp_show_biggest_tables.htm-- HTH,Vyas, MVP (SQL Server)SQL Server Articles and Code =Samples @. http://vyaskn.tripod.com/">http://vyaskn.tripod.com/
"z. f."
Hi,
is there a method of getting table =current size?
TIA!!
--=_NextPart_000_003C_01C51E55.AFC03570--
No comments:
Post a Comment