partition liuMay 29, 20191 min readTo achieve SUM(distinct) over partition by in sqlserver and oracle
partition liuMay 20, 20191 min readcheck partition table information for partition table in MSSQL on special disk
partition liuFeb 24, 20191 min readHow to add VTL tapes on DD6300 & label them into "Oracle_VTL" pool
partition liuFeb 24, 20192 min readA way to monitor DDL, DML and loging for MSSQL without using triggers
partition liuFeb 24, 20191 min readThe way get information from mssql by using excel vba and special port
partition liuFeb 24, 20191 min read‘A’ = N’A’ , will not kill index seek in sqlserver version above 2014 anymore
partition liuFeb 24, 20192 min readIndexed (materialized) views in SQL Server,different with Oracle (materialized) views
partition liuFeb 24, 20191 min readpartition_show , a new version to check partition table status in sqlserver
partition liuFeb 24, 20191 min readHow to setup backup by using EMC NW + EMC NMM for sqlserver failover cluster (not always on)
