I can see a user looking up a [single] automobile using VIN, so it needs to be included, not null, and indexed; maybe even uniquely indexed. However, just like FirstName...

I saw this the other day and thought it was kind of funny.

Man Celebrates Raise Company Will Eventually Use To Justify Firing Him

http://www.theonion.com/article/man-celebrates-raise-company-will-eventually-use-j-50485

mwilliams4nc (6/5/2015)

---

OK I see the advantages of a numerical ID for both my Vins table and my Orders tables.

So is it like this then?

tblVins

-------

VinID -- numeric -- Primary Key

Vin --...

Lynn Pettis (6/5/2015)

---

Eric M Russell (6/5/2015)

---

Andy Warren (6/5/2015)

---

Eric, I'd agree with that. But suppose there were two of you doing that. Same job, same skills. Virtual twins. Should they get...

Two of me...

The way I see it, employees should be valued the same way realestate is valued. That is, employees should be valued based on their market scarcity and revenue generating potential....

Keep in mind that your reporting tool can apply it's own sorting regardless of what ORDER BY clause is specified in the SQL query.

By default, SQL Server maintains histogram type statistics on columns referenced in conditional expressions. When supplied with table and column name, the DBCC SHOW_STATISTICS command will return a grouping of...

The coworker who can successfully login, have them come by your desk, and then do the following using your PC.

While holding down Shift key, right click on the SSMS...

If VinID and OrderID are...

I'll toss this out here as a starter and welcome any feedback from peers.

First, don't prefix your table names with 'tbl'. Personally, I do prefix views with 'v' and functions...

Can you PING the server name?

Also, can you connect using the server's IP address instead of the server name?

The solution to this problem depends on why (or if) the rowset displayed to users really needs to contain a list of sequential numbers. Attempting to maintain the sequential integrity...

For a handful of reasons, besides performance, it's best not to return all columns from a table using * but rather to specify only the minimum columns your application or...

So when...