Viewing 15 posts - 3,211 through 3,225 (of 6,041 total)
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 29, 2015 at 12:16 pm
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,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 29, 2015 at 12:06 pm
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 29, 2015 at 9:18 am
william-700725 (10/28/2015)
...I know there are at least some high-paying un-challenging gigs out there.
WHERE? Those are the ones I want but can never find. I always get stuck having to earn...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 29, 2015 at 9:04 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 29, 2015 at 8:47 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 29, 2015 at 7:47 am
GoofyGuy (10/28/2015)
... a top-end consultant probably wouldn't be interested in anything other than a challenge.
So then ... the less-exalted aren't interested ever in challenges, they're just in it for...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 28, 2015 at 3:26 pm
Gary Varga (10/28/2015)
Eric M Russell (10/19/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 28, 2015 at 12:48 pm
Gary Varga (10/28/2015)
Eric M Russell (10/28/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 28, 2015 at 9:13 am
ben.norris (10/28/2015)
Eric M Russell (10/27/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 28, 2015 at 8:24 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 28, 2015 at 7:37 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 28, 2015 at 7:26 am
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.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 27, 2015 at 12:36 pm
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 27, 2015 at 12:22 pm
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 27, 2015 at 10:56 am
Viewing 15 posts - 3,211 through 3,225 (of 6,041 total)