Ask them what they really need the most. Judging from the required skills list, they're probably most interested in VLDB administration and DR, and some of the rest of...

vinu512 (10/19/2012)

---

I really don't know a lot about CLR. And I think if I start now then it would be really time consuming. So, I'd rather stick to solving this...

TravisDBA (10/22/2012)

---

Then if that is the case, then just say that. "He moved on for personal reasons" and leave it at that. I would immediately understand that, but just to...

TravisDBA (10/22/2012)

---

GSquared (10/18/2012)

I also ask: What prompted you to look for a DBA?

I want to know if I'm going to be filling the shoes of a successful DBA who has...

Ivan Mohapatra (10/18/2012)

---

no the script is just an example the query has different column and table name.

well i want to know is that will that Nolock will be helpful or...

Cast the DateTime column to Time datatype, and then use that in your Where clause. Should work for what you need.

Beyond the fact that NoLock is almost always a really bad idea, here's the data on it: http://msdn.microsoft.com/en-us/library/ms187373.aspx

Microsoft specifically states that NoLock (and Read Uncommitted) are ignored for the target...

Peter Maloof (10/15/2012)

---

"Do you have any doubts about my candidacy that I can clear up or explain further?"

Also, some people say that if you want the job, you should explicitly...

Don't let the advice about 24x7 turn you off of this too heavily. I've been on-call, 24x7, for the past 10 years, and it's only come up once when...

vinu512 (10/18/2012)

---

Eugene Elutin (10/18/2012)

---

Did your "above you" insisted that you should use trigger to execute XP_CMDSHELL? Or they just told you that SSIS should start as soon as records inserted?...

The reason "AA" is not "larger" than "D" is because it works simply by ASCII sorting. D comes after AA alphabetically, so D > AA. That's why I...

What is the SSIS package accessing the same table for? To read values out of the inserted row?

If it's to read values out of the row, then what you...

I'll second the motion on 2 & 3.

A good addition to 2 would be to move tempdb onto a separate RAID array from the main production database. If you...

Do you...

If the trigger is running forever, that means the package isn't returning control to the trigger. To find out where in the package this is hanging up, set up...