Lynn Pettis (3/13/2013)

---

Nothing here to work with. Many of us have optimized SQL to perform similar calculations in the database reducing processing time from hours (or longer) to subsecond....

Hello, you don't need any third party tool.

You can extract binary files from SQLServer BLOB fields using VBScript.

I am using a script (a simple text file with .vbs extension) like...

Eugene Elutin (3/11/2013)

---

...

But, the most important thing, is that making the change in a C++ procedure let me use the full power of the C++ language. Can't be beaten by...

Eugene Elutin (3/11/2013)

---

...

But, the most important thing, is that making the change in a C++ procedure let me use the full power of the C++ language. Can't be beaten by...

Eugene Elutin (3/11/2013)

---

...

Also, to be able to "make the best use of the underlying DB engine" you must acquire a deep knowledge of the DB engine, and I am not...

Eugene Elutin (3/11/2013)

---

fmuzul (3/11/2013)

---

...

Maybe you live in a different world than mine. For me the redeploy of an application is not a problem, I just need to replace a .exe...

Lynn Pettis (3/11/2013)

---

fmuzul (3/11/2013)

---

Lynn Pettis (3/11/2013)

---

In addition, if the underlying table structure changes but the output of the stored procedures remains the same, you isolate the changes to the database....

Lynn Pettis (3/11/2013)

---

fmuzul (3/11/2013)

---

Gazareth (3/11/2013)

---

Well, I think you've got both ends of the argument there in the last couple of posts!

But what's with the paranoia over DBA's Francesco? We're not...

Lynn Pettis (3/11/2013)

---

In addition, if the underlying table structure changes but the output of the stored procedures remains the same, you isolate the changes to the database. You modify...

Eugene Elutin (3/11/2013)

---

Calling statement! :w00t:

I'm afraid you will not find...

I...

My suggestion is: avoid stored procedures at all, unless you have very special needs of performance on some complicated operations.

I know that here, at SQLServerCentral, many people are skilled DB...