ibzmiller (1/4/2011)

---

Hi Eric,

I had approached it this way initially. I had a script ready and everything. But thought that maybe it would be cleaner to delete/less prone to error...

ibzmiller (1/3/2011)

---

Hi Guys,

I'm working with SQL Server 2005 and need to deploy table changes to the live database which has existing data. All I'm doing is adding a couple...

CirquedeSQLeil (12/30/2010)

---

I have seen both places to be productive. I prefer a good mix between both environments. That way some face-to-face resolution can be done. Also, by...

Stefan Krzywicki (12/30/2010)

---

Yeah, I do need to get around to buying that DMV book I've been meaning to get. I was just waiting for it to be finished first, but...

There is a reason for multiple indexes. For example, if a reporting type query only searches on BusinessDate,...

When you post a resume on a job site, I think that most employers just text search and skim over the online version. However, when we interview candidates, we do...

You could call MS Access a low end development tool, because it supports the construction of complete applications, having a scripting language, forms, database, and reporting engine all bundled together....

...

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

---

I'd highly disagree with this. Just...

Is this what you mean by sorting a string in numeric order?

1

1.1

1.3.4

1.22.0

I haven't worked in an office in some time, but I do remember a constant stream of interruptions. An hour of time without someone talking to you was rare, and...

DBA Rafi (12/28/2010)

---

Thanks for your detailed answers.

As you said, If such warning is not available in SQL Server, then It's fine. No Issues. I should go with that.

But I don't...

paul.knibbs (12/29/2010)

---

I don't see a problem with this. As I noted above, 64-bit support on the hardware side has been pretty much universal for at least four years now, and...

My understanding is that there are multiple developers writing "CRUD" procedures, and you guys are having a hard time keeping on the same page regarding what foreign key relationships are...

Of course the BI group doesn't always get the biggest budget, and often times they're working with...