User-Defined Functions

Technical Article

RE: sp_prepexec procedure problems

  • Reply

sp_prepexec does two things 1. Prepares the Stored procedure execution plan 2. Executes the stored procedure Now the first step usually takes some time depending on the complexity of stored procedure and WITH RECOMPILE option set/not set etc.. Are you saying that sp_prepexec is appearing repeately and frequently for the same stored procedure? Then this […]

You rated this post out of 5. Change rating

2003-08-07

Technical Article

RE: QOD 30/07/2003 Incompetent Inc

  • Reply

Agreed, I was also mislead by the 'typo'. Malformed question, refund all lost points for this QOD! Somebody might sue 🙂 quote: I would just like to point out that, although many incompetent people refer to the Wndows 2000 Server product in this manner, there is no such product as Microsoft Windows 2000 Standard Edition. […]

You rated this post out of 5. Change rating

2003-07-30

Technical Article

RE: VP application with Oracle 8i

  • Reply

Hi ashokc, quote: I am getting following error when I ran my VB programe. Run-time error ‘-2147467259(80004005)' Oracle error occurred but error message could not be retrieved from oracle. Can any one suggest me how to remove this error. do you mean something like Err.Clear or On Error Resume Next? Cheers, Frank

You rated this post out of 5. Change rating

2003-06-27

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers