I’ll explain this by using examples in DDL, using SQL Server syntax. The short version of this is fairly simple. Every table that you want to use in relations should have a primary key ...

In SQL Server, a function that returns a single value is known as a “scalar UDF” or “scalar user defined function”. These scalar UDFs are automatically categorized as deterministic or non ...

NCS allows you to take backups with LiteSpeed using native SQL Server syntax, so you don’t have to alter your current routines. I can’t tell you how much this sped up my implementation.