This was an interesting article, but one point that never seemed to come up was the performance hit from allowing the profiler to run, especially near constantly. Depending on...

Excellent Article. I ran into a very similar problem a while ago, and my final answer after struggling with it for quite some time and even taking the unusual...

I assume the way you phrase it that your data is passing through some other format such as CSV or excel before coming into SQL for your report.

If that is...

Good article, Chris.

If you truly need it to be random then the method you have is probably the way to go, but if you just want 20% of the table...

Thanks. It took some more playing around with it, but I found a way. I set the "On Click" property to check to ensure the field was either...

SiBoyd, personally I would go with Jeff Moden's solution of having a separate file that already has the column names in it, and then merge the exported file with that...

First, by white space I am going to assume you mean spaces. If you need to include tabs, carriage returns, and perhaps even other nonprinting characters then it gets...

Yes, that makes sense in that situation. If redirection, and not simply mailing lists that need to be expanded, then you could wind up with a circular reference like...

Awesome article and very interesting.

But it seems a simpler way of dealing with your problem is to change your e-mail broadcast system internally. Instead of the broadcast...

Could I ask why you...

Jose, to echo something mentioned earlier, you may wish to consider full normalization and remember that it is often better to add another table with a primary key-foreign key relationship...

I think this procedure is impressively well done.

With that said, It does seem to be a bit of a solution looking for a problem. Writing the merge...

Could you clarify what you mean a little?

If you just want multiple databases on the instance, SQL will happily do that, just create the new ones. If you want...

Beautiful article, and well written.

It seems, as with so many things in life, the key element in the article can be summed up with a quote from the...

For those that have tried it, how is the performance of a SQL Server under virtual machine running on top of linux? Is it a major hit or...