SELECT *
FROM (
    SELECT TOP (1) vacationhours AS 'Max_VacationHours', *
    FROM [HumanResources].[Employee]
    ORDER BY vacationhours DESC
) AS q1

UNION...

My earlier comment on the model got lost (this site seems to do that sometimes with posts that go to a new page).

Overall I think you did an excellent job...

No, unfortunately you can't use WITH TRUNCATEONLY to free the space.

Fragmentation is possible from the SHRINK, so you'll have to check if any tables need rebuilt after you've shrunk the...

That should reclaim space from that table back to the database itself.

I think you'll still need to run SHRINKFILE to free the space the database itself back to the disk.

Does the system need to prevent duplicate responses to a Ticket?  That would be complex to do at the very least.

Remember, too, that the logical data model should be easily understood and use by business people.  In fact, if possible, keep all developers out of the...

You could just use the 1st for the day, which would mean it was still a valid date:

CONVERT(varchar(10), DATEADD(MONTH, DATEDIFF(MONTH, 0, Tab.date), 0), 120)

This link gives a few reasons for choosing shorter varchar lengths.

In terms of storage, CHAR(n) columns are always n characters long.

VARCHAR(n) columns are anything between 2...

Remember, too, that the logical data model should be easily understood and use by business people.  In fact, if possible, keep all developers out of the first one...

Thank you for your reply.

Scott...

No,...

You can.  That's the two choices for a code column: use a view to encode/decode and/or use a separate lookup table.  A lookup table is technically a better design, but...

1. There is no way that I'd ever create column names with spaces in them.  It relegates you to always have to use brackets around every column name that...

In the distribution db, query view dbo.syssubscriptions

Hi Scott. Thanks for your reply. I understood most of what you said. I'd kindly like to ask for some clarification on some parts. But here is what I...