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...

Gift Peddie (12/27/2010)

---

MSDN downloads and DVD/CD are AnyCPU binaries so Microsoft can provide x64 and AnyCPU builds that will install in x86 operating systems for developers and testing. In...

Gift Peddie (12/27/2010)

---

...That is a myth Oracle sells but I have not run x86 Oracle in any company for more than eight years, selling only x64 for production and development...

leroy-1092048 (12/27/2010)

---

I guess i have a question...

Would a company really upgrade their production SQL server to the upcomming version and then say...

hey! lets just upgrade SQL server but keep it...

I don't know what level of access you have on the server to verify this, but perhaps the latest version of MDAC needs to be installed or re-installed. You can...

SQL Server is already seen as being limited, in comparison to Oracle, because it only runs on the MS Windows operating system. I think that removing 32bit support from the...

One way to get related items into a delimited column is using a sub-select and for xml clause. This involves the awkward problem of stripping off the leading or trailing...

Some of my older sub-queries that were using a GROUP BY with MAX() for things like "get the most recent address" or "get the primary phone number", I've replaced that...

As a part time data analyst and part time roaming developer, I see a lot of database, and if I were going to stand up and give a talk about...

I think it's a lot easier to pick up development or (especially) admin skills on SQL Server when compared to Oracle.