EdVassie (8/21/2012)

---

A lot of people seem to be writing as though 'the cloud' is some homogenous entity that exists somewhere just this side of the horizon. This makes it...

Shawn Dube (8/20/2012)

---

Hey Michael,

I get that question a lot! 🙂

It definitely is not a common need but one of the things my company supports are compensation plans for direct marketing...

Shawn Dube (8/20/2012)

---

Thanks for this article and the original! One question though... have you tried a very deep hierarchy on any of your methods? Like a million node binary tree...

Read a few of my posts. Long-winded doesn't even begin to do justice to my...

If you just need to show the amount of data, without worrying about what it actually has in it, you can use Len() or DataLength() to get that.

If you need...

Actually, if you're breaking the log chain anyway, you could just set to Simple Recovery for the duration of the delete process, and run a checkpoint after each batch. ...

Not really. You can get a general idea, in that it's usually smaller than the database (assuming free space in the data and log files).

Do you have a table with what the subject numbers mean? Like 0919 is Arts, and so on?

If so, that will make this much, much easier. Throw a...

Nice.

I've been using SSD on my PC at home, and it's made a huge difference, but I haven't had a chance to play with them in a server environment yet.

Are the log backups likely to take over the disk you're putting them on? If not, then this makes sense. Might want to add an explicit Commit to...

I know you can't restore to prior versions. I haven't tried prior partial-versions. Try it and find out.

Details on varbinary(max) can be found here: http://msdn.microsoft.com/en-us/library/ms188362.aspx

Basically, 2 Gig is the largest you can store in any of the "max" data types.

Does that help?

Are you storing the results of the query in a variable as a recordset?

If so, then create a For Each Next loop, set the source for it as the recordset...

As a proof-of-concept exercise, I built a "set-based" version of your UDF. It doesn't use any explicit loops, and so on. I tested the two side-by-side, and the...

I have to ask why you have "Señorita" but not "Señor", and a few others like that. Or did I just miss them in the list?

As far as the...