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

    


Comments

Popular posts from this blog

how to generate classes from swagger

How to create new user/account in BCC