Nice, clear, well written article with good advice. Thanks!

Sure... create a scheduled job... you can use SQL Server...

... and that's why I hate multiple-guess questions... gimme a good solid essay question or lemme write some code, instead!

That was a fun conversation to watch... thanks, Gents. 🙂

Heh... and Marketing.

Nice explanation, Barry!

rbarryyoung (6/11/2008)

---

That sounds like a challenge...!

Seriously though, "useful" and "appropiate" were not part of your specs. 🙂 They're a lot harder to fulfill. (Though as Lynn says,...

Matt Miller (6/11/2008)

---

Jeff Moden (6/11/2008)

---

Heh... ok, I gotta ask... has anyone actually ever...

Heh... ok, I gotta ask... has anyone actually ever done a Fourier Transform...

Thanks for the feedback. Just curious, what type of "math functions" are you talking about?

VALEK (6/10/2008)

---

ps: I answered the original question correctly FYI, but I just wasnot happy with ... the tools used to generate a testbed. QA engineers and Professional Software Testers will...

nenad.prekupec (6/11/2008)

---

The reason of opinion that CLR is slower then T-SQl is just because people didn't get familiar with CLR and doing ridicules performance test to show CLR is slow.....

Ya got me... I've worked with tables as large as 200 million rows,...

For those that want to follow along in English...

http://msdn.microsoft.com/en-us/library/ms178129.aspx

There are many problems with the command that you have submitted. First, do you have a table already available called MyTestFormatFiles...

I agree with Paul's assessment... it's a good thing to plan on that type of scalability, always... but I see no mention of "clustered" servers or the other things that...

Heh... No matter what, I'm happy I don't have to earn a living by taking Matt's tests 😛 They are thought provoking to say the least...

Then, BigInt should do the trick.