If you're a contractor, then you're free to work for other clients, and you invest in yourself by self training and strategically choosing your gigs.

My initial thought is using information_schema views or sys tables to enumerate what table/column combinations constitute primary keys, join to any other tables that contains the same column combination, while...

I don't think you can rank IT developers on a single bell curve the same way you could an assembly line operator. It's more like ranking actors or chefs, where...

WayneS (9/21/2015)

---

pietlinden (9/21/2015)

---

Eric,

I go to the user group meetings the vast majority of the time. Hard to argue with free training where you can ask questions. =)

Maybe my problem is...

Honestly, if this recruiter is approaching you from some website like LinkedIn or Indeed, then I wouldn't even bother responding. You especially don't want to give them anything like source...

Dave62 (9/21/2015)

---

Jack Corbett (9/21/2015)

---

... Even though I'm considered a permanent FTE by HR, I consider myself a contractor with benefits. They can get rid of me...

The database tables are what integrates line of business applications, backend processes, and business intelligence. To change the schema of the tables, you have to get everyone on the same...

erichansen1836 (9/10/2015)

---

...

If you implement a Network database file system of 500 MDB files, each acting as a partial table within the 5 billion row database, each MDB file containing 10...

Regarding feelings of guilt about leaving, it's not necessarily directed toward the company but rather for co-workers who have become friends. As for the company itself, consider that the average...

.. Staying or going isn’t about loyalty, it’s about what is best for you and you can measure that in any way you want – money, vacation, or anything else....

Kristen-173977 (9/17/2015)

---

What about if majority of messages are small enough to fit in-row?...

First, from the client PC with connectivity issue, confirm you can ping server name and IP.

First, consider giving surrogate key identifiers a unique names, and a broadly used standard is to use <tablename>ID (ie: MessageID instead of just ID). I'd recommend making this...

You can leverage the INFORMATION_SCHEMA.COLUMNS system table, which contains one row for each table and column in the database, to build up a SQL select statement into a variable.

To execute...

Sean Lange (9/17/2015)

---

Eric M Russell (9/17/2015)

---

Someone had mentioned that the date/time conversions can be expensive. Depending on what you're needing to do with the dates and times once they're converted,...