Export (0) Print
Expand All

Table.EnumLastStatisticsUpdates Method (String)

Enumerates a list of information about the most recent statistics updates for the specified statistic counter.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

public DataTable EnumLastStatisticsUpdates(
	string statname
)

Parameters

statname
Type: String
A String value that specifies the statistic counter to which to limit the results.

Return Value

Type: DataTable
A DataTable system object value that contains a list of information about the most recent statistics updates.

Column

Data type

Description

Name

String

The name of key or index on which the statistic counter is based.

LastUpdated

DateTime

The date and time when the statistics were last updated.

The following code example demonstrates how to enumerate statistic update information.

C#

Server srv = new Server("(local)");
Database db = srv.Databases["AdventureWorks2012"];
Table tb = db.Tables["Address", "Person"];

DataTable dt;
dt = tb.EnumLastStatisticsUpdates("PK_Address_AddressID");

Powershell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2012")

$tb = $db.Tables.Item("Address", "Person")
$dt = $tb.EnumLastStatisticsUpdates("PK_Address_AddressID")
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft