Touchstone 2022 Database Reference
tShrinkQueue Table
AIRProject Database : tShrinkQueue Table
Description

Reserved for internal use.  Stores records that were shrunk using functionality built into SQL Server. An internal wrapper around this functionality ensures that shrinking: 

  • only affects AIR databases.
  • does not work on databases that are in use by other AIR processes.
  • Performs robust yet incremental shrinks that frees disk space almost immediately.
Properties
Creation Date4/4/2022 3:02 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ShrinkQueueSIDUnique system-generated sequential identifier for the record in the shrink queue.int4   
 DataSourceName

User-provided name of the data source.

For a complete list of names, see tDataSource Table.

varchar255   
 DataSourceTypeCode

Code that represents the type of data source used in the project.

For a complete list of codes, see tDataSourceType Table.

varchar10   
 EnteredDateDate the record was added to the shrink queue.datetime4 
(getutcdate())
 
 ShrankDateDate the record was shrank.datetime4  
See Also

Related Objects

AIRProject Database

 

 

Verisk Analytics Client Confidential

© 2022. AIR Worldwide is now Extreme Event Solutions. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact Verisk Analytics with questions or comments.