Good article Jeff, nice one.

It does surprise me, though, that it's even necessary. I mean, it's 2011...

I guess that sort of thing is why I very rarely use SSMS... 🙂

Awesome article sir - I think I'll definitely be playing around with this 😀

David BAFFALEUF (9/22/2010)

---

The problem is because SQLCLR is not so well understood by the DBAs in general. And for a DBA, who carries the responsability of the corporation's data management...

If I had a pound for every time I'd learnt something either here or on Ask.SSC then I'd be...

David

Yes, the DriveInfo class does require UNSAFE because of the permissions, I said that - my bad.

However, I can't agree with the rest of what you've said. I don't see...

Jack

For going out to the OS, you generally can use EXTERNAL_ACCESS. In this instance, you actually do need UNSAFE - because of the permissions that are required to use DriveInfo...

While I like the idea, I'm not sure about storing the drive information in a static field - you would be much better off declaring a class or struct in...

Awesome, just awesome.

Plus this:

Just made my...

I'm really enjoying this series - double thumbs up sir.

Just had a quick look, and [sys].[dm_exec_query_transformation_stats] exists in 2005 SP3 with no CUs (9.00.4035.00).

And rightly...

Alvin Ramard (9/13/2010)

---

It's surprising how much plagiarism actually takes place. A discussion here on SSC a while back that started with something along the line of "this person just...

Good article sir. I still can't find the +1 button on this site though 😀

Just to note, OBJECT_SCHEMA_NAME was actually introduced in SQL Server 2005 SP2...

Nice article Jack - I think stuff like this that underlines how complex the simple can be is a real benefit to the community... 🙂

While you're at it, could you find out what the crack is with moderation now? Because I don't really know how it works, but as yet I can't find a...