Tag: SharePoint / BI

Community

Conditional Indexes….

(Vivek Sharma) Conditions are mostly applied to a SQL Query to filter set of rows from a rowset. These conditions allow optimizer to make a sensible guess on the Indexes to be used and the execution path to be chosen. But apart from the Queries, these conditions can also be applied to Indexes to opt

Community

A Clean Exit

(Jim Mischel) The fundamental problem is that once the main program starts the logging thread, that thread runs essentially forever because there is no clean way to shut it down. Calling Thread.Abort will in most cases cause the thread to exit, but it’s hardly a clean way to do things. Thread.Abort