You can find the MS min, but the practical minimum will be higher, and it will depend on the load you through at the server. Memory is one thing that...

I think you'll need to show us some samples and ideas. I'm not quite clear what you mean by aggregating. If you are adding up previous rows, what's a previous...

Good points and we shouldn't assume that people are all DBAs.

However I'd expect them to do some work, even if it's showing me in the post they've thought about the...

whoop upside?

what's next, shocking keyboards? loud raspberries when someone responds?

Boy, I hope there's room for dummies. Sure seem to be a lot of them out there.

Robert Frasca (10/16/2009)

---

I guess I need to learn to read a little more carefully. My apologies. However, I must take one final whack at this dead horse. ...

Most of the formats are here: http://msdn.microsoft.com/en-us/library/ms187928.aspx

I think the issue is that the filenames when they are copied are the same, and so the wizard fails.

My guess is that you would want to script out the...

You wouldn't use a variable, and you wouldn't go through each row.

If I understand, what you likely want to do is use a CASE statement for the other fields. In...

To guarentee some rows as first, you'll need a query to get just those two rows and then union that with your query to get other rows.

Your sample data doesn't...

Great discussion, and nice points (as always), Hugo!

I agree with Silverfox here. Don't take the "a degree/certification/etc shows an effort" to mean that the lack of it shows no effort. They aren't equivalent.

If you have them, or...

I'd like to say Teddy Roosevelt, but I think he's a classic DBA. Strong willed, a bit of a bully, and pushing things through with a sheer force of will...

Asking for help shouldn't be a problem. If management expects that you always have the answer, then you are working in a ticking time bomb. At some point you'll have...

Great...