Stored Procedure

Welcome to the 'Stored Procedure' tag page at Technorati. This page features content from the farthest reaches of the Blogosphere that authors have "tagged" with 'Stored Procedure'.

Latest blogosphere posts tagged “Stored Procedure”

• Returning string value from a stored procedure in sql server 2005 to vc# ide code at runtime

  
  IT answers — Authority: 457
  New Question Created by Pushan1234
  6 days ago

• AS400 stored Procedure,what is the maximum parameters

  
  IT answers — Authority: 457
  New Question Created by AmuthaTPT
  6 days ago

• SQL SERVER – Size of Index Table – A Puzzle to Find Index Size for Each Index on Table

  
  Journey to SQL Authority with Pinal Dave — Authority: 538
  It is very easy to find out some basic details of any table using the following Stored Procedure. USE AdventureWorks GO EXEC sp_spaceused [HumanResources.Shift] GO Above query will return following resultset The above SP provides basic details such as rows, data size in table, and Index size of all ...
  2 weeks ago

• SQL SERVER – Size of Index Table – A Puzzle to Find Index Size for Each Index on Table

  
  Visit SQLAuthority.com — Authority: 128
  It is very easy to find out some basic details of any table using the following Stored Procedure. USE AdventureWorks GO EXEC sp_spaceused [HumanResources.Shift] GO Above query will return following resultset The above SP provides basic details such as rows, data size in table, and Index size of ...
  2 weeks ago

• Find a stored procedure containing

  
  Microsoft Technology, .Net, BizTalk, Sharepoint & etc. — Authority: 119
  Quite often you need to find which stored procedure contains key word. I find this blog and use SELECT ROUTINE_NAME, ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE %foobar% AND ROUTINE_TYPE=PROCEDURE
  3 weeks ago

• SQL SERVER – Stored Procedure are Compiled on First Run – SP taking Longer to Run First Time

  
  Journey to SQL Authority with Pinal Dave — Authority: 538
  During the PASS summit, one of the attendees asked me the following question. Why the Stored Procedure takes long time to run for first time? The reason for the same is because Stored Procedures are compiled when it runs first time. When I answered the same, he replied that Stored Procedures are pre-compiled, ...
  3 weeks ago

• SQL SERVER – Stored Procedure are Compiled on First Run – SP taking Longer to Run First Time

  
  Visit SQLAuthority.com — Authority: 128
  During the PASS summit, one of the attendees asked me the following question. Why the Stored Procedure takes long time to run for first time? The reason for the same is because Stored Procedures are compiled when it runs first time. When I answered the same, he replied that Stored Procedures are ...
  3 weeks ago

Comments about Stored Procedure