Just as a side note:

I don't know on what RDMS you learned SQL, but at least in Oracle, NULL and empty string '' are evaluated as equivalent. Also, by default...

Maybe I'm missing something, but the table appears to lack a unique index on the natural key, which would allow duplicates. This would normally be a requirement for any table,...

This should give you what you want. What we need to do is simply sum the total months of service for each employee who is still active (has one record...

william-700725 (10/28/2015)

---

WHERE? Those are the ones I want but can never find. I always get stuck having to earn...

Let's assume that the sync application is attempting to create an index on Customer table called ix_CustomerName. If you don't want that index, then you could try creating a filtered...

Four years after the article was published; is the business still bugging developers?

It helps if your IT department is using TFS or JIRA to manage requests the same way as...

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...