Contents
How does the active flag work in SQL?
If you do a SELECT * FROM people it would make sense to me that those entries are in a sense “active” You partition the table on the active flag, so that active records are in one partition, and inactive records are in the other partition. Then you create an active view for each table which automatically has the active filter on it.
What happens when a record is inactive in SQL?
As the name implies, the value is NULL while the record is active, but once inactivated, write in the system datetime. Thus, an index on that column ends up having high selectivity as the number of “deleted” records grows since each record will have a unique (not strictly speaking) value.
Is the active flag dependent on the primary key?
The active flag piece of data is directly dependent upon the primary key and should be in the table. That table holds data on people, irrespective of the current status of their data. The active flag is sort of ugly, but it is simple and works well. You could move them to another table as you suggested.
How to perform parallel inserts in SQL Server?
From SQL Server 2016, INSERT…SELECT can perform parallel inserts to a heap. For best insert performance, check that your query meets the criteria for minimally-logged operations, possibly requiring trace flag 610. Details can be found in the Data Loading Performance Guide.
How to flag a user in Azure Active Directory?
Log into the Azure Active Directory admin center. If a banner is displayed at the top of the page that says Check out the new portal, select the link. In the navigation menu on the left side, select Azure Active Directory. In the navigation pane, select Users flagged for risk from the Security section.
How to view user flagged for risk reports?
To access the Users flagged for risk reports in the Microsoft 365 admin center: From the navigation menu on the left side, select Admin centers. Select Azure AD. Log into the Azure Active Directory admin center.