Click here to Skip to main content
15,867,835 members
Home / Discussions / Database
   

Database

 
AnswerRe: How to encrypt? Pin
Ujjaval Modi25-Dec-07 23:35
Ujjaval Modi25-Dec-07 23:35 
GeneralRe: How to encrypt? Pin
Rock Star.26-Dec-07 0:12
Rock Star.26-Dec-07 0:12 
AnswerRe: How to encrypt? Pin
Paul Conrad26-Dec-07 12:12
professionalPaul Conrad26-Dec-07 12:12 
Generalsql server 2000 stored procedure Pin
Sonia Gupta25-Dec-07 21:17
Sonia Gupta25-Dec-07 21:17 
GeneralRe: sql server 2000 stored procedure Pin
vimal_yet25-Dec-07 22:30
vimal_yet25-Dec-07 22:30 
GeneralRe: sql server 2000 stored procedure Pin
N a v a n e e t h25-Dec-07 23:15
N a v a n e e t h25-Dec-07 23:15 
AnswerRe: sql server 2000 stored procedure Pin
John-ph26-Dec-07 18:34
John-ph26-Dec-07 18:34 
GeneralRe: sql server 2000 stored procedure Pin
N a v a n e e t h26-Dec-07 18:57
N a v a n e e t h26-Dec-07 18:57 
John Prabhu (J O N) wrote:
These sqeuence of action happens every-time you execute a inline-sql where as in stored procedure it happens only once and the execution plan is Reused. This is the reason why Stored Procs are Faster than the inline-SQL's.


All the queries executed will be cached and re-used. It's not only for SP's.

John Prabhu (J O N) wrote:
compiled and the execution plan is stored in the SQL Server's cache for subsequent execution. They are Precompiled collection of Transact-Sql Statements where as in the case inline-sql the statements are dynamically checked for syntax errors, then parsed, compiled and execution plan is prepared at the time of execution.


SQL server won't keep the execution plan in cache when SP's are created. It will check for the syntactical errors, but it's not precompiled. For both AD_HOC and SP's, execution plan would be prepared at the time of execution. And SQL server can retain all execution plans for all queries, not just SP's.

John Prabhu (J O N) wrote:
his is the reason why Stored Procs are Faster than the inline-SQL's.


Still I don't think they are faster that inline-SQL's. It depends on the scenario where you use them. If you are using SP's for just Insert/Update/Delete, I don't think there would be drastic performance boost.


All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions


GeneralRe: sql server 2000 stored procedure Pin
John-ph26-Dec-07 19:27
John-ph26-Dec-07 19:27 
GeneralRe: sql server 2000 stored procedure Pin
N a v a n e e t h26-Dec-07 19:37
N a v a n e e t h26-Dec-07 19:37 
GeneralRe: sql server 2000 stored procedure Pin
John-ph26-Dec-07 20:14
John-ph26-Dec-07 20:14 
GeneralRe: sql server 2000 stored procedure Pin
Mike Dimmick31-Dec-07 0:57
Mike Dimmick31-Dec-07 0:57 
GeneralIdentity in a field Pin
M. J. Jaya Chitra25-Dec-07 17:03
M. J. Jaya Chitra25-Dec-07 17:03 
GeneralRe: Identity in a field Pin
KANGAROO_25-Dec-07 18:06
KANGAROO_25-Dec-07 18:06 
GeneralRe: Identity in a field Pin
M. J. Jaya Chitra25-Dec-07 19:07
M. J. Jaya Chitra25-Dec-07 19:07 
GeneralRe: Identity in a field Pin
Dave Kreskowiak26-Dec-07 9:09
mveDave Kreskowiak26-Dec-07 9:09 
GeneralRe: Identity in a field Pin
M. J. Jaya Chitra26-Dec-07 16:49
M. J. Jaya Chitra26-Dec-07 16:49 
GeneralRe: Identity in a field Pin
vimal_yet27-Dec-07 1:00
vimal_yet27-Dec-07 1:00 
GeneralRe: Identity in a field Pin
Dave Kreskowiak27-Dec-07 5:07
mveDave Kreskowiak27-Dec-07 5:07 
Generalaccess to temprory table colum in Mysql Pin
sepel24-Dec-07 20:48
sepel24-Dec-07 20:48 
Generalerror in sql 2005 Pin
break_day24-Dec-07 4:24
break_day24-Dec-07 4:24 
GeneralRe: error in sql 2005 Pin
Paul Conrad26-Dec-07 12:12
professionalPaul Conrad26-Dec-07 12:12 
QuestionHow to insert record from XML document without using sp_xml_preparedocument procedure Pin
Software_Guy_12323-Dec-07 22:59
Software_Guy_12323-Dec-07 22:59 
GeneralRe: How to insert record from XML document without using sp_xml_preparedocument procedure Pin
Paul Conrad6-Jan-08 10:01
professionalPaul Conrad6-Jan-08 10:01 
Questionhow can export my image data... Pin
koolprasad200323-Dec-07 18:01
professionalkoolprasad200323-Dec-07 18:01 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.