Really good article that covered a whole lot.  The high point is how managers want everything but don't want to pay anything.  I also believe that capital expenditures shouldn't be...

Actually, it IS an option.  HEAPs work just fine for things like Audit...

>> I want to have a sum of the item count reset to 0 when the sum >= 6. <<

Did you know that a table must have a key...

my guess is that your table should look something like this:

CREATE TABLE Personnel

(employee_id CHAR(5) NOT NULL PRIMARY KEY,

employee_type CHAR(1) NOT NULL

CHECK (employee_type IN (???),,

employee_name VARCHAR(30) NOT NULL);...

I hope you understand that the old Sybase IDENTITY table property (property -- it is not a column) can never by definition be a valid key. It is a...

Microsoft actually does make a distinction between "System Base Tables" and "System Tables".  Please see the articles at the following links for more information...

https://docs.microsoft.com/en-us/sql/relational-databases/system-tables/system-base-tables?view=sql-server-2017

https://docs.microsoft.com/en-us/sql/relational-databases/system-tables/system-tables-transact-sql?view=sql-server-2017

There are also "System Views"...

IMHO, the closest thing to a CROSS APPLY is a "Correlated Sub-Query" with an implicit join, which can return more than one row per input row if you're...

It would appear that the OP has flown the coop instead of answering the question I posed.

IMHO, the closest thing to a CROSS APPLY is a "Correlated Sub-Query" with an implicit join, which can return more than one row per input row if you're not careful...

When job hunting, I'm point blank with potential employers or recruiters about what my current salary is. The way I see it, if either party can't match the expectations...

There are awesome people on this site. There are also some not so awesome people on this site, and heck maybe I'm not one of the awesome people on...

It will vary depending on what the CU is and does.  If the documentation for the CU doesn't contain that information, then there's no way to predetermine it.

My first recommendation would be to stop using such homegrown methods.  Temporal tables work a fantastic treat and the audit table they leave behind is pretty much immutable with virtually...

Yes, but I wouldn't.  I'd do the migration between the servers.

Ahhh... I've got to disagree a bit.  Instead of changing to comparability level,  SQL Server 2017 does have the ability to use the old cardinality estimator at at...