Ninja's_RGR'us (11/29/2010)

---

Ya but they're basically asking to hire a Joe Celko or Paul Randal and the likes. No way in hell they'll get a quy like that for 100K...

CirquedeSQLeil (11/29/2010)

---

Ninja's_RGR'us (11/29/2010)

---

Think 180K is a high price? Most consultants I know with anything close to that experience charge 250$+ / hour... so that's almost 60% discount on that...

Steve Jones - SSC Editor (11/29/2010)

---

For e-comm, holidays don't make sense, and maybe not weekends. My point is more that the downtime is the time to do deployments, though often...

In this case, the queue that Y puts the next portion of the message into for the conversation for Z to pickup is sitting there, waiting for Z to come...

It can't be done directly within SSIS because you can only change the metadata surrounding the data flow tasks at design time. You cannot update them at runtime.

This means...

The timeout setting at the application will not cancel the query at the database. It will just stop caring about the result set, the sql side of the connection...

CirquedeSQLeil (11/29/2010)

---

GilaMonster (11/29/2010)

---

In other news...

The project from hell (the one that I spent evenings, nights and weekends on to try and meet impossible deadlines) has had the go-live date pushed...

Ram, just to get a better idea of what you're looking for...

We need multiple SQL DBA's for our fortune customer in Chicago, IL.

<snip>

Qualifications and Education Requirements

* Bachelor*s degree

* 8+...

Seconded,...

Jeff Moden (11/24/2010)

---

Except for...

bajanpoet (11/24/2010)

---

the FTP Task completely ignores the fact that it is in a For Each loop and it should run only after the successful completion of the Execute Process...

mpv-1060508 (11/24/2010)

---

My table has Order, Release, Line and many other columns. I want to select just the top 1 line for every distinct Order and Release combination. I don't care...

pnomadewolf (11/24/2010)

---

The problem is that since there are several lines of bi to each bo where bi.bostamp=bi.bostamp, i get many lines instead of just one, as i intended.

Anyone can help...

There isn't one. You're going to have to do some...

WayneS (11/24/2010)

---

Perhaps...