Murali Krishna

UI notification for windows services is not directly possible. Typically event log can be updated with windows service.  UI notification can be achieved with another application that consumes windows service to give notifications.

 UPDATE scrcrd SET scrcrd.sku_health = skrev . sku_health FROM tbl_SLM_Scorecard scrcrd JOIN tbl_SLM_SKU_Review skrev ON scrcrd . material = skrev . material and scrcrd . month_yr = skrev . month_yr where scrcrd . month_yr = '2015-01-31' and skrev . material is not null and skrev . sku_health <> scrcrd . sku_health

SQL: Scale Up vs. Scale Out Check Description Optimize the application before scaling up or scaling out. Address historical and reporting data. Scale up for most applications. Scale out when scaling up does not suffice or is cost-prohibitive. Schema Check Description Devote the appropriate resources to schema design. Separate online analytical processing (OLAP) and online transaction processing (OLTP) workloads. Normalize first, denormalize later for performance. Define all primary keys and foreign key relationships. Define all unique constraints and check constraints. Choose the most appropriate data type. Use indexed views for de...