8<

>8

An is_active flag (someone can be inactive and still not "terminated", e.g. "suspended"), specifically, makes perfect sense to me because the specific inactive date / conditions may be...

>>But you display only vague dates not associated with any year. I'm going to make a suggestion that you use the MySQL convention four months. It is based...

No and no, to answer your two questions.  I saw how the OP was basically ignoring design suggestions and came to the same conclusion as Scott's last statement and...

You wouldn't want to detach the db just to move a file.  Just ALTER the file location in SQL Server, take the db offline, copy the file, then bring the...

I believe you...

Nothing to do with data modeling, only development.  Data modeling must precede coding.

Just don't offer terrible modeling advice and I won't have to point it out.

The big tasks are the SSIS packages and SSRS reports.  Often they require quite a bit of rework.  I'd start checking those out as soon as you can.

The other stuff...

The current (pseudo)design is horrifically bad.  You have non-dependent columns in tables, repeating columns (address1, address2 / phone1, phone2), update/delete anomalies all over the place, and so on.

Stop rushing to...

Make sure the [Reference_Table_Obsolete_Date] is getting populated correctly on all obsoleted rows.

If that date is NULL for both rows (old and new), that will not be allowed for a unique...

I admit I'm confused.

LEN() has always not counted trailing spaces.

When I need to count trailing spaces, I usually just add a non-space and then subtract 1:

SELECT LEN('ABC' + SPACE(3)), LEN('ABC'...

Again, as I noted above, the current leave status (30/365 in this case) should be stored in the main employee "header"/"master" table.  Prior leave status(es) (21/365 in this case) would be...

DATALENGTH() is supposed to return the byte length of the entire value.  Is is not doing that?  MS's doc seem to imply that it should (then again, we've all seen...

Is your db at compatibility 150 level?  I know it almost certainly is, but I'm trying to think of anything that might cause DATALENGTH() to not work correctly (and I...

The employee's current leave status (yes/no, days/year) can go in the main employee table.  It should be encoded, such as a tinyint.  If the leave status changes, you store the...

It would be helpful if you could give us the definitions of all the objects involved.