hosting is not new, SQL on VM is not new, RDP and many other TLA is not new.

What's new is that Amazon is offering another product. For those whom...

We have code similar to this to manage EAV tables.*

I believe the dynamic SQL executing DDL in a loop reduces your database to a very expensive scripting environment for running...

I thought "Select *" was banned from production environments for this (and other) reasons.

Are we saying it is acceptable for View definitions with the caveat that someone remembers to update...

tabs

To borrow from web design: semantic meaning. If the tab character (following newline) is taken to mean "indent" then four levels of indentation is literally 4 tab characters. ...

I suggest the schema should be redesigned and this code would be...

Seconded. I also suggest sharing how you mitigate...

"A column of type sql_variant may contain rows of different data types."

fwiw: I parse that sentence at least two ways. I believe the correct meaning is that the...

jimbobmcgee (1/10/2012)

---

That said, I do want to offer some pointers with the .NET code itself, which I feel would make this better as a teaching article or reusable code block:

[enumerated...

Just to clarify for those confused by the eating association to these animals, we don't eat black cats for Halloween either.

The question is sound. My attention span is not.

I would hope those who are paid to hold the title of DBA are able to do these maths without too...

I'll accept code that goes through the mutations of evolution and the bandaid & tourniquet approach to solving problems - if those that have touched code have left comments. ...

Hugo Kornelis (11/9/2011)

---

I must say that the low rate of correct answers surprises me. I intended this question to be a relatively easy first question in a series (hence the...

dav0id (10/25/2011)

---

I would tend to agree with Mike Dougherty-384281. This approach seems like a bad idea for a number of reasons.

Why not use a "FOR XML" query and transform...

I'd like to suggest that this solution strikes me as a bad idea. Why are you asking your database to do so much string manipulation? If you're using...

While this code does the job I have to ask, "Why would you want your SQL Server deleting files?"

There isn't even any data-driven relationship to the files. We induct...