[dbo].[tsr_stats]

[dbo].[tsr_stats]

Properties
Columns
Indexes
SQL Script
Uses

Property	Value
Row Count	0
Created	11:07:35 AM Wednesday, March 07, 2007
Last Modified	11:09:13 AM Wednesday, March 07, 2007

Columns

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key XPKtsr_stats: job_id\job_run$	job_id	decimal(31,0)	17
$Cluster Primary Key XPKtsr_stats: job_id\job_run$	job_run	decimal(31,0)	17
	mb_processed	decimal(31,0)	17
	n_indexed_rows	decimal(31,0)	17
	cpu_time	decimal(31,0)	17
	elapsed_time	decimal(31,0)	17

Indexes

	Name	Columns	Unique
$Cluster Primary Key XPKtsr_stats: job_id\job_run$	XPKtsr_stats	job_id, job_run

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