Any just why would ever do anything as insane as moving the users from the old instance to the new one? Those pesky users.

Thanks.

Thanks.

I was more concerned about installing a new instance of SQL Server (FULL) when an instance of SQL Server Express already exists and then realized that both can exist...

:: cough ::

Some of the other ways...?

MR@SD (3/6/2012)

---

David, taking your example, TrailerActivityHeaderId and TrailerActivityHeaderTrailerNumber are not the names I would vote for. I would not name a table TrailerActivityHeader but TrailerActivity instead (Header is implied). Then...

"The true cost of software development is not when the software is originally created, but when it has to be modified, regardless if its the original developers making the changes...

My DB is a backend for an ASP.NET app as such being descriptive and using easy to remember column names comes in handy when working on the markup or the...

I used follow that logic as in TrailerActivityHeaderId, TrailerActivityHeaderTrailerNumber in a table named 'TrailerActivityHeaders' and then started omitting the prefix on the grounds that it was neccessary given the table...

Typically if I'm working with multiple columns with the same name, its usually in a view at which point I alias them as in 'Name' columns become 'BranchName', 'DepartmentName', 'FacilityName'....

When I said qualify, I was referring to qualifying the name of the column - TemplateDescription instead of Description within the table Templates. Technically 'Template' is not neccessary before...

It isn't staff scheduling/availablity oriented. Its more similar to the example of the various dates that I gave where overlap is entirely possible.

Its for a scheduling module. Each date can have different start/end times. Since the majority of the start/end times will be the same, the idea is to speed entry by...

I just dropped it into production and it is looking very, very sweet. Not to mention that it saves me an immense amount of time. My specific need is the...

Jeff Moden (11/19/2011)

---

Very cool feedback. Thanks, David.

As a side bar, if you meant for both dates in your example to be inclusive, you'll need to add "1" to the...

I am *way* so liking this. After however many months, I'm actually to the point of needing to play with this and was quite surprised at just how easy it...