Well, the averages don't look bad, but the max numbers would be a bit slow. However, it's impossible to tell if the Max numbers are relevant or just spurious.

What...

I am not sure that dropping built-in system procedures and extended procedures is supported, is it?

to a limited extent, you can do this for free using the Database Diagramming tools built-in to SQL Server.

as long as the trigger is running.

Well, let's say that MyVariable was set to " '; DROP TABLE USERS --", then the sql string in your client becomes:SELECT * FROM TABLE WHERE Field =' '; DROP...

Absolutely! 🙂

Anyway, I was going to say what Gail said (thanks, Gail 🙂 ). And, Jonathan, as always, is the man on these types of...

Uh, I'm busy sacrificing my time so that I can succeed... 😀

Right. Gail got it for me there. 🙂

UPDATE: So I spent today optimizing my CSVImporter and I have made some headway: previously it was running about 30-40% as fast as BCP, noow it is running about...

I can only imagine that you are trying to...

Garadin (10/18/2008)

---

Is it bad practice to hard code the SQL into the front end in cases such as these? I wouldn't do it, but I know a lot of...

Actually, you're still going to have problems, even if it is a script.

You see, SQL tries to compile everything in a batch. For a script, a batch is everything...

I agree too.

h.schlais (10/17/2008)

---

I still need a way to start this procedure from another one. Something I didn't mention is that this procedure has four parameters I would like to pass in...

You can,...