I had a lot of fun writing that bit. It makes reading press-releases and blogs almost bearable finding this stuff.

Steve, you're supposed to be on holiday!

Yeah. spMakeWebTask. I love using this for dishing out excel-based reports via email. I still use it, but with a delegation process for doing daily reports (I'm too idle to...

In the spur of the moment, we all occasionally forget that people who post articles, or contribute to forums, are our guests, and therefore deserve courtesy. At the same time,...

Jeff,

What does the standard give us as far as Time-based information goes? As I see it, it is the ability to store time zones along with dates, and have a...

Jeff,

My solution was almost identical, except that I did an explicit create for the temporary table. (I'm showing my age here; It used to lock system tables for the whole...

[p]Over to you Jeff. I had to nip off...

Thanks both of you for the info. That was very helpful, and makes the SMO solution look very attractive.

[p]I've got a 'quirky' Update solution that motors. I'd love some real data to run comparative timings on.[/p]

Alexander Kuznetsov (12/24/2008)

Actually in most cases the best alternative is a loop written in a modern language such as C#,

not a T-SQL WHILE loop or a CURSOR. Not only...

Is the SMO library freely-distributable? What would happen if you created a Powershell application using SMO, and then wanted to install it on a computer that didn't have SSMS on...

The whole question of microgeneration in Britain is surrounded by Poppycock and balderdash, with generous lashings of baloney. I have been trying for years to harness the 45KW of energy...

Thanks Gaby, You've been a good sport, and it has been a great discussion. I bet your next SSC article will be wonderful. My first one was ghastly. ...

I'm a bit puzzled by this article. Surely, in order to illustrate the dangers of using cursors or 'WHILE' loops, you would expect to see an example where there is...

Yes. All volumetrics are an educated guess. Well, they were when I did them. Multiply by the contingency factor and you have a size to use all the way from...