Tables [dbo].[tsr_stats]
Properties
PropertyValue
Row Count0
Created11:07:35 AM Wednesday, March 07, 2007
Last Modified11:09:13 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key XPKtsr_stats: job_id\job_runjob_iddecimal(31,0)17
No
Cluster Primary Key XPKtsr_stats: job_id\job_runjob_rundecimal(31,0)17
No
mb_processeddecimal(31,0)17
Yes
n_indexed_rowsdecimal(31,0)17
Yes
cpu_timedecimal(31,0)17
Yes
elapsed_timedecimal(31,0)17
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKtsr_stats: job_id\job_runXPKtsr_statsjob_id, job_run
Yes
SQL Script
CREATE TABLE [dbo].[tsr_stats]
(
[job_id] [decimal] (31, 0) NOT NULL,
[job_run] [decimal] (31, 0) NOT NULL,
[mb_processed] [decimal] (31, 0) NULL,
[n_indexed_rows] [decimal] (31, 0) NULL,
[cpu_time] [decimal] (31, 0) NULL,
[elapsed_time] [decimal] (31, 0) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tsr_stats] ADD CONSTRAINT [XPKtsr_stats] PRIMARY KEY CLUSTERED ([job_id], [job_run]) ON [PRIMARY]
GO
Uses