Viewing 15 posts - 3,706 through 3,720 (of 6,041 total)
Whether a MERGE performs an INSERT, UPDATE, or DELETE depends on the logic you have coded in the MATCHED clause.
Based on the code you posted earlier, it hinges on...
July 1, 2015 at 1:46 pm
The career path for someone with a CS / CIS / MIS degree is more structured. Once you get that degree, in the eyes of most HR departments you're basically...
July 1, 2015 at 1:33 pm
Many universities have separate curriculum for CS, CIS, and MIS, but they overlap at the 100 and 200 level. The vast majority of IT jobs are about applied technology, it's...
July 1, 2015 at 10:57 am
Rod at work (7/1/2015)
Eric M Russell (6/30/2015)
July 1, 2015 at 9:13 am
GoofyGuy (6/30/2015)
None of the following are technical questions, they're just simple and conversational, but they reveal a lot.
One question I often ask is, 'What are the title and author of...
July 1, 2015 at 8:27 am
There is a certain type of candidate who all seem to share the same basic resume, which seems impressive on the surface (a tag cloud with 30 different technical skills),...
June 30, 2015 at 12:20 pm
Kevin Kline does a good 200 level talk on SQL Server architecture, starting with how the database engine receives SQL queries and then parses, compiles, caches / re-uses, executes, retreives...
June 30, 2015 at 10:49 am
GoofyGuy (6/30/2015)
... I've interviewed a lot of folks for the position of "Sr. Developer" and "Sr. Database Administrator" over the last several years and with great disappointment. Most of the...
June 30, 2015 at 10:39 am
Jeff Moden (6/30/2015)
Eric M Russell (6/30/2015)
Jeff Moden (6/29/2015)
As some of you may know, I've interviewed a lot of folks for the position of "Sr. Developer" and "Sr. Database Administrator" over...
June 30, 2015 at 8:44 am
My wife has often uttered a particular saying during stressful times in her career. She spent 20 years working in computer telephony and speech, often in sales, and would remind...
June 30, 2015 at 7:52 am
Jeff Moden (6/29/2015)
As some of you may know, I've interviewed a lot of folks for the position of "Sr. Developer" and "Sr. Database Administrator" over the last several years and...
June 30, 2015 at 7:33 am
Assuming you have a large table which is batch loaded, essentially a flat data warehousing type table (not OLTP), and there is a need to perform ad-hoc type queries against...
June 29, 2015 at 10:33 am
What I do sometimes is click on the 'Print' link to display the article in print friendly layout, and then I'll save it as a PDF document using the PDF995...
June 29, 2015 at 8:21 am
While there have always been DBAs that tightly controlled their systems and acted as impediments to change, I think those positions are disappearing fast. More and more companies, if they...
June 29, 2015 at 8:03 am
Viewing 15 posts - 3,706 through 3,720 (of 6,041 total)