+1 An excellent source of this type of information.

SQL_ME_RICH (11/9/2012)

---

Hi opc...It was a timing thing to determine how long a database would be available that we are doing slow boat to china copy jobs from. It's a...

I guess I would ask...why is it so critical to know?

The 2008 (non R2) docs say exactly what the 2005 docs say. I would venture a guess that 2005 - 2008 R2 hold the logical same value per the 2008...

Good to know, you're welcome. Thanks for posting back that you found a path forward!

cs_troyk (11/9/2012)

---

opc.three (11/8/2012)

---

cs_troyk (11/8/2012)

---

opc.three (11/8/2012)

---

cs_troyk (10/29/2012)

---

Not that I advocate switching to a "toy" RDBMS, but MySQL does have the GROUP_CONCAT operator which makes this type of thing a little more...

snomad (11/8/2012)

---

Would still be interested in the answers wrt physical drives & raid config. I've tried all the Powershell commands that look likely and am afraid there may be...

There is merit to your approach Jeff, namely keeping all database code transactionally consistent along with the data it operates on, but we do diverge when it comes to security....

Heh, well, if the developer baked the use of xp_cmdshell directly into the T-SQL process then yes, it will take a bit of work to refactor the call to the...

Precisely, and a Remote PowerShell session at...

mike.renwick-894639 (11/9/2012)

---

Once you've gone through the trouble of securing xp_cmdshell, setting up a proxy etc, in my view, one of its biggest benefits, is plain old simplicity.

In our case, we...

cs_troyk (11/8/2012)

---

opc.three (11/8/2012)

---

cs_troyk (10/29/2012)

---

Not that I advocate switching to a "toy" RDBMS, but MySQL does have the GROUP_CONCAT operator which makes this type of thing a little more elegant. It's...

Here is a pretty complete walk-through implementing the Oracle OLE DB driver on 64-bit SQL 2005 connecting to Oracle 10g via a Linked Server. I would expect the steps to...

Sorry, I am not sure why I mentioned it at all for since you are on 64-bit, I wasn't paying close attention and only picked up on "32" being discussed...

cs_troyk (10/29/2012)

---

Not that I advocate switching to a "toy" RDBMS, but MySQL does have the GROUP_CONCAT operator which makes this type of thing a little more elegant. It's something to...