And depending on the SAN and the SAN administrator, I would create some test LUN's and practice the move first. I've seen windows/SAN administrators get confused, and move a...

I will think through it. It is a very clever approach, the relationship of the date and row_number. My problem is that the original dates are already...

Just be aware that IF UPDATE does NOT check if the value is changed, only if it is updated (i.e. in an update statement). So if you had

...

How accurate does it have to be, i.e. can it occasionally return false positives? Something like this can be very fast even for large results, but it is possible...

It's implied in some of the referred to postings, but bear in mind that any such effort will almost always then end up needing to take company holidays or other...

Sqlraider (2/10/2011)

---

I understand. I wasn't expecting a direct answer.

I just strongly believe that you should not throw out a resume just because the applicant does not have a B.S., experience...

I sometimes throw away resumes because they are not in good English. I...

Jack Corbett (2/8/2011)

---

Ferguson (2/8/2011)

---

I am not saying I would not consider you, but I will try to answer your perhaps rhetorical question.

Someone who as a young adult decides to put...

Jack Corbett (2/8/2011)

---

I agree that this is a much better posting, albeit one I am not qualified for.

I think that you should almost always include "or equivalent experience" when listing...

Brandie Tarvin (2/8/2011)

---

Ferguson (2/7/2011)

---

Degrees are always a sore point. I need to think about that a bit. I fully realize some people with great skills never got a...

Craig Farrell (2/7/2011)

---

Whelp, I'm out. I usually rely on my experience to make up for this. ...

I didn't mean to let this die so long, but a blizzard and several other issues intervened. We are going out with a new job description and a new...

That works, but it can cause some issues on instances with dynamic ports....

While we are on this subject one little documented issue is when people try to use domain accounts (but not domain admin accounts) as the service account for SQL. ...

I tried it both ways, it was marginally faster with the clustered index first....