70 lines
3.3 KiB
XML
70 lines
3.3 KiB
XML
<?xml version="1.0"?>
|
|
<SqlWorkbenchSqlProject xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Name="OCTPDBA-365 Check index usage stats of [Entry] table">
|
|
<Items>
|
|
<LogicalFolder Name="Connections" Type="2" Sorted="true">
|
|
<Items>
|
|
<ConnectionNode Name="(local):CENTRALINFRA\ua208700">
|
|
<Created>2022-12-06T13:24:23.3133285+01:00</Created>
|
|
<Type>SQL</Type>
|
|
<Server>(local)</Server>
|
|
<UserName />
|
|
<Authentication>Windows Authentication</Authentication>
|
|
<InitialDB />
|
|
<LoginTimeout>30</LoginTimeout>
|
|
<ExecutionTimeout>0</ExecutionTimeout>
|
|
<ConnectionProtocol>NotSpecified</ConnectionProtocol>
|
|
<ApplicationName>Microsoft SQL Server Management Studio - Query</ApplicationName>
|
|
</ConnectionNode>
|
|
<ConnectionNode Name="ama001aps\apssql:CENTRALINFRA\ua208700">
|
|
<Created>2022-12-06T11:15:49.8449403+01:00</Created>
|
|
<Type>SQL</Type>
|
|
<Server>ama001aps\apssql</Server>
|
|
<UserName />
|
|
<Authentication>Windows Authentication</Authentication>
|
|
<InitialDB />
|
|
<LoginTimeout>30</LoginTimeout>
|
|
<ExecutionTimeout>0</ExecutionTimeout>
|
|
<ConnectionProtocol>NotSpecified</ConnectionProtocol>
|
|
<ApplicationName>Microsoft SQL Server Management Studio - Query</ApplicationName>
|
|
</ConnectionNode>
|
|
<ConnectionNode Name="sun008aps.sunstore.ch\apssql:CENTRALINFRA\ua208700">
|
|
<Created>2022-11-07T09:36:04.9485106+01:00</Created>
|
|
<Type>SQL</Type>
|
|
<Server>sun008aps.sunstore.ch\apssql</Server>
|
|
<UserName />
|
|
<Authentication>Windows Authentication</Authentication>
|
|
<InitialDB />
|
|
<LoginTimeout>30</LoginTimeout>
|
|
<ExecutionTimeout>0</ExecutionTimeout>
|
|
<ConnectionProtocol>NotSpecified</ConnectionProtocol>
|
|
<ApplicationName>Microsoft SQL Server Management Studio - Query</ApplicationName>
|
|
</ConnectionNode>
|
|
</Items>
|
|
</LogicalFolder>
|
|
<LogicalFolder Name="Queries" Type="0" Sorted="true">
|
|
<Items>
|
|
<FileNode Name="idx usage with definition.sql">
|
|
<AssociatedConnectionMoniker>8c91a03d-f9b4-46c0-a305-b5dcc79ff907:sun008aps.sunstore.ch\apssql:True</AssociatedConnectionMoniker>
|
|
<AssociatedConnSrvName>sun008aps.sunstore.ch\apssql</AssociatedConnSrvName>
|
|
<AssociatedConnUserName />
|
|
<FullPath>idx usage with definition.sql</FullPath>
|
|
</FileNode>
|
|
<FileNode Name="maintain entry indexes.sql">
|
|
<AssociatedConnectionMoniker>8c91a03d-f9b4-46c0-a305-b5dcc79ff907:(local):True</AssociatedConnectionMoniker>
|
|
<AssociatedConnSrvName>(local)</AssociatedConnSrvName>
|
|
<AssociatedConnUserName />
|
|
<FullPath>maintain entry indexes.sql</FullPath>
|
|
</FileNode>
|
|
<FileNode Name="Search table in dbs.sql">
|
|
<AssociatedConnectionMoniker />
|
|
<AssociatedConnSrvName />
|
|
<AssociatedConnUserName />
|
|
<FullPath>Search table in dbs.sql</FullPath>
|
|
</FileNode>
|
|
</Items>
|
|
</LogicalFolder>
|
|
<LogicalFolder Name="Miscellaneous" Type="3" Sorted="true">
|
|
<Items />
|
|
</LogicalFolder>
|
|
</Items>
|
|
</SqlWorkbenchSqlProject> |