GoofyGuy (10/28/2015)

---

So then ... the less-exalted aren't interested ever in challenges, they're just in it for...

Gary Varga (10/28/2015)

---

Eric M Russell (10/19/2015)

---

...Top-end contractors are able to sniff out bad management from the start and pass the "opportunity" over, so the organization isn't likely to acquire them...

Gary Varga (10/28/2015)

---

Eric M Russell (10/28/2015)

---

...another advantage of Char(1) is that it offers the flexibility of supporting additional codes in the future. Computers reduce the world as 0 | 1,...

ben.norris (10/28/2015)

---

Eric M Russell (10/27/2015)

---

However, if a single column approach is more appropriate, then I still prefer not to use 1 or 0 but rather a character using a less...

Honestly, I hate healthcare IT, specifically healthcare data. The problem is that you have a lot of disparate vendors with proprietary and inconsistent data, who out of necessity must exchange...

If you're going to do something like copy production data down to lower (ie: Dev and QA) environments, then you need a formalized process that is approved and scoped by...

Glenn Berry maintains a lot of system information type DMV queries on his blog site. You might find something there to fill in some of the missing items.

https://sqlserverperformance.wordpress.com/2012/06/11/sql-server-2008-diagnostic-information-queries-june-2012/

You mentioned that you are managing the database. Of course you can do everything you need using T-SQL from a query window, but going with any other tool (like MS...

Are we simply talking about what tool or technique to use for migrating data from an old transactional database into a new transactional database (ie: SSIS) ?

http://www.amazon.com/Server-2012-Data-Integration-Recipes/dp/1430247916

Or are we talking...

Whether an IT department is Great or Lousy; it's determined by the aggregation of those of us in the department.

One great quote in there is "velocity is more important than perfection", which is a tenet that I have found to be very true over the years. It's not...

My (admittedly un-scientific) belief is that only a small percentage of organizations in private (or public) sector engage in what could be genuinely called "data science". Whatever predictive modeling they...

below86 (10/27/2015)

---

Eric M Russell (10/27/2015)

---

However, if a single column approach is more appropriate, then I still prefer not to use 1 or 0 but rather a character using a less...

I generally look to see what the most common condition is. That condition gets the zero value. The abnormal condition gets the 1 value. Then I just name the column...

I mentioned earlier that I prefer using two date columns to indicate active status like so:

ActiveDate date not null default (getdate()),

InactiveDate date not null default ('9999-12-31'),

check (InactiveDate >= ActiveDate),

However,...