Based on the last five rows, it looks like you would want to use a CTE to go back through ancestors (parent -> grandparent -> great-grandparent -> etc. until you...

On top of the technical reasons not to that have already been mentioned is a business reason:  SQL Server is frequently your most expensive storage.

Is the primary key on LogID clustered?

Are inserts slow? Updates? Selects? All? Does slow mean seconds/minutes/hours? For how many rows in a transaction?

If the transaction rate is...

• This reply was modified 2 years ago by ratbak.

How many rows? How large is the average error? max?

When you say slow to query/slowing the table down, do you mean select queries? Insert queries? Both? You don't have updates,...

Can you provide the link to that article?

Layout on that page is rendering most of the article illegible (at least in Chrome).

SQL Server 2012 SP4 is here

Security Update for SQL Server 2012 SP4 (KB4057116) is here 

replace(replace(col1,char(146),''),char(133),'')

Maybe a TVP w/ SortColumnName and Direction/SortOrder columns? SortOrder could be constrained to 'ASC' & 'DESC', or '+' & '-'

With validation in the procedure that SortColumnName is actually a valid...

Are your database & the referenced tables/columns using case-sensitive collation? If not, get rid of the UPPER() functions in your where clauses to ensure sargability.

Duplicate of https://www.sqlservercentral.com/forums/topic/the-target-princial-name-is-incorrect-cannot-generate-sspi-context

Yes, we need to track if a plot is subdivided or merged. Can you explain how to do this?

Maybe an ParentPlot/AncestorPlot table association table, with PlotID, ParentPlotID, ChangeType (SubDivide, Merge),...

That looks pretty good.

Police station is an interesting attribute of plot. It seems like that could change over time. Do you care about that historically, or only the current value?

Do...

To use out-of-row for LOBs:

EXEC sp_tableoption 'SchemaName.TableName', 'large value types out of row', 1;

To release unused space:

DBCC CLEANTABLE (MyDbName,"MyTableName ", BatchSize)

(BatchSize is optional)

If that...

The error is pretty specific:

The configuration file contains an element that is not valid. The #text element is not a configuration file element.

Have you  looked at rsreportserver.config (probably @...