Database: mssql Queries to take table backup: select * into xxx_price_bkp_20160602 from xxx_price Make sure to check number of records: select count(1) from xxx_price_bkp_20160602 To verify locks/long running process on DB sp_who2 Query to verify full index enabled on DB SELECT CASE WHEN FULLTEXTSERVICEPROPERTY('IsFullTextInstalled') = 1 THEN 'INSTALLED' ELSE 'NOT INSTALLED' END IsFullTextInstalled
Posts
Showing posts from June, 2016
Customizing CSC application
- Get link
- X
- Other Apps
Customize panel pages: Customized panel jsp( /panels/xxx/xxx.jsp) should be configured in serviceFramework.xml as below <? xml version = "1.0" encoding = "UTF-8" ?> < framework-template xsi:noNamespaceSchemaLocation = "http://www.atg.com/xsds/FrameworkDataSpecification.xsd" xmlns:xsi = "http://www.w3.org/2001/XMLSchema-instance" > < panel-definition > < id > cmcOrderSearchP </ id > < app-id > workspace </ app-id > < enabled-yn > true </ enabled-yn > < object-type > PanelDefinition </ object-type > < resource-bundle > atg.commerce.csr.FrameworkResources </ resource-bundle > < template-ids...