Miles Neale (8/22/2012)

---

Yes, we will be more cloud oriented next year and in the years to come. But we will not be using the cloud for any business sensitive...

Nadrek (8/22/2012)

---

.... Worse, when SSD's fail, you don't have much of a way to wipe the data off them other than by physically destroying the drive (sledgehammer, torch, welding...

Sergiy (8/21/2012)

---

Nothing actually can guarantee the order of the rows in the table. Not...

You're very welcome. Glad we could help.

To test maximum depth for HierarchyID, I just ran this test (same table definition as in the article):

SET NOCOUNT ON;

GO

TRUNCATE TABLE dbo.HierarchyTest;

GO

INSERT INTO dbo.HierarchyTest

...

I consider those just a flavor of Nested Sets. It has the one advantage that...

venoym (8/21/2012)

---

GSquared (8/17/2012)

I'm not going to dignify you with further discussion. I asked about the difference between the two, if you actually read what I wrote, and you respond...

If it's a download task, it will fail if the file it's looking for isn't there. No way to simply re-route the process if the file isn't there, it...

Add in Union for full concatenation. Intersect doesn't actually add sets together, it finds the data that's common to two sets.

Is this one a homework question? It kind...

The first part is easy. SSIS can do a For Each loop over the files in a directory, and it's easy to get it to import all of them...

What you want for that is something like this:

CREATE TABLE #Categories

(Cat_ID INT,

Cat_Name VARCHAR(25));

INSERT INTO #Categories

...

You're on the right path. Now you just need to put your file system task (and any related tasks) inside the loop, and set the source connection to use...

Steve Jones - SSC Editor (8/21/2012)

---

GSquared (8/21/2012)

---

Matt Honan used the Apple version of "the cloud" for its convenience, and paid the price. He should have known better, and says...

Best of luck in the new gig.

Might be copies of Express Edition installed by other applications. Might be from installing .NET Studio (I think it does that, anyway). Definitely not safe to unstall them...